Answer Questions

• binod m paul how to get cap file into database

  how to get the cap file into database AA0B0105200706040003021500FF1A7D77 AA0B0105200706040003022600FF1A7E76 AA0B0105200706040003022800FF1A7F7B AA0B0105200706050000070900FF1A8006 AA0B0105200706060003001500FF1A810D AA0B0105200706090000009300FF1A820C AA0B0105200706570003001100FF1A830F AA0B0105200707340003068000FF1A8402 AA0B0105200707400003065500FF1A8508 AA0B0105200707460003068400FF1A8601 AA0B0105200707480003021700FF1A8700 AA0B0105200707500003023200FF1A8801 AA0B0105200707540003022100FF1A8906 AA0B0105200707560003023500FF1A8A79 AA0B0105200707580003023700FF1A8B76 AA0B0105200707590003065700FF1A8C74 AA0B0105200708000003021900FF1A8D7E AA0B0105200708010003067100FF1A8E74 AA0B0105200708030003067800FF1A8F7C AA0B0105200708030003022300FF1A9001 AA0B ...Show All

• bharathi_tunes Restoring a database

  Hullo, I am trying to restore a database rs2005sbsDW from the hard disk but it gives me the following error message. TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: The media family on device 'C:\Documents and Settings\Administrator.UHRC\My Documents\Microsoft Press\RS2005SBS\Setup\Database\rs2005sbsDW.MDF' is incorrectly formed. SQL Server cannot process this media family. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL ...Show All

• mistys77 Measure Dimension

  Hi What's the difference between the two following queries as the returne value of the second one is "#Error" . My aim is to count the number of customers that purchased the mountain product through Internet. I've used the Adventure Works sample database. WITH MEMBER [Measures].[Number Of Mountain Internet Sale] AS DISTINCTCOUNT(EXISTS([Customer].[Customer].MEMBERS, [Product].[Product Line].Mountain, "Internet Sales" )) SELECT [Measures].[Number Of Mountain Internet Sale] ON COLUMNS FROM [Adventure Works] WITH MEMBER [Measures].[Number Of Mountain Internet Sale] AS DISTINCTCOUNT(EXISTS([Customer].[Customer].MEMBERS, [Product].[Product Line].Mountain, [Measures].[Internet Sales Amount] )) SELECT ...Show All

• Hans1982 Editing in Querry Analyzer not in EM

  Hello, In SQL if we want to edit a row in a table then we have two ways to do the same, 1. Execute a command to Update the records in sql through querry analyzer. 2. Go to enterprise manager and then open the table and update a new row. But can't we do the editing in the querry analyzer is there any way to do this. That means i select all the records from my table using the following querry. Select * from MyTable and then performs editing in the querry analyzer without executing any update command and without using the Enterprise manager. Can we do this Bye and TC Yes. You can do this. In the Query Analyzer, expand the Object Browser (left side pane of your QA window) upto your desired tabl ...Show All

