T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• passing case statements into a variable possible???

  Greetings SQL Gurus, I have a quick question. Anyone know how, or if it is possible, to pass a cas…

  AirBasi

  3 replies

  15 years, 10 months ago

  By: AirBasi

• How to get these results?

  I've been a member of this site off and on for a long time and I don't think I've ever posted a que…

  tom 29037

  24 replies

  15 years, 10 months ago

  By: WayneS

• How to get the null column output

  Dear All; with A AS ( SELECT CONVERT(VARCHAR,OESM.EDATETIME,103) [AExamdate],CM.COURSEID [ACOURSEID…

  sqlfriends@sql.com

  1 replies

  15 years, 10 months ago

  By: LutzM

• XML Conversion using Cross Apply

  Hi all, I need a nudge in the right direction here. I have a SOAP response containing a load of reg…

  Simon G

  4 replies

  15 years, 10 months ago

  By: Simon G

• Top with order by gives different results in different server

  Hi, I have following query, which I am using to troubleshoot the bad data.. select top 5 column1,…

  VG-619426

  4 replies

  15 years, 10 months ago

  By: Ninja's_RGR'us

• How to partition an already populated table

  This question is about the T-SQL syntax that leads to partitons an already existed table, I have a …

  ernesto780411

  2 replies

  15 years, 10 months ago

  By: Ashwani Malik

• Funtion to calculate turn arround time time between two dates

  Hi, Can you help me with a function that calculate turn around time in hours and using only this ho…

  pitso.maceke

  6 replies

  15 years, 10 months ago

  By: cavo789

• ERWIN DATA MODELING ERROR

  Hi, I'm using CA Erwin r7.3 version and i got sql server 2008. Now when i'm trying to forward engin…

  tripri

  2 replies

  15 years, 10 months ago

  By: Grant Fritchey

• Service Broker working in one databse but not in other

  Hiii every one, the code below is taken from http://www.sqlservercentral.com/articles/Development/a…

  ruikong

  3 replies

  15 years, 10 months ago

  By: sturner

• simple t sql question what does ALL do in select ALL * from aaab

  Hi, I have come across code that includes the ALL definition e.g. select all * from aaabb can you p…

  olibbhq

  5 replies

  15 years, 10 months ago

  By: olibbhq

• freetext

  Hi Everyone I'm new to sqlserver and any how i have created the freetext for the coloumns.. The pro…

  dotnetsniper

  1 replies

  15 years, 10 months ago

  By: Ben Teraberry

• Snapshotting our database causing application timeouts!

  I’ve had an open ticket with Microsoft on a timeout issue we are having for over a month now with n…

  Mike Byrd

  4 replies

  15 years, 10 months ago

  By: jvanderberg

• Releasing resources

  I have some code is called repetitively: set nocount on PRINT GETDATE() DECLARE @customerID ID, @St…

  mike 57299

  3 replies

  15 years, 10 months ago

  By: Eugene Elutin

• Service Broker Message Type Issue

  Hii everyone, I am new to T SQL and Service Broker. I am unable to grant a create message type perm…

  ruikong

  2 replies

  15 years, 10 months ago

  By: ruikong

• How to count left side nodes and right side nodes for managing a chain link(binary tree)application in sql server 2005

  Hi Guys, here is a table sturucture for managing a chain link(binary tree)application. tbl_tree (no…

  Vaghasiya Nilesh

  5 replies

  15 years, 10 months ago

  By: Vaghasiya Nilesh