Viewing 15 posts - 151 through 165 (of 192 total)
Can you make use of SQL server full text indexing?
Either way I could suggest a few options.
November 10, 2006 at 5:43 pm
To break it down:
With is part of the syntax of creating a Common Table Expression
http://www.databasejournal.com/features/mssql/article.php/3502676
If you look at the bit between the ()'s there are two select statements....
November 10, 2006 at 10:52 am
It's worth pointing out that I have about a 5 hour window to run this so it may need to span multiple days. One approach I had considered would be...
November 10, 2006 at 10:14 am
It looks like I made a mistake in the Schema def. The Clustered Unique key is actually on Cust_num, Order_Id.
Almost all selects will join cust_num with another table also clustered...
November 10, 2006 at 10:06 am
Hi Jeff, I agree with you on the global temp table. In the query I actually use the current SPID as part of the name. It's not perfect but I...
November 10, 2006 at 9:16 am
how about this:
Be careful of overflowing the 4000 byte variables and if there are more values for request you could expand this out to generate the insert statements dynamically too.
November 9, 2006 at 4:32 pm
If you are using SQL2005, you could use the PIVOT() function. If you aren't you can get around this using dynamic SQL.
Give me a few minutes, and I'll code up...
November 9, 2006 at 3:43 pm
I should have read the question in more detail, I'm sorry. INSERT INTO...EXEC Isn't going to do it because you only want specific columns.
You could insert your results into...
November 7, 2006 at 5:00 pm
INSERT INTO table1(ColA, ColB, ColC)
EXEC StoredProc1 'Param1'
November 7, 2006 at 4:42 pm
Yikes! I've been there a few times.
I suspect this isn't quite what you ment, but I have found this to be an extremely useful app.
http://www.securiteam.com/tools/6J00S003GU.html
Please tell me...
November 7, 2006 at 4:26 pm
Cool. If you like I'll send you what I've been working on. It is a proc that performs analysis and resolves drift (both one way and two way) It will...
November 7, 2006 at 10:31 am
Sorry to chime in so late, but this sounds a lot like something I was working on awhile ago.
Are you performing some sort of data drift analysis between servers?...
November 6, 2006 at 4:52 pm
Ninja is correct and perhaps we both should have made that more clear, that the code was to demonstrate the general concept, and not a snippit to be used verbatim...
November 3, 2006 at 9:44 am
Good point Ninja,
10000 would definitly be a more appropriate number. Depending on the width of the table, you could probably increase that number even further without SQL Server acquiring a...
November 2, 2006 at 12:42 pm
Read this if other processes are going to need to read from or write to during the update:
Vladin's suggestion of breaking the update into chunks is worth considering. When you...
November 2, 2006 at 10:04 am
Viewing 15 posts - 151 through 165 (of 192 total)