• Enzoe TRyign to extract Top 3 records using Partitioning

  Hello, I have a table containing 3 columns Department Name, RiskScenario and Cost. I am trying to create a data extract that contains the top 3 Risk Scenarios (sorted by Cost) per Department. I tried using this sql statement in MSQuery but it doesn't work. Any ideas where I'm going wrong or if there is a simpler way to do this Select * from ( Select DepartmentName, `Risk Scenario`, Cost, row_number() OVER (PARTITION BY DepartmentName order by Cost) rn FROM 'Departmental Risks`) where rn <=3 Please help. Just can't figure this out! Meera it's not just a naming the derived table. you need to use rank() to get the top 3 per grou ...Show All

• BlueBeetle Bulk insert and splitting content into collumns

  Hi, when i try to load XML file into a table with bulk insert, i get bunch of errors: Msg 4864, Level 16, State 1, Line 2 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 1 (cislo_subjektu). My guess it is, that it has something to do with 11 different collumns defined in dbo table and this command's lack of some specification about where to put which value. BULK INSERT pokus.dbo.organiz FROM 'D:\organizace.xml' /* my file */ WITH (FORMATFILE = 'D:\organiz-x-c.xml'); /* formatfile*/ GO Is there a way to split content of loaded file into correct collumn in dbo table When i looked into the format file after creating it with bcp, i not ...Show All

• Troy Lundin Read CSV file - Save Columns into Rows

  I want to import CSV file and convert columns into rows depending on Customer count(2nd record in each row of CSV file) and save to SQL table --CSV file format State, Customer_Count, Name_1, Total_1,Name_2, Total_2,Name_3, Total_3..can go upto 350 GA,2,'John Doe',14.00,'Roger Smith',15.00 FL,3,'John Doe',14.00,'Roger Smith',15.00,'Sally Cox',16.00 SC,5,'John Doe',14.00,'Roger Smith',15.00,'Sally Cox',16.00,'James Brown',17.00,'Rick Davis',18.00 Data in SQL table from csv file should look like this State,Name,Total GA,John Doe,14.00 GA,Roger Smith,15.00 FL,John Doe,14.00, FL,Roger Smith,15.00 FL,Sally Cox,16.00 I have multiple CSV files with millions of records. How can i achieve this using Integration Services or Bulk Data ...Show All

• Can-Ann Need desperate help on a storedProc

  Hi, I'm a PHP Programmer but I need help making a storedProc. basically, if I have orders and want to output the intials of the order taker I need help on that storedProc. So I got the IDClientID select idRessCreatedBy from TBL_quotation where idClient = IDclient now i got the IDresscreatedby and I need to do a substring(firstname,1,1) + substring(lastname,1,1) from tbl_ress where IDresscreatedby = IDresscreatedby Can anyone help me with this storedProc I would very much apreciate it Ok, so I tried the SP and I get this error: Warning : odbc_exec() [ function.odbc-exec ]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'rsGetClientIDbyRessInitials' expects parameter ...Show All

• installer69 Backing up through VS2005

  Hi, not sure I have should ask this in here or in the VS forums - but here goes anyway! My vb app is written using VS2005 with an SQL database. I'm now distributing this to users to use with SQL Express. It's hard enough explaining to them how to attach the database without going into the backup routines etc! So what I'd like to do is to have a "backup" button in my app, that backsup the database, trancates the log files & then shrinks the files. Is this possible This shouldn't be too hard. You can just call the backup command from your application. Regards, Matt Hollingsworth Program Manager Microsoft SQL Server Sample command in VB Dim query as String= &q ...Show All

• WXS123 Changing the 'Command type' dropdown in a custom data extension

  I notice when using a SQL Server data source the Command type dropdown list only shows "Text" and "StoredProcedure". It does not show "TableDirect" somehow. I would like to be able to set this drop down list to show custom values from my CDE Wrapper also. I tried writing an enum in my CommandWrapper class with no results. This was all I could think to try, and it did not work. enum MyCommandType {    Text = CommandType .Text,    Macro = CommandType .Text,    StoredProcedure = CommandType .StoredProcedure } MyCommandType myCommandType; CommandType IDbCommand .CommandType {    ...Show All

• _target_ Upgrade to Sql 2005 from Sql 2000 issue

  Our organization has an accouning package that uses sql. We moved it to a new server running sql 2005, the old server wqs sql 2000. WE detached the databases and moved them to the new one. Our package has a 'screens' database which holds all the user and security info for the system. Within the software there is a 'synchronize with sql' function to add all the users to the new sql 2005 platform. After doing all this we have no problems accessing our data as any user previously setup. When we try to add a new user thru our software package we get the following error, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'CHSVSQL001' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. We only have ...Show All

• jo8888 Open Table not editable, anyone know of a workaround?

  I'm wondering if we can get official word on the post below: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=578917&SiteID=1 Its a real problem with no solution available. So far I can't find a work around and concur with the final analysis. <A quick summary> In SQL 2000 Enterprise Manager, one was able to edit and commit data on-the-fly directly from the results pane. Action->Open Table->Query with the SQL Pane shown gives you an interface similar to Query Analyzer. One could write a complex select statement with where clauses and joins, and the results pane would show the resulting data. The question is this: How do you edit data in the resu ...Show All

• clint 2 Not Printing from the Preview Window in the IDE

  Does anyone else have an issue printing the first time from the preview window in the IDE I understand that they are fixing the issue with having to hit the print button twice, but even after that, the report appears to print, but never makes it to the printer. Thanks! BobP Any news on this as we have this issue also Two servers are displaying this issue: Microsoft SQL Server Reporting Services Version 9.00.1399.00 and Microsoft SQL Server Reporting Services Version 9.00.2047.00 Thanks. To help us figure this out, what version of Reporting Services do you have installed. For what it is worth, we have the same problem ...Show All

• Christian Sparre Package not running when database settings changed to mixed mode

  Hello All, After changing my database settings to Mixed Mode and using SQL server authetication for my source and target connections my package fails. Even when i check the save password checkbox it is not saved! is it a bug in SSIS Has anyone else also come across this problem And how can i log this issue with the SSIS developers I am using the evaluation version of SQL Server 2005 as of now Thanks in advance. Regards, Aman ...Show All

• btb73 Need for Multi-Threaded Visual Basic.NET to SQL Server Data Access Example Code

  Of all the Visual Basic.NET data access books that I have purchased and all the Internet site example code that I have reviewed, none have had any good examples of multi-threaded VB.NET code doing data access. I am trying to avoid the non-responsiveness in a VB app while a simple data retrieval from SQL Server 2005 is in progress. If anyone knows of any book titles or web sites that have example code (good or not) of multi-threaded VB.NET applications doing data access against Microsoft SQL Server (7, 2000, or 2005) or even against Microsoft Access(TM), it would be very much appreciated if you could provide the book title or URL to point me in the right direction. The more examples the better. Thanks in advance. ...Show All