Topics
Started by
Posts
Last post
Can anybody help me in insert statement: I have a table say table 1 which has many columns but out …
4 replies
Hi all, i am having trouble using the below statement: SELECT dqid, DQFlag, DQLinkID INTO DMCDUPES …
2 replies
how to convert 2012-02-15 14:26:58.520 into 2/15/2012 2:00:00 PM? Please help me with the exact syn…
8 replies
hi, my table has 1 primary clustered key and 2 non clustered key.Now i want to rebuild cluster key,…
5 replies
I want to return multiple values from the case statement As Case statement returns the result from …
6 replies
Suppose I have a table called employee and the data's are as given below Code Name City 1 A India 1…
16 replies
EXEC sp_MSforeachtable ' declare @tblname nvarchar(255); declare @schema nvarchar(255); …
5 replies
Hi everybody! 1. My front end is Access 2003. 2. My backend - SS2K8 Problem: When I open ADO record…
10 replies
Hi, Ive been trying to find a way around a heavy query that we use. We have a table "users" with pr…
8 replies
Hi, I am trying to figure if there is a way to group partitioned data based on duplication criteria…
16 replies
Hi all.. How to convert XML to a datatable in sql server?? or inside a stored procuedure (not usin…
2 replies
I have a maintenance sql script, that has basically 6 update statements. All the 6 statements are…
11 replies
the thing is -: SELECT count(HolidayDate)as Count,Datename(month,HolidayDate) as Months FROM tblHol…
8 replies
the thing is -: SELECT count(HolidayDate)as Count,Datename(month,HolidayDate) as Months FROM tblHol…
3 replies
the thing is -: SELECT count(HolidayDate)as Count,Datename(month,HolidayDate) as Months FROM tblHo…
1 replies
Viewing 15 topics - 6,571 through 6,585 (of 10,635 total)
You must be logged in to create new topics.