T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Help with TSQL Case Statement. Urgent Help Please.

  Hi Everyone. Please see the following Code: SELECT CASE W…

  ganteng1

  3 replies

  11 years, 4 months ago

  By: ganteng1

• Update based on CTE - can this be done in one step?

  Hello, I have some code that works, but what I'd like to know is whether the update can be done dir…

  daniel.freedman 80164

  2 replies

  11 years, 4 months ago

  By: daniel.freedman 80164

• Time calculation from datetime

  Hi I am trying to produce a report that will show a duration in minutes of a time when a room was o…

  Bex

  2 replies

  11 years, 4 months ago

  By: Bex

• Help with COUNT function in the query

  Here is the query: cteUsage30 AS ( SELECT keySystem, --dtActivitesDuring, ROW_NUMBER() OVER…

  maxlezious

  2 replies

  11 years, 4 months ago

  By: maxlezious

• TSQL query help

  Hi, I have a table with more than 50 columns(column1,column2,column3 .....column60) with 'Y' and 'N…

  Dhruva_51

  3 replies

  11 years, 4 months ago

  By: spaghettidba

• Get Rows from C if Linked Rows in B contain all rows in A

  Hi, I wonder if someone could help me with a bit of TSQL I'm struggling with (SQL 2008)... I have 3…

  Charlottecb

  5 replies

  11 years, 4 months ago

  By: Charlottecb

• Getting files size for each database file

  Hi, I have the query below. I would like to add to it the actual file size in mb or gb of each fil…

  lmacdonald

  2 replies

  11 years, 4 months ago

  By: lmacdonald

• Insert causing delay - from table to table

  Hi, I am trying to move data from one table to the another (staging to real time) in a stored proce…

  namrata.dhanawade-1143388

  2 replies

  11 years, 4 months ago

  By: ZZartin

• combine ROW_NUMBER and COUNT(*) OVER Partition

  Hello Is it some way to combine COUNT(*) and ROW_NUMBER on the same partition ? For now I'm using a…

  ogb

  1 replies

  11 years, 4 months ago

  By: Eirikur Eiriksson

• Set Shipment date to Monday instead of Thursday.

  Hello All, In my below T-sql the shipment date is set to next Thursday, if the shipment is missed …

  SSRS Newbie

  6 replies

  11 years, 4 months ago

  By: Jack Corbett

• increment string by appending 01

  Hi, I am having a source table: #test1(studID, FIrstNAme,LasteName) Target Table #Test2(StudID, U…

  abhas

  5 replies

  11 years, 4 months ago

  By: ChrisM@home

• Rank duplicates, but only rows involved in duplicates

  Hi, I have a table with 22 million Business records. I can see that there are duplicates when I gr…

  jeff.born

  30 replies

  11 years, 4 months ago

  By: ChrisM@Work

• eliminating divide by zero error

  Being one step removed from innumerate, I was wondering whether there was a more elegant way to avo…

  drew.georgopulos

  6 replies

  11 years, 4 months ago

  By: drew.georgopulos

• T-SQL Code Help

  Hi All, Here is my sample source file Advert,Network,Program Acorn,NULL,NULL NULL,AC,NULL NULL,NUL…

  rocky_498

  4 replies

  11 years, 4 months ago

  By: rocky_498

• Rank by Datetime

  Hello, the problem is I want to end up with the max/min of agent working on an account. To that en…

  djj

  6 replies

  11 years, 4 months ago

  By: djj