Topics
Started by
Posts
Last post
we have a script that ran fine on sql 2000 - we have now moved it to a different server running sql…
3 replies
Hi All, The situation is like this, We have to create the same reports for different clients. Each …
5 replies
Hi Let me know if you have any feedback or alternative other than below, Posting a sample scenario …
2 replies
We have some old sql2000-centric code that runs this query: "select description from sys.messages w…
2 replies
We recently upgraded from Server 2000 to 2008 and have been getting some performance issues with so…
3 replies
If I have a query such as the one below I wrote using the Adventureworks Database, is there a more …
4 replies
So I have obtained a copy of 2008, installed it on my laptop, and am now looking at what's new (I'm…
10 replies
I have a Column with some values as shown below Table A C1 3 4 5 6 I have to generate total 18recor…
12 replies
In Sql 2000 this type of statement worked as expected: Select * FROM {table} where EnterDate = '02/…
3 replies
This problem also occurs in SQL 2000 with any formula the order by clause, but the formula variant …
2 replies
One of the developers came up and asked me what happens if I run this query: SELECT 1.ColumnName I …
43 replies
I am attempting to define a view that includes a recursive CTE so that the view can be joined to ot…
1 replies
I have created 1 table name staffidentity where i have passing fingerprint images. i have converte…
1 replies
declare @csv varchar(MAX) -- the CSV we are being passed set @csv = '1,2,3,7,4,8,10' -- our list o…
6 replies
ColA ColB A 1 B 20 B 23 C 2 C 23 D 5 D 56 D 67 My result should be ColA ColB A 1 B 20,23 C 2,23 D 5…
2 replies
Viewing 15 topics - 10,561 through 10,575 (of 10,647 total)
You must be logged in to create new topics.