Topics
Started by
Posts
Last post
i have a table which i would like to transform its columns into rows Thanks in Advns
8 replies
Data apx (5 million rows): Span example: -------------M--------------- &nbs…
5 replies
I've encountered several articles lately regarding the PREPARE...EXECUTE statements in combination …
1 replies
By: rhunt
How to get total count of rows from 2 tables..in a single sql statement
6 replies
I have columns named Control_Code and Sequence_Number in a table named Statement_Report. Rul…
21 replies
By: hmbtx
Hi all, I have 3 tabls: 1. job_level_table Job_Code Job_…
1 replies
Hi all, I know you have probs read this a million times, but I have to design a database where ther…
5 replies
Can anyone know the script for deleting duplicate row from this following table table : emp empid&n…
10 replies
I have two databases situated at two MS SQL Servers and one of them is kept as global. I hav…
1 replies
By: [KH]
Hi, I want to group the data for last week on a daily basis. For example, if I have today's date t…
2 replies
By: [KH]
Does anybody know if a UDF that will return the full date given a week of year and the year? I am s…
8 replies
Hi, What's the best way to change a dataset like this: Code Keyword 11 &n…
2 replies
Dear Friends, I have a table which has 2 types of records A and B. How do i split these rows …
1 replies
ok, check this out. Just looking at the hour now. I want the same hour. So, this …
6 replies
ERR is a column of char(255) How can I speed up this reference? LEN(RTRIM(LTRIM(ERR))…
26 replies
By: Sergiy
Viewing 15 topics - 7,381 through 7,395 (of 17,082 total)
You must be logged in to create new topics.