Topics
Started by
Posts
Last post
Hi, I have a table named ABC. It has a field named Y and Z. Y='ABCDEFG (9105) CDD ABCDEFG (1690)…
9 replies
Hi, i have a data like below Personid AccountNo ProductCode Date1 1 111 80 …
3 replies
Hi, Please use the following sql to create a sample of test data to play around with. USE [master]…
13 replies
We recently decided to partition a table in one database that is referenced in another. The current…
9 replies
Hello Everyone OK, I am going to do my best to explain this and not leave anything out. In the tabl…
5 replies
I have a working pivot statement, which pivots againts one column. I'm trying to create some ddl t…
10 replies
hello everyone. i got a scenario like this i got 5 parent tables and 30 child tables in the source …
19 replies
I'm in the process of upgrading a sql 2000 environment to 2008 R2. I now have 2 servers, 1 with ea…
5 replies
sample data: drop table #data create table #data(number int, name varchar(99), comment varchar(99)…
6 replies
I have read much data,tables This is a sample How can i get rid off spaces in the table during impo…
5 replies
how can i add timestamp columns in sqlserver
3 replies
hi guys, i need help in my Stored procedure. select empname ,(select case when empno is null then …
67 replies
i would like a pivot query that aggregates counts by years 2012, 2011, 2012 for all workitems havin…
7 replies
I need to add another aggregation to this query to make the distinction between applications that h…
1 replies
I was creating Insert_Date and Modified Date Columns on a number of tables. It is customary to set …
10 replies
Viewing 15 topics - 6,136 through 6,150 (of 10,647 total)
You must be logged in to create new topics.