Programming SQL

insert BLOB from web source
Hi, I'm trying to fetch and insert an image into a column, but I keep getting an error: Cannot bulk load because the file "http:\ \www.google.co.uk/images/nav_logo7.png" could not be opened. Operating system error code 123(error not found). Here is my query: declare @BLOBTest table (BLOBName VarChar(50), BL... 3 Mar 2010 04:05

Editing Multiple SPs
Is there any way I can making the same tweak to 100 SPs without having to script them all out into a big file and edit that file in MS Word? Is there a more clever way to do it? Anything in SQL 2008? Any 3rd party tools? ... 2 Mar 2010 11:16

NTUserName not working in Profiler as a filter.
We are running traces and tried to use NTUserName as a filter. If I have "Like" = "joe" and joe is not an NTUserName - it still displays the traces. The Column shows nothing in the NTUserName when stored procedures come across from my web page. I expected that since this is tracking a web page and not logged... 5 Mar 2010 11:42

Retrieving records between dates
Here is my table: CREATE TABLE [dbo].[FD__PROGRAM_CLIENT]( [ClientKey] [int] NULL, [PgmKey] [int] NULL, [Date_Admit_Program] [datetime] NULL, [Date_Discharged_Program] [datetime] NULL, CONSTRAINT [PK_SYS_FD__PROGRAM_CLIENT] PRIMARY KEY CLUSTERED SAMPLE DATA: 609 6 2008-0... 2 Mar 2010 11:16

parse uri
Hi, I have uri query string in a database field like this: com=123&user=234&order=01 com=123&user=234&order=02 how to parse the string and get each value: com=123 user=234 order=01 com=123 user=234 order=02 Thanks... ... 2 Mar 2010 03:32

sql server deadlock (keylock)
hi guys, I have two procedures: one for selecting data from a table and do some calculations and the other for update or insert into the same table. There are two indexes on that table: one clustered (primary key): Pk_Table and one nonclustered: Ix_Table. I've captured a few deadlocks on those two procedure ... 2 Mar 2010 11:16

How do I get scalar value of a child stored procedure?
Hi, I'm trying to execute multiple stored procedures from a parent storedproc. One of the child stored procedures returns a value which I need for the next child stored procedure I need to execute in the parent stored procedure. I used the following syntax but looks like it's not the correct one. Could someo... 1 Mar 2010 17:38

how to return previous week from calender table
Hello, I have a calender table that contains the field week_number numeric(6,0). I would like to know if there is a way to retrieve the previous week for every week that is defined in the calender table without using the CROSS APPLY command. Thank you for your help. -- Message posted via SQLMonster.com ... 2 Mar 2010 15:50

Copying Information
Hello everyone, I'm having trouble copying data from a table ( st ) in one db ( tecnicil_industria1 ) to the same table in a different db ( tecnicil_ind2010r ). Below is my query and the result error I'm getting. Can any help on how to go about doing this: Use tecnicil_ind2010r Go insert into st select *... 1 Mar 2010 06:59

Logshipping from SQL2000
Hello, I have ServerA which is SQL2000 Enterprise Edition(latest sp) and ServerB which is SQL2008 Developer edition(latest sp). Can I set up Log Shipping from ServerA to ServerB? tia, AbbA ... 1 Mar 2010 06:59