Answer Questions

• Jhedron How to split a transaction table to create training and testing set for AR

  Hi all, I have a transaction table that has a composite key made up of transaction id and product id. where multiple products were purchased under same transaction, transaction ids got repeated. I would like to split the table randomly into 70%, 30% ratio to create training and testing set respectively in such a way that it does not split a same transaction under which multiple products were purchased (rows with same transaction id should not get split). is it possible if possible what is the idea It would be of great help. Thanks. Fakhrul Hi Bogdan and Jamie, The SSIS trick worked when I modified it according to your suggestions. Thanks a lot. Cheers! Fakhrul ...Show All

• Daniel Hilgarth Unicode characters stored incorrectly in SQL 2005

  I have SQL 2005 installed as back-end for MCMS 2002 , when storing a unicode content like Arabic , and query it direclty from SQL it appears like كيف الحال The english text stored correctly and can be read. Note that same senario with SQL 2000 the unicode data cane be viewed correctly. Regards Does this affect operation of MCMS or not   Could you please list data types for SQL Server 2000 and 2005 in this case Did it change Is it ntext or nvarchar() vs. ntext and varchar()   I’m not familiar with MCMS but they may be choosing to store data HTML encoded ( ) and use single-byte data type as oppos ...Show All

• Lotfi1 connection problem

  Hello! i'm having a problem with my web aplication. I'm using a net 2.o login in my apliction and mssql express 2K3 server and app_data i have the aspnetdb where are logins for page. When i'm usinng a web form in localhost works fine but from the internet i'm getting a error : Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. This is just a piece of error, have anyone some idea what's wrong OK! problem solves, i found a solution in another post, tnx anyway :) OK! I found a solution on this post : http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=130715&SiteID=1&PageID=1 It sounds like your aspnet app is using wi ...Show All

• shmulik_segal c# UI Escape character problem to execute command line

  Hi! Thanks For your reply! but this is very urgent please help!!!!!!! I need one more help in this issue. what if i do not need any \ " for e.g: i am trying to set conn string and varaible value jobCommand = new SqlCommand("xp_cmdshell 'dtexec /f \"" + path + "\" /Conn \"" + Packconn + "\" \"" + connect + "\" '",cconn); i am getting some value like this : CommandText "xp_cmdshell 'dtexec /f \"D:\\SSISProject\\Integration Services Project1\\ArchiveMainMultiTables.dtsx\" /Conn \" SE413695\\AASQL2005.TestDB; \" \ "Provider=SQLNCLI.1;Data Source=SE413695\\AASQL2005;Initial Catalog=TestDB;Provider=SQLNCLI.1;Int ...Show All

• moemen.ahmed Team development issue when debugging applications

  Hi, At the moment I am working on an asp.net 2.0 application where we use sql server 2005 as database server. We are building this web application with 5 developers in paralel and we noticed that when one developer is debugging the application (hanging in a breakpoint), other developers get a sql time-out exception. Yes we are using Transactions (System.Transactions namespace) but we have totally no idea why this side-effect is occuring. Any suggestions or tip is more than welcome ! Grtz If I understood you have locking problem. Try use snapshot isolation on statement level. Run: alter database  <your database> SET READ_COMMITTED_SNAPSHOT ON More info about snapshot isolation: http://msdn2.m ...Show All

• JiltedCitizen Can't run Business Intelligence Development Studio

  All, I've installed SQL Express with advanced services and the BIDS software from the SQL Toolkit using the vs_setup.msi extracted from the toolkit installer (Why not include it in the advanced services ). Now I'm trying to start BIDS and am asked to log into the Report Server. I use my username and password for ASPNET. The login fails saying that the web application is not available on the web server and to look in the application event log for more information. There are a bunch of errors listed (and more every 30 seconds are so). The error message is: aspnet_wp.exe could not be launched because the username and/or password supplied in the processModel section of the config file are invalid. Also, when I start Visual Web D ...Show All

• FergusLogic Typical Data Load question

  I need to import typically 5000 - 50000 rows of data to OLTP database from a flat file. Flat file contains all active information - new & existing rows. About 10% of the rows are new. Each row has about 30 columns. I have created a Data Flow which divides the data to new records (for insert) and existing records(for update) via the Lookup transformation (as described in Jaime Thompson blog - thanks). The question is - in performance perspective - should I check if the existing records have been changed or not Currently I do a full refresh of all data - (my opinion is that in SQL side - if you update a row with exact same data - it will not cause SQL server to "perform row update") - however I'm concerned that SSIS performin ...Show All

