Topics
Started by
Posts
Last post
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
Hi all, I've got two tables I want to join and determine the distribution of belts held by martial …
4 replies
Hi, I'm trying to build a query to gather data from 2 tables where there is no links between them. …
5 replies
I want to join a couple of tables, Logs with 122,000 rows, and AsignedUsers which has 3,000. If I r…
5 replies
I want to store currency symbols in a table. I checked the official unicode page[/url] for the unic…
2 replies
Hi All, I have a data in a .txt file.But i want to add that data in to a SQL server Table. Before a…
6 replies
Viewing 15 topics - 6,466 through 6,480 (of 10,647 total)
You must be logged in to create new topics.