Topics
Started by
Posts
Last post
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
Hi, hope that somebody can help me. I've written a stored procedure that queries table called L_IT…
4 replies
HI, I'm having a problem trying to get a value from a table to be output as an XML Element withou…
2 replies
Hi, any ideas for the next : I have the next table orders_resume id orders 1 45 2 60 3 5 4 1 and no…
1 replies
Hi, I am having a problem display a result when using XML nodes. Here is my script... -- DROP TABL…
5 replies
I have the following data: ID COLOR 1 red 1 blue 1 green 2 red 2 orange 3 pink I need …
9 replies
How to get the Database details with login user in SQl Server 2008. In 2005 by the activity monito…
6 replies
Hi guys and gals, I'm thinking of upgrading my older ASP sites to have a better server side error c…
4 replies
Viewing 15 topics - 10,561 through 10,575 (of 10,640 total)
You must be logged in to create new topics.