T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Query Against Temp Table not Working (includes Max Function)

  Hi All Running a simple select from a tempary table created from query. Trying to link 3 tables and…

  LoosinMaMind

  2 replies

  15 years ago

  By: LoosinMaMind

• How to Update date field with dynamically

  i have table having field date along with address i need to update the date dynamically for each du…

  sqlbi

  3 replies

  15 years ago

  By: Ron McCullough

• To insert a value from a table into a warning statment

  To insert a value from a table into a warning statment my script currently is as Update table A S…

  SQLTestUser

  11 replies

  15 years ago

  By: The Dixie Flatline

• JoIN IN T SQL

  HI HAVE WRITTEN A CNDITION LIKE THIS. select cast(right(201008,2) + '/01/' + left(201008,4) as date…

  cpinky01

  3 replies

  15 years ago

  By: Lowell

• splitting a parameter on delimiter

  Is this syntax correct? Keep getting error "Incorrect syntax '>'" Parameter I am passing in is…

  Richard Holloway

  11 replies

  15 years ago

  By: Richard Holloway

• I want optimize the store procedure-It's take more time to excecute by use while loop

  Hi friends, Kindly check my store procedure and advise me why it's taking log time to excecute , an…

  s.chandrahasan

  15 replies

  15 years ago

  By: ChrisM@Work

• MSDB

  which statement true of the MSDB databse (1)MSDB is useful in SQLSEVER AGENT (2)im MSDB database jo…

  kalrpuli

  3 replies

  15 years ago

  By: Minaz Amin

• Column of table

  can we add a column before defining the sql table? (1)yes (2)no

  kalrpuli

  5 replies

  15 years ago

  By: sanmatrix

• Column Comparision

  I have been working on this since yesterday. could not find a way out. I have two tables TableA and…

  Deepthy

  9 replies

  15 years ago

  By: Paul White

• how to manage insert update and delete operation in one procedure for one table in sql server 2005..

  how to manage insert, update and delete operation in one procedure for one table in sql server 2005…

  Vaghasiya Nilesh

  1 replies

  15 years ago

  By: Paul White

• sql schema

  what is sqlschema in sqlserver?

  kalrpuli

  3 replies

  15 years ago

  By: Paul White

• UDF's

  in below functions what are ture (1)single row functions (2)multiple row functions (3)multiple colu…

  kalrpuli

  2 replies

  15 years ago

  By: Paul White

• How to have cummulative sum of a column values based upon a condition?

  I have a query which brings the data using a view. I want to perform a cumulative sum of the amount…

  pradeep.kumar.jakhar

  6 replies

  15 years ago

  By: sunitkrishna

• Patients who come in within 14 days

  Dear All, I'm trying to wriite sql query and i would like to know how would write the following in …

  jbon007

  14 replies

  15 years ago

  By: jbon007

• Filling in missing data from one table to the other

  I need to populate a table's missing values with values from another table. Table USER_CUST should …

  Rog Saber

  1 replies

  15 years ago

  By: Russel Loski