Topics
Started by
Posts
Last post
Hi Everyone. Please see the following Code: SELECT CASE W…
3 replies
Hello, I have some code that works, but what I'd like to know is whether the update can be done dir…
2 replies
Hi I am trying to produce a report that will show a duration in minutes of a time when a room was o…
2 replies
Here is the query: cteUsage30 AS ( SELECT keySystem, --dtActivitesDuring, ROW_NUMBER() OVER…
2 replies
Hi, I have a table with more than 50 columns(column1,column2,column3 .....column60) with 'Y' and 'N…
3 replies
Hi, I wonder if someone could help me with a bit of TSQL I'm struggling with (SQL 2008)... I have 3…
5 replies
Hi, I have the query below. I would like to add to it the actual file size in mb or gb of each fil…
2 replies
Hi, I am trying to move data from one table to the another (staging to real time) in a stored proce…
2 replies
Hello Is it some way to combine COUNT(*) and ROW_NUMBER on the same partition ? For now I'm using a…
1 replies
Hello All, In my below T-sql the shipment date is set to next Thursday, if the shipment is missed …
6 replies
Hi, I am having a source table: #test1(studID, FIrstNAme,LasteName) Target Table #Test2(StudID, U…
5 replies
Hi, I have a table with 22 million Business records. I can see that there are duplicates when I gr…
30 replies
Being one step removed from innumerate, I was wondering whether there was a more elegant way to avo…
6 replies
Hi All, Here is my sample source file Advert,Network,Program Acorn,NULL,NULL NULL,AC,NULL NULL,NUL…
4 replies
Hello, the problem is I want to end up with the max/min of agent working on an account. To that en…
6 replies
Viewing 15 topics - 1,636 through 1,650 (of 10,647 total)
You must be logged in to create new topics.