T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• SQL version

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

  mtz676

  3 replies

  10 years 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

  10 years ago

  By: j-1064772

• Case Statement in Order By

  I'm trying to figure out the correct way to use a case statement in an order by to pick the most re…

  BSavoie

  10 replies

  10 years ago

  By: Luis Cazares

• Replacing multiple characters in a string Dynamically

  Hi Everyone, I am trying to replace a set of characters which a user inputs from a given string. I…

  vinu512

  7 replies

  10 years ago

  By: zootie

• Pulling all object name alone form various Queries

  Hello DB Experts, I got a job that we have N number of queries stored in table column name like SQ…

  Saravanan_tvr

  4 replies

  10 years ago

  By: Lowell

• Why does moving the ON Clause change the query result

  Guys, I am trying to tidy up some code (for readability) that does not meet our coding guidelines. …

  aaron.reese

  3 replies

  10 years ago

  By: Grant Fritchey

• SQL Code across platforms

  The below query does not work across all versions(2005,2008,2012,2014,2016) of SQL server(not worki…

  mtz676

  3 replies

  10 years ago

  By: John Mitchell-245523

• IF, THEN in T-SQL?

  Hi all, I am trying to replicate some stuff i have made in Access in a SQL database. However i have…

  wrightyrx7

  12 replies

  10 years ago

  By: Gail Shaw

• Comma Separated Result

  Hi. Looking to put my results of this query all in one field comma separated. Any thoughts or help …

  mbrady5

  2 replies

  10 years ago

  By: Hugo Kornelis

• which update for which nested transaction

  Hi, Is it possible to find out which updates were made against a first, second, third etc nested tr…

  EamonSQL

  5 replies

  10 years ago

  By: Sean Lange

• get difference from previous record

  Hi Guys I have the following script when give me the max record on each date: DECLARE @StartDate AS…

  Nomvula

  7 replies

  10 years ago

  By: Nomvula

• Performance tuning a query

  Help needed in tuning my query below as it lot of time in fetching the records. It outputs almost 1…

  VSSGeorge

  20 replies

  10 years ago

  By: below86

• Is Date the Last Day of the Month

  Hi, I'd like to flag my data to let me know if a date is the last day of the month. So, a simple f…

  mbrady5

  4 replies

  10 years ago

  By: R.P.Rozema

• Comparing doc or pdf Files from Using SQL Server

  hi friends i have very interesting qeustion can we comparing two another files with sql server for …

  natigsqlserver

  2 replies

  10 years ago

  By: Steve Jones - SSC Editor

• converting columns to rows comparing multiple records

  Hi everyone I've a problem with converting sql server table column values into rows. I've tried usi…

  marko.celarc

  1 replies

  10 years, 1 months ago

  By: marko.celarc