Viewing 15 posts - 1,516 through 1,530 (of 3,232 total)
I'm a bit confused by your last example. Your update does not show anything being updated. It sounds to me like your business key is Project_ID, Product and...
January 9, 2009 at 10:43 am
I'm not sure of the answer here, but I see that this post has been sitting out there quite a while.
An easy way to find out would be...
January 9, 2009 at 10:37 am
I'm not sure I follow you 100% here. Can you give an example of how you want to call the SP and what you expect to be able to...
January 9, 2009 at 10:36 am
nwlibrarian (1/9/2009)
January 9, 2009 at 10:28 am
I am not aware of it being depricated. It exists in SQL Server 2008 as well.
January 9, 2009 at 10:23 am
Yet another way, using Matt's example to build on.
create TABLE #temp (ID INT IDENTITY (1,1) PRIMARY KEY CLUSTERED, ServerName sysname, DBName sysname, Size int, ReadingDate datetime)
EXEC sp_MSforeachdb ' USE ?
INSERT...
January 9, 2009 at 10:14 am
Mike and Chris are absolutely correct. You need to explicitly list all columns that you want to select in the SELECT clause of your statement. This is just...
January 9, 2009 at 9:52 am
rtbhosale (1/9/2009)
I have tried the BULK INSERT by using .csv file it is working correct.
Because i have not specified the KEEPIDENTITY attribute it was giving incorrect result.
Thank...
January 9, 2009 at 9:26 am
Would you mind if I asked why you would want to do that anyway? Is this for a report? Are you planning to reference the value as a...
January 9, 2009 at 9:21 am
It sounds like you're aware of this already, but it's worth mentioning. Depending on the insert volume and size of these tables, adding the clustered index on a GUID...
January 9, 2009 at 9:14 am
1. Create New PK on parent table.
2. Drop FKs to child tables.
3. Add new parent PK column to child tables.
4. Update Child table with new PK value from parent -...
January 9, 2009 at 9:07 am
OK, sorry. Here's a bit more info into the interworkings of this.
First, the Result Set tab on your Execute SQL task to get your hosts needs to be set...
January 7, 2009 at 3:16 pm
This one is fairly straight forward. In fact, there is a good exampe out on Pragmatic Works web site that I don't have time to locate for you. ...
January 7, 2009 at 2:07 pm
You'd have to store the individual results in some sort of temporary storage (table variable, temp table). Better yet, don't use a cursor. If you are cursoring through...
January 7, 2009 at 12:48 pm
Viewing 15 posts - 1,516 through 1,530 (of 3,232 total)