Topics
Started by
Posts
Last post
I need some help creating a T-SQL query and was hoping some of you folks could help me out. The qu…
4 replies
I have a table with 2 date columns. cbTransEffectiveDate and cbExpirationDate. Both of these column…
5 replies
hi experts i have two servers of which i need to create union query for my report when i run the qu…
5 replies
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
By: bdba
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
By: franksj
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
By: LutzM
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
By: Dugi
I am attempting to define a view that includes a recursive CTE so that the view can be joined to ot…
1 replies
Viewing 15 topics - 10,546 through 10,560 (of 10,635 total)
You must be logged in to create new topics.