T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Comparision of records for a given set of values in datatable

  For example take example of following table. Student IDNameSectionPercentageSubject IdOther A…

  maq_sandeepp

  1 replies

  14 years, 9 months ago

  By: Vedran Kesegic

• Get Errors When Columns Not In Table

  I realize that the subject line for this topic makes me sound like an idiot but please bear with me…

  dscarr1962

  4 replies

  14 years, 9 months ago

  By: The Dixie Flatline

• is null check in where clause

  Hi ALl A very simple question for which i do not have the correct and logical answer. say , i have…

  koustav_1982

  34 replies

  14 years, 9 months ago

  By: SQL_ME_RICH

• Increment a month T-SQL Statement

  Hi Can anyone help me write a store procedure to increment a month For example The current month i…

  Jnrstevej

  1 replies

  14 years, 9 months ago

  By: Vedran Kesegic

• updating several tables and deleting the original rows

  So I know there must be a better way to do this, because I am most definitely tired of doing it man…

  stephen99999

  4 replies

  14 years, 9 months ago

  By: stephen99999

• OLD is GOLD

  I need to know the logic / sql to achieve cumulative sum or running total ? Please give a minimal c…

  rockybhai

  5 replies

  14 years, 9 months ago

  By: Sean Lange

• DATETIME format help

  Hi, can any one help me in converting the getdate() into YYYYMMDDHHMMSS format? can convert it into…

  prasadau2006

  3 replies

  14 years, 9 months ago

  By: prasadau2006

• TSQL Count by Week - Show Period

  Trying unsuccessfully to get a count of tasks by week, and also want to display the week period. Th…

  sql_jr

  18 replies

  14 years, 9 months ago

  By: Jeff Moden

• String addition - why does this not work?

  Below is a script and output. Why does it not work? I don't understand why @cmd does not have the…

  mike 57299

  3 replies

  14 years, 9 months ago

  By: The Dixie Flatline

• TSQL to find the database for a given log file name

  I have some log files that haven't been modified in quite some time. My question is, if I have the …

  dndaughtery

  3 replies

  14 years, 9 months ago

  By: calvo

• Comparision of two stings

  Hi i want to compare two varchar column strings and my table consists of Billions of records so i c…

  vineetbhargav

  2 replies

  14 years, 9 months ago

  By: The Dixie Flatline

• Passing a value into a Stored Procedure using an OUTPUT parameter

  I created a stored procedure. CREATE PROCEDURE PR_SWL_TEST @X integer OUTPUT AS Print @X Select @X…

  SW_Lindsay

  3 replies

  14 years, 9 months ago

  By: SW_Lindsay

• query problem

  i have created a stored procedure which runs Perfect in SQL Server 2008 but producing error in SQL …

  awaisahmad435

  1 replies

  14 years, 9 months ago

  By: Gail Shaw

• Using Rollup

  Hi All, I am trying to understand how Rollup works. following query summarize Use AdventureWorks s…

  Dhruvesh Shah

  2 replies

  14 years, 10 months ago

  By: Jeff Moden

• How to write query to inset values into table

  Hi All, Here is my question i would like to insert some values into two different table with s…

  seshukumar.thokala

  3 replies

  14 years, 10 months ago

  By: sylwester.sikorski