• Vinci Copy annotations out of xml/ dtsx package

  Is there a way to strip out the annotations from a dtsx package. I'm looking at quite a few and would like to automaticly pull those out and store them somewhere in either a table or a text file. Is this possible or am I going to have to hand copy them out Thanks for the help Saitham8 Kirk, You are correct. The annotations are stored in the package. However, as I documented in my reply to Michael Entin - MSFT , there is a bug in BIDS that caused the behavior I described. Essentially, if all you do is add or modify annotations those changes do not get saved at all. That is why I only saw changes in the .suo So it sounds like I'll need to move up to sp1 and then take a look for the anotat ...Show All

• Daikoku Problems with Excel COM and msiInstaller

  Hello there I have spent some days now trying to solve this problem and I didn't find a solution yet. So, may be there is somebody out having solved this issue... I am using Excel on a server. But it seems that there are problems between the DCOM and the NT AUTHORITY/NETWORK SERVICE. The event viewer is showing two warnings each time the excel is started: - Event ID: 1015 Description: Failed to connect to server. Error: 0x8007005 - Event ID: 1004 Description: Detection of product '{90120409-6000-11D3-8CFE-0150048383C9}', feature 'ExcelUserData', component '{8ADD2C96-C8B7-11D1-9C67-0000F81F1B38}' failed. The resource 'HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\UserData' does not exist. Both of them have the source &q ...Show All

• Fistandantilus282303 Remove "All" and Keep "select All" from parameters

  I know that when you select Multi from the parameter report properties, that it automatically makes "Select All" Available. So how would i take off the "All Value". My users dont want to see All, if Select ALL is available. How do i exclude from "All" from my report parameter/dataset Are you returning "All" from a stored procedure or is it one of your multi value parameter value ...Show All

• Denis Pitcher Auto Number Sequence

  How can I create a number sequence starting at a certain number and continue on for the number of records I have. For example I have 3000 records in my table and a field named I created called RecordId which I'd like to start at number 1 and goto 3000 (or maybe even start at 9000 and goto 12000 or however many records there are). In my pseudo SQL code Im guessing it would be something like... select * from Incident update Incident set RecordId( i=9000; i<=Number of Records in Table; i++) Whats the easiest way to do this hi, you can use the identity function make use use of its parameter seed=3000 to start from 3000 here's the syntaxt identity(seed, increament) ...Show All

• Coritani Problem with sql2005-kb918222-x86-enu.exe (cumulative hotfix, build 2153)

  Hello, I do experiment a problem when trying to install the mentionned patch on my Windows XP SP2 machine (fully patched). Interestingly, the patch works fine for the named instance, which is a "clean" install of SQL Server 2005 SP1, while it fails on the default instance, which is a SQL 2005 SP1 upgraded in place from SQL Server 2000 SP4. Both instances are Developer editions... The error is along the following lines: [snip] 08/10/2006 09:22:06.728 Unable to install MSP file: \\DHDHY0J\c$\1c7c01591e524f9a092159a233\hotfixsql\Files\sqlrun_sql.msp 08/10/2006 09:22:06.818 The following exception occurred: Unable to install Windows Installer MSP file Date: 08/10/2006 09:22:06.818 File: \depot\sqlvault\stable\setupmain ...Show All

• INTPnerd How to count the number of textboxes

  Hi all,   In the report I am working on, I have a "textbox39" in a table which has groups. I want to have another "textbox29" outside the table to count the number of "textbox39"s that are actually displayed and also the number of "textbox1"s that have a certain value (e.g. "1") in the final report. I tried to use " Sum(ReportItems!textbox39.Value)"  but the compiler complains   Error 1 [rsAggregateReportItemInBody] The Value expression for the textbox 'textbox29' uses an aggregate function on a report item.  Aggregate functions can be used only on report items contained in page headers and footers. d:\perf\perfreportingproject\PerformanceTestDetails v.3.rdl 0 0  ...Show All

• K.S.RamakrishnaPrasanna How to display Interactive Excel file using sql reporting services

  I need to display an raw data and graph in multiple work sheets in excel features having formula's and color combination from sql reporting services . So that users see the graph changes when user change the data in the excel file . I would like to get sample solution in .net without using any third party component which is listed below with .net environment for interactive excel . http://officewriter.softartisans.com/officewriter-128.aspx#EXCEL http://www.softwarefx.com/SFXNetProducts/CFXforNET . Also wanted to know using sql reporting services is it possible to show line graph in web page Client Machine will have Spreadsheet: Microsoft Excel 2000 Windows 2000 Internet Explorer 5.0 ...Show All

• syndicate Print Reports on Legal Paper

  While working in the report project in Visual Studio, I set my Report Layout to 14w x 8.5h with .25 margins on all sides, and the page size to be 13.5in (to take into account the margins). When I print from the report viewer control in Preview mode, the report prints as it should, in Landscape on Legal paper without me changing any settings. When I deploy the same report to the report server, and print from there, the report prints in Landscape on Letter paper (which causes some columns to print on a second page). Why is there a difference in the two environments Is there something I'm missing The goal is for the users to be able to print the report correctly without having them change any print settings in the dialog. ...Show All