T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• First of last user reply to time diff on first to last tech reply

  I have the following set of data DTimeidticketidactionlog 2012-05-09 05:24:58.000139571298cre…

  matt.newman

  3 replies

  13 years ago

  By: matt.newman

• Case statement in where clause (Help)

  hi all..i need to write a query whereby using case statement in where clause...can anyone guide me?…

  kame87

  2 replies

  13 years ago

  By: drew.allen

• How to make a UPDATE

  hi Guy , please can somebody explain me how i can do to update my table ? hier ist one example: /*…

  inf1154

  7 replies

  13 years ago

  By: aakash.parwani

• Pull most recent record of Multiple records

  I have this in one table (columns are Patient#, Name, EntryDate) 123456789, Jane Doe, 4/12/12 12345…

  lulu_lutz

  5 replies

  13 years, 1 month ago

  By: lulu_lutz

• qry help

  I want to do something like this.. When i execute this query below i want to know if gives filegrou…

  Tara-1044200

  2 replies

  13 years, 1 month ago

  By: Lynn Pettis

• sqlcmd output csv double quotes round fields

  Can anyone tell me how I could get all my fields to be not only comma separated but quote (") delim…

  Kelvin Phayre

  1 replies

  13 years, 1 month ago

  By: jonathan.greenstreet

• DateAdd together with DateDiff

  Hi, I would like to achieve the following: I need an update query wich would do the following. Supp…

  tprocureur

  6 replies

  13 years, 1 month ago

  By: ChrisM@Work

• Find Oldest Row Per Group?

  This is my current script... ---------------------------------------- SELECT Distinct "user_view"…

  Vertigo44

  13 replies

  13 years, 1 month ago

  By: Dwain Camps

• UNPIVOT -- Why can't I use it?

  I'm using SQL Server Management Studio 2005. I was experimenting with the idea of using UNPIVOT, bu…

  themangoagent

  2 replies

  13 years, 1 month ago

  By: themangoagent

• tracking sql errors

  I know i can add a trace flag to allow me to track and resolve deadlocks however i have a site who …

  Snargables

  3 replies

  13 years, 1 month ago

  By: Snargables

• Difference Between SQL Statements ..

  Hi All, WOuld be grateful if you could help out explaing the difference between the following queri…

  aarionsql

  1 replies

  13 years, 1 month ago

  By: drew.allen

• Trying to create Set Statment when Clause is met ??

  Hello - Can someone help me and point in the right direction?? I'm trying to writing some SQL tha…

  david.ostrander

  8 replies

  13 years, 1 month ago

  By: Eugene Elutin

• Summing distinct records

  Hi all, Just a quick question which I'm fairly sure I already know the answer to. Let's say I have …

  kramaswamy

  5 replies

  13 years, 1 month ago

  By: Dwain Camps

• Insertion using linked server.

  Hello friends, I use this query to insert data into a table in remote server using a linked server …

  striker-baba

  10 replies

  13 years, 1 month ago

  By: dragonfly

• Recursive query

  Dear, I'm struggling with a recursive query. The bill of material of our products is stored in a ta…

  jvdb 65877

  1 replies

  13 years, 1 month ago

  By: Sean Lange