Viewing 15 posts - 16 through 30 (of 69 total)
jgao,
Thanks for pointing that out.
October 13, 2008 at 5:58 pm
Actually, you did not include the function body. You would need to add the following for it to work:
RETURNS @tblArray TABLE
(
ElementIDsmallintIDENTITY(1,1), --Array index
...
March 30, 2008 at 3:43 pm
Glad that it worked for you! I grappled with this issue for awhile and when I saw that it was happening on all of our corporate dev machines I...
January 19, 2008 at 3:37 pm
why don't you just return the ids of the values that match the criteria in a table and then do an update on the rows where the ids are in...
December 10, 2007 at 12:13 am
I wrote a function that splits a delimited varchar into a table with an ElementID, and an element column (http://www.sqlservercentral.com/scripts/Miscellaneous/30225/)
You could do something like this in your...
December 9, 2007 at 3:32 am
I found the best solution to the problem where Workstation components won't install if you are installing developer edition and there is an existing instance of sql server 2005 express....
November 22, 2007 at 10:29 am
What a great solution to a common problem. I prefer not to work with XML in SQL unless there is a very compelling need but this is the best...
November 18, 2007 at 11:14 pm
This proc should be very useful in designing networks with custom subnet masks.
November 18, 2007 at 11:08 pm
FYI, this script was created for determining if client upload data was populating the ip address column with the internal network or the public ip address. Internal addresses in...
November 18, 2007 at 10:59 pm
Is a table being added and later dropped perhaps by a stored proc?
November 13, 2007 at 4:22 pm
View this article for detail on the subject http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/2955/
November 1, 2007 at 5:59 pm
What error are you encountering? The issue that I have had in the past has been with the JET driver doing the import. The cells that were not...
October 11, 2007 at 2:27 pm
The script assumes that the table name is not using brackets. Basically, it was written for myself and I posted because I thought it would be useful to others....
October 11, 2007 at 12:07 pm
For more detail on using this procedure, read the SQL Team article that I posted: http://www.sqlteam.com/article/anticipating-primary-key-violations
This gives step-by-step instructions on how to get the most out of this...
October 10, 2007 at 1:22 pm
Viewing 15 posts - 16 through 30 (of 69 total)