Topics
Started by
Posts
Last post
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
I am currently trying to complete the final part of a query that loads scd type 2 data into a dimen…
2 replies
Just need pointing in the right direction really. I am designing a SSIS package to basically load …
5 replies
Hi, can anyone help me with this? I am receiving this error: Msg 102, Level 15, State 1, Procedure …
8 replies
We have a report that runs on an audit table. The audit table has a description/notes/comments fiel…
19 replies
Hi, I got a delete statement which performs cascade delete to some 20 sub tables. I got necessary i…
4 replies
Viewing 15 topics - 6,586 through 6,600 (of 10,647 total)
You must be logged in to create new topics.