Hello I'm new to SQL - I'm trying to update multiple rows in a table. Table - Column values - ID | Name | IsCrazy This is my query UPDATE table SET IsCrazy = 'True' WHERE ID = 1,20,3,4,50 I am having a problem with the "WHERE ID =" part. I have multiple id's that I need to...more >>

I want to pass array of int into a stored procedure to use it as a list for a IN clause. I already found this article which use an XML string parameter but i think it's overkill http://support.microsoft.com/?scid=kb%3Ben-us%3B555266&x=16&y=11 Maybe someone have something more simple ? Than...more >>

Hello there I have one script that create data in size of 10Gb. when i run it only one processor use it. How can i cause other processors to join in the insert of the script? ...more >>

Hi, How could I use SMO to deploy to SQL Server the CLR stored procedures, that are compiled into the dll? Thanks, Lubomir...more >>

New to NOLOCK in general.. but would like some advice or suggestions.... We are using SQL2005 for our online application. Everything seems to be working fine but its hard to track an issue when there is no error returned.. Example.. Location 1 completes a form online and submits it.. ...more >>

I have a problem with SSIS Excel Connection Manager popping up a message box, which asks me to enter a Username and Password for the Excel spreadsheet. The spreadsheet is not protected by a username/password. Anyone have any ideas what I might be doing wrong? Thanks ...more >>

I am obviously missing something. But I have a SP that works great. I pass 1 or 2 parameters. If I don't pass the 2nd parameter it gives me all the records for a particular user. The problem is that I copy and paste the stored procecure to an Sql Query window and change the first part of...more >>

is there a t-sql guru that can help me on these: find top 5 i/o consumer find top 5 cpu consumer top 5 sql statements in lock contention for index and table. thanks....more >>

So I havent done any SQL queries lately that are beyond basic... I was hoping maybe somebody can point me in the right direction. I guess the best thing to do is give an example of the tables and the result that i am attempting to get TABLE: PERSON ID NAME ---------...more >>

Hello, How can I duplicate a 2005 SQL Database giving it a different Name like "dbName_2" original name is "dbName". Thank you, Lit ...more >>

I have a database with duplicate records. Is there a query I can run to remove the duplicates. Example: "1", "Item1" "2", "Item2" "3", "Item2" <-- duplicate "4", "Item3" "5", "Item3" <-- duplicate "6", "Item3" <-- duplicate "7", "Item4" "8", "Item5" "9", "Item1" <-- duplicate ...more >>

Hi everyone, This is supposed to be a simple Query. It basically is a Select statement that builds a string (a comma delimited string) and inserts certain values into it from a table. It was originally built using cursors (yike !!) and I am trying to modify it to run as a set-based query. Curso...more >>

Can someone help me please figure this out. I have a table of products and a table for prices, like this: Table Prices PriceID ProductID MinQty MaxQty Price 1 1 1 3 6.00 2 1 4 7 5.50 3 1 ...more >>

can we migrate data or restore/attach data from SQL Server 2005(SP2) to SQL Server 2000(SP1)? is there any data loss or any effect? backword migration The reason I am asking because we migrated the sever from SQL Server 2000 to SQL Server 2005 but we are having some problem and thinking to go...more >>

I am testing some speed issues I am having with a use of scalar udf inside of SELECT statement. Even if udf does not do anything by simply having return 1 as a first line of the code still it takes much longer then if I dont call it at all. Any idea why? Thanks ...more >>

I have a stored procedure declared as follows: create procedure usp_validate @db_name nvarchar(4000) = NULL In the procedure, I have a code similar to this if @db_name is null select dname from InfoTable else select dname from InfoTable where dname in (@db_name) ...more >>

I have a SQL Server 2005 instance (A) that has a store procedure that through a Linked Server executes another stored procedure on a different SQL Server 2005 instance (B). The second stored procedure trys to execute a stored procedure on the first instance (A). This last stored procedure fa...more >>

