Topics
Started by
Posts
Last post
Hi, I'm trying to debug a stored proc that creates temp tables. In 2000 Query Analyzer, I could re…
8 replies
Correlated sub query takes more time to return result...Please help in spiltting this into join... …
11 replies
I have a temporary table that (based on its current values) would fit nicely one-to-one across two …
5 replies
Hello guys, my question is: Is there any performance defects if I use Try...catch blocks in my stor…
12 replies
How can i stop duplicate values from within a COLUMN being displayed? For example: COL1 COL2 1 …
1 replies
Hi all I have a query which compare two string type "nvarchar" Something like this: if @a = @b pri…
13 replies
Hello, I'm a newbie in developing stored procedures. Therefor this question: Can the script below b…
9 replies
Hi Members, I just find one question from one of my team members "Which type of index is creating …
31 replies
Am I doing something wrong here? I am not that versed in the use of cursors and need some help. ' …
18 replies
Hi.. 1) I want to fetch the 4th highest record from a table. 2) I want to write a storedProc for in…
2 replies
Hi, I think this is pretty common, but I don't know what it's called so I can't search for it. I ha…
2 replies
hi guys is there any way to create a function to put a number of values into different rows. For ex…
20 replies
I need to uipdate a table with 80 million rows as follows: update set val = (val + 10) How can …
1 replies
Got the trigger below but don't know what to do to concatenate the site column and resource column …
8 replies
I'm relatively new to relational databases, so my question is rather basic. I've looked in BOL, but…
6 replies
Viewing 15 topics - 9,286 through 9,300 (of 12,234 total)
You must be logged in to create new topics.