T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Query runs forever following database migration (2005 - 2008)

  Hi, I recently migrated a database which resided on our old 2005 server to our newer 2008 productio…

  DBANewbie

  4 replies

  13 years, 8 months ago

  By: DBANewbie

• Deleting duplicate record

  Hi, I have a table likeCreate table demo(nvarchar(20)) It has following recordsinsert into demo val…

  Shadab Shah

  21 replies

  13 years, 8 months ago

  By: Lynn Pettis

• Loading the distinct rows in the destination table fromt the source table with some logic

  Please take a look at the below details and let me know if anyone can help. I'm trying to write a s…

  sql1411

  8 replies

  13 years, 8 months ago

  By: sql1411

• How to find a Query in all stored procedure

  Hi, I have database with over 100 SP. Now i have a query which i am suppose to search in all SP. I …

  Shadab Shah

  30 replies

  13 years, 8 months ago

  By: Eugene Elutin

• CASE STATEMENTS

  I have two identical queries with only one filter difference between the two queries. Can anybody s…

  vivekkam

  4 replies

  13 years, 8 months ago

  By: Luis Cazares

• string manipulation - Need help !

  Hi All, Can anyone help me with below sql server 2005 and up: input string: BUILTIN\ADMINISTRATORS:…

  SQLQuest29

  13 replies

  13 years, 8 months ago

  By: Dwain Camps

• Fiscal Dates

  My company wants to create a Financial Calendar Table which contains only the Fiscal Dates. The req…

  rka

  7 replies

  13 years, 8 months ago

  By: Ron McCullough

• cursor error in a stored procedure.

  Hi All, i am trying to clean up my temp table sin tempdb database that are older than 24 hours. dur…

  BoobyB

  14 replies

  13 years, 8 months ago

  By: RBarryYoung

• Help with IF EXISTS and non existent column.

  Hi there, Im trying to do an update on a table but make sure the column exists before we do the upd…

  Rin Sitah

  4 replies

  13 years, 8 months ago

  By: RBarryYoung

• This Year last 2 months query

  Hi all I am trying to get all Docket_Date (DateTime Column) to return all in this year for that are…

  jerome.morris

  6 replies

  13 years, 8 months ago

  By: Luis Cazares

• using IN statment & a string variable.

  Hi, I need some assistance and i've read multiple answers which are very similar but just not sure …

  Tava

  14 replies

  13 years, 8 months ago

  By: Sean Lange

• ORDER BY PROBLEM

  Hi, I have column in a table which needs to be ordered in an ascending order. DECLARE@NumberTab…

  santa326

  11 replies

  13 years, 8 months ago

  By: SWATH

• Comparision of a datetime variable against a column of the type nvarchar

  Hello All, (Sorry, if I have posted this question already in another topic) I have a table like th…

  renu.iitkgp

  5 replies

  13 years, 8 months ago

  By: renu.iitkgp

• Potentially delusional co-worker, inline vs. multi statement TVF

  Greetings -- I am having a disagreement with a co-worker about what constitutes a multi-statement T…

  sqlnyc

  5 replies

  13 years, 8 months ago

  By: sqlnyc

• Generation of Records

  I have got some Monthly Data which I want to pro-rata it on a Daily Basis. E.g. The Current Data lo…

  rka

  8 replies

  13 years, 8 months ago

  By: Jeff Moden