T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• XQuery vs. OPENXML

  I didn't fully understand the implications of the use of XQuery. I just didn't see it as something …

  Grant Fritchey

  14 replies

  14 years, 5 months ago

  By: SGT_squeequal

• Capture script/statement output?

  Hi, folks! Is there any way to capture the text output of a multiline dynamic TSQL query into a TSQ…

  SFlucke

  1 replies

  14 years, 5 months ago

  By: Grant Fritchey

• choose a random record

  Hi Friends, i have a question here: how i can pick a record by random using TSQL..? querying only o…

  xRafo

  21 replies

  14 years, 5 months ago

  By: brendan woulfe

• Date range query , filling in missing values

  I have a table similar to : tbl_Report MyValue int DateAdded datetime It has sequential dates and v…

  daninmanchester

  7 replies

  14 years, 5 months ago

  By: daninmanchester

• BULK INSERT - Limitation ?

  Hi all, Steps to reproduce I have created sample table “CSVTest” on in db, having fields as id, fir…

  Bipin Kadam

  1 replies

  14 years, 5 months ago

  By: Devendrakumar

• DateDiff to HH:MM format question

  I am trying to get the difference of dates in HH:MM only format. The issues are that there could b…

  mgchris

  2 replies

  14 years, 5 months ago

  By: mgchris

• accessing several databases in a function error

  hello, I want to access several DBs in my function. I execute this function on different servers so…

  marmarhm2002

  9 replies

  14 years, 5 months ago

  By: marmarhm2002

• Must be a better way?

  I wrote the following query to extract unique IDs based on a key word search of the text column fro…

  chriej1

  4 replies

  14 years, 5 months ago

  By: chriej1

• Change the job history log

  Hello, I would like to change my job history log setting from "limit size" to "remove agent history…

  ndessaint

  3 replies

  14 years, 5 months ago

  By: Devendrakumar

• Split comma separate single row into multiple rows

  Hi guys, I have a table variable object and records are present in that table as follow: DECLARE @T…

  Sagar Sawant

  4 replies

  14 years, 5 months ago

  By: mhike2hale

• Equivalant of "Left Join" but in XML

  I'm pretty good at most things in T-SQL but I'm all thumbs when it comes to XML. I've never writte…

  Jeff Moden

  10 replies

  14 years, 5 months ago

  By: Jeff Moden

• Problem with running total

  Here is my code. This code calculates a YTD total for CPT codes (CPT) by month. If a particular CPT…

  NineIron

  24 replies

  14 years, 5 months ago

  By: NineIron

• Convert DATE to Integer8 (64 Bit)

  Hello, I have an LDAP query that gets some users. This works great. I also filter to make sure I am…

  nfs_john

  3 replies

  14 years, 5 months ago

  By: nfs_john

• Problem with long running query

  Hi there, first of all thank you all for the tips and hints here, ive got alot of tips out here for…

  christian 92959

  19 replies

  14 years, 5 months ago

  By: christian 92959

• Requierement to be implemented in ORACLE

  We have two tables as given below : table c1 c2 c3 c4[/b] A1 b1 …

  gunjansehgal.panipat

  1 replies

  14 years, 5 months ago

  By: Devendrakumar