T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Group by clause on partial select

  Is it possible to have a GROUP BY CLAUSE on only some selected fields? For example: SELECT col1, co…

  ramadesai108

  10 replies

  13 years, 5 months ago

  By: Phil Parkin

• need help w creating trigger.....

  need to create trigger that is relative to the data in the record being inserted or updated

  Snargables

  7 replies

  13 years, 5 months ago

  By: Lowell

• 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

  13 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

  13 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

  13 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

  13 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

  13 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

  13 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

  13 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

  13 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

  13 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

  13 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

  13 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

  13 years, 6 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

  13 years, 6 months ago

  By: nfs_john