Topics
Started by
Posts
Last post
I have the following statement that worked until I tried to nest it with the above CASE WHEN (SELEC…
2 replies
Does anyone have any routines to Search & Replace text in a TEXT or NTEXT field? The REPLACE S…
1 replies
I have asked to do a comparsion various columns in 2 tables with the same table structure, for exam…
12 replies
I want to do a select that will pull all four rows in a table of two columns (a and b) but tagged o…
1 replies
I want to do a select that will pull all four rows in a table of two columns (a and b) but tagged o…
1 replies
Hey all, I have a sproc that allows users to query a table using any combo of optional parameters. …
4 replies
I have a scenario that I am having problem implementing. I have 4 tables: tblproject, tbltask, tbls…
6 replies
Does anyone know how a batch file can determine if ISQLW has processed SQL commands without errors?…
3 replies
We have a simple UPDATE statement that is really chewing up CPU time (~8000 in profiler) The durat…
9 replies
I need to create a query that grabs the first 2 digits of a persons last name for all people in a t…
2 replies
Is it right that I get 1908 times more reads than I do writes when performing an INSERT INTO comman…
2 replies
I want to update my pricing table but I am having a problem with the rounding issues. I can not ch…
2 replies
Hi, I always use SET NOCOUNT ON statement in all my sprocs to improve performance (as stated in the…
1 replies
How do I validate values of a table for two columns? for example, I have an employee table with a s…
1 replies
What is the proper way to write this CASE scenario. What I am trying to do is select the value fro…
13 replies
Viewing 15 topics - 15,676 through 15,690 (of 17,082 total)
You must be logged in to create new topics.