T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Calculate Vacant Days Per Month

  Hi, I have the below query and trying to calculate how long a vacant property was with repairs per …

  jaggy99

  8 replies

  9 years, 4 months ago

  By: J Livingston SQL

• Return row ID on error

  Hello, I have a table which has 4 fields - the last one does not accept null values. Consider the f…

  dan-737342

  2 replies

  9 years, 4 months ago

  By: J Livingston SQL

• AVG Function not working as expected.

  Hi All, i am trying to get avg of datesdiff value for the below data. I may have 0 in the datesdiff…

  dhanekulakalyan

  7 replies

  9 years, 4 months ago

  By: sgmunson

• Distinct on Geographic

  I have a simple select statement that has two geographic data types (SQL R2). How can I make these …

  krypto69

  3 replies

  9 years, 4 months ago

  By: Kenneth Kirby

• Need help on pivoting and grouping the data on an already pivoted table data

  I have written a query using pivot and the data is correct like how I want( This excudes grouping).…

  sindhupavani123 50704

  1 replies

  9 years, 4 months ago

  By: Sean Lange

• Need some help transposing a query

  Hey guys, I have a stored procedure I'm trying to make more efficient. Its been a while since I was…

  dndaughtery

  7 replies

  9 years, 4 months ago

  By: aaron.reese

• Identify matching numbers pairs and sequence in a values and give them a name

  Hi All, Hope everybody is fine. I have to perform a task as stated below: Please note that the valu…

  Rehan Ahmad

  4 replies

  9 years, 4 months ago

  By: Luis Cazares

• How to show CAPS lock status in Management Studio status bar?

  Hi, How to show CAPS lock status in Management Studio status bar to know if CAPS Lock is on or off.…

  amar_sharma

  11 replies

  9 years, 4 months ago

  By: Jeff Moden

• Need to insert Reocrds in uniqueidentifier column

  Hi, I am getting error while inserting record in a uniqueidentifier column. Create table script CRE…

  kiran.rajenimbalkar

  4 replies

  9 years, 4 months ago

  By: drew.allen

• Need help understanding this line in a stored procedure

  I came across this line for a variable declaration in a stored procedure, but not sure exactly how …

  Goalie35

  1 replies

  9 years, 4 months ago

  By: Eirikur Eiriksson

• Cycle Through Multiple db's For EXISTence of a Table then DELETE

  Hi, I would DELETE records older than 7 days of getedate() in all databases on an instance where th…

  PrettyMegaDBA

  5 replies

  9 years, 4 months ago

  By: Y.B.

• Exporting an xml column

  Hi, I am trying to export an xml column into a text file using the below mix of powershell and TSQL…

  Roust_m

  3 replies

  9 years, 4 months ago

  By: Sergiy

• happened in precisely the unsurprising

  Game of Thrones Season 6 Episode 2 Watch Online

  lmi63354

  1 replies

  9 years, 4 months ago

  By: John Rowan

• SQL version

  How to get only version number from select @@version Result should be 2000/2005/2008/2012... only a…

  mtz676

  3 replies

  9 years, 4 months ago

  By: Y.B.

• XML to SQL tables

  Hi There, I have some XML data stored in a column of a table. There are lot of same kind of xml r…

  squvi.87

  11 replies

  9 years, 4 months ago

  By: j-1064772