Topics
Started by
Posts
Last post
I have a group of tables that represent people and various profile information. I am working on a m…
6 replies
Hi, I am very curious to know the key difference between unique not null and primary key.:w00t:
22 replies
how to print all the column names with in a table in one row from sys table without pivot SELECT t…
10 replies
Here's the basics of where I'm coming from. I'll do some more coding later on, so ignore the variab…
5 replies
I'm considering using dynamic sql for a particular stored procedure. This procedure is called from …
3 replies
Hi all, I need help with a ROW_NUMBER and a group by aggregate. It seems that I can not use the ROW…
3 replies
I cant figure out how to split up a count with group by into columns The desired result would be: t…
56 replies
I need to write a report for HR. The report needs a whole lot of data including the last four of th…
8 replies
My script builds the temporary table #tblFiscalWk, that will return a single record with the intege…
7 replies
Hi all, I've got the datediff per row, but need an average for each column. So far... Select PF.Con…
4 replies
Several have suggested that we start using the statement terminator, as it will be required in a "l…
3 replies
I've been scratching my head on this one for quite a bit, basically trying to calculate how long it…
9 replies
Hi all I have an epoch date that I have managed to convert into a standard date by doing the follow…
5 replies
Hello I have two tables for rxample, t1 and t2. both tables are having same columns name (monthno, …
3 replies
I usually come to this forum in a mad panic, but today I come bearing gifts. Thanks to an extremel…
3 replies
Viewing 15 topics - 6,451 through 6,465 (of 10,635 total)
You must be logged in to create new topics.