Hello, Not sure if this is the right group to ask, if not please direct. I have an application to be filled out by users and the application have some sections like: Company Info( name, addresses, phones, emails) Contact Info ( name, phones, emails) References Info ( names, phones, emai...more >>

I have a fairly complex query that I noticed was running way too slow. I isolated the problem to one line (@UserID = 0) For the sake of simplicity I will make the SQL statement a bit smaller than the one I am using. THIS WORKS GREAT CREATE PROCEDURE procTest (@ID int = 0, @UserID int = 0) A...more >>

I have a field in my database 150 Summer St#450 It contains a CRLF after St and before #. I need to extract this data in 2 pieces. I need to select all the characters before the CRLF and all the characters after the CRLF. Is there an easy way to do this? ...more >>

I need to create records in a table from already existing records modifying one one column. However, I need to do this insert if such record does not exists yet. Here is the example: TABLE_A: id stateID program -- -------- ----------- 1 7 12 2 7 13 3...more >>

I have the following query. select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;HDR=yes;IMEX=1;DATABASE=E:\Update.xls', 'Select top 1 * from [Sheet1$]') Sometime it works, sometiem it raises error: OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" return...more >>

Dear All, How can we write a query in MS Access that needs to run against a SQL Server database? And what and all the parameters and connection strings\user permission that has to set for achieving this? It vl be highly appretiated if someone can explain it in a step by step procedure. ...more >>

Hello - I have a Sql Server 2000 production database that has to be moved to Sql Server 2005 on another production server. The data file is 42 MB and the log file is 388 MB. I have three issues I am concerned with - 1. Size of the log file - it is set to Autogrow by 10%; unrestricted fi...more >>

Can anyone assist me with the below SQL statement that I created? The results return show the information multiple times on seperate lines. I just want it to return it once so it doesn't create one long list that is the same. SELECT CollectionID FROM v_FullCollectionMembership WHERE Collect...more >>

Hi, Can anyone tell me what the best resource is for finding out about the system tables, what they contain and how to work with them (just querying them, not modifying them)? Recently I needed to know whether a stored proc was being used in a database or whether it could be removed. It took ...more >>

I have a table that contains ranges of zip codes(ie 00000-00001). I want to be able to check those ranges to make sure that new records dont overlap or equal to existing ranges. Does any one have a suggestion to how I could go about doing this? EggHeadCafe.com - .NET Developer Portal of Choice ...more >>

Hi All I have a table that contains a list of codes ( Varchar exple : 411253 , 411524 ....) I would like to determine the repeated codes Thanks for your help ...more >>

Hello, I backed up the database to a .bak file and would like to recreate it on another computer that will be used for development purposes. I tried logging into SSMS and right clicking on the Databases object then selecting Restore and referencing the .bak file. This displays an error s...more >>

This procedure returns no records, can anyone suggest why? ---------------------------------------- CREATE Procedure sp_1 @datetouse datetime As SELECT c_1,c_2 FROM tablec where c_date>=@datetouse and c_date<@datetouse+1 ----------------------------------------- Thanks. ...more >>

Just started learning SQL through SQLServer2005 (and MySQL) What is SELECT section of the following doing when it executes: USE myDatabase SELECT 1 FROM myTable + why does the result grid appear whilst this query is still executing? Any help greatly appreciated J reason I as...more >>

One user runs this query from Access: SELECT DISTINCT moneymart.dbo.Invoice.Service_Date, moneymart.dbo.Invoice.Invoice_ID, moneymart.dbo.Invoice.Number_of_Services, moneymart.dbo.Invoice.Total_Fee, moneymart.dbo.MergedChargeAdvice.Consolidated_CMB_code, moneymart.dbo.MergedChargeAdvic...more >>

Hello, I have 2 tables : table1 and table2. Everytime a row is updated in table1, a trigger must copy the updated row from table1 to table2. It's easy to copy all the records with following trigger : CREATE TRIGGER UpdateTable1 ON Table1 FOR UPDATE AS INSERT INTO Table2 SELECT * FROM Tab...more >>