T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• omit null values

  How do you omit the null values returned inthis query? SELECT CASE WHEN MONTH(DueDate)=5 THEN DueDa…

  ReginaR1975

  11 replies

  14 years ago

  By: houming1982

• alter column width

  When I alter a column length for a table, do I need to refresh its trigger? I asked this is because…

  sqlfriend

  2 replies

  14 years ago

  By: Jeff Moden

• return every Friday in a quarter

  How do you get the date for every Friday in a particular quarter?

  ReginaR1975

  3 replies

  14 years ago

  By: ReginaR1975

• Is there a better way to write this?

  Hi, Please look at the below query and suggest if there is a cleaner way to achieve this. This is t…

  Sam Vanga

  3 replies

  14 years ago

  By: Dwain Camps

• calculate time difference

  Hi friends I have start time and end time , I need to get is the time difference between 2datetime…

  komal145

  3 replies

  14 years ago

  By: Dwain Camps

• Tricky SQL - Please Help

  Hi All, I have a bit of a puzzle and my brain decided it didn't want to come to work today. Please …

  Sean Pearce

  40 replies

  14 years ago

  By: GSquared

• Comma delimited string in a Subquery

  Can this be done? I can get a query to return a comma delimited string of results using Coalesce bu…

  tshad

  2 replies

  14 years ago

  By: Sean Lange

• Unique Error with convert function in update query

  Hi Friends, I am receiving below error when trying to execute an sql stmnt. UPDATE test1 SET …

  sundeep38

  4 replies

  14 years ago

  By: Johan Bijnens

• Query help

  Hi I am trying to get TotalDue by Year,Quarter,Month format from Sales.SalesOrderHeader Table in A…

  Smash125

  15 replies

  14 years ago

  By: Jeff Moden

• varchar(max) with QUOTENAME

  When I use QUOTENAME with varchar(max), it is giving me error DECLARE @test-2 VARCHAR(MAX), …

  krishusavalia

  2 replies

  14 years ago

  By: krishusavalia

• FOR XML returned as result set instead of one stream. Alternatives?

  Morning all- I have a process that compares two tables (same structure) and finds the differences b…

  Rogman

  12 replies

  14 years ago

  By: GSquared

• Does a non clustered index affect the order in which data in a query is returned?

  I am working on a performance project and one of the people I work with is not comfortable adding a…

  Mountain Steve

  6 replies

  14 years ago

  By: Gail Shaw

• Most Recent Record

  The following script is returning all PO's within the last eighteen months. How do I filter it down…

  bpowers

  6 replies

  14 years ago

  By: bpowers

• How to bring all Ids of my table in Order

  Hey Guy Please i have some request. i have a table Person with (Person_ID, Person_Name and Person_…

  inf1154

  8 replies

  14 years ago

  By: Eugene Elutin

• how to get data between dates

  hi this is my DDL. declare @temp5 table ( Id int, FromDate datetime, …

  harri.reddy

  16 replies

  14 years ago

  By: Steve Jones - SSC Editor