T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Inserting a start- and end tag into an xml string

  Hi I've a xml variable @xmldoc with this And i want to insert a tag as in the following examp…

  hennie7863

  2 replies

  16 years, 5 months ago

  By: hennie7863

• How do I have an INT variable default to the wildcard if NULL in a Stored Procedure..?

  Hi - I'm trying to use the one Stored Procedure for different scenarios... I want to pass any combi…

  RunnerIE

  4 replies

  16 years, 5 months ago

  By: RunnerIE

• Issue with Money to Varchar Conversion

  Hi there, I have the following SQL Syntax - SELECT DISTINCTSALE.Reference AS 'mhs Reference', …

  TSQL Tryer

  3 replies

  16 years, 5 months ago

  By: The Dixie Flatline

• Calculating custom score

  I've a table with results from a run contest. Let's say tblResults with the following fields: Parti…

  alef

  9 replies

  16 years, 5 months ago

  By: alef

• Unique Id

  How do you create unique identifier such as U82300001 ,U82300002 and U82300003 etc to autogenerate …

  develope

  9 replies

  16 years, 5 months ago

  By: The Dixie Flatline

• execute sp with parameter

  Hi all, I am lost to do this: @id = 'select disctint id from idtable' @sp1 = 'select sp1 from table…

  pat-261672

  2 replies

  16 years, 5 months ago

  By: melloman

• How do i know which process using my particular table ?

  Hi, I have a one major table in my database. And number of process using this table. How do i knwo …

  amrishy2k

  1 replies

  16 years, 5 months ago

  By: spaghettidba

• multiple params for where condition ??

  Hi, I have a column (Named Description), in which some description e.g Automobiles is stored. User …

  sudhanva

  15 replies

  16 years, 5 months ago

  By: Allister Reid

• Appemd code at the end of duplicate name

  All, I want to add code at the end of duplicate names. create table emp ( ecode char(5), ename varc…

  karthik M

  2 replies

  16 years, 5 months ago

  By: Mark Cowne

• insert non duplicates, am i missing something here?

  Ok, i come to think im not an idiot, but maybe i am whats wrong with this query. I just want to i…

  xgcmcbain

  2 replies

  16 years, 5 months ago

  By: matzer

• removing duplicate row values

  hi I have a result set from a qry like below ORDER_NO | ORDER_TITLE | ORDER_DETAIL | ORDER_DETAIL_…

  chandresh soni

  4 replies

  16 years, 5 months ago

  By: arun.sas

• Curly question I can't work out without cursors!

  I'm hoping Jeff Modem can help me on this one 🙂 What I've got is a table that tells me when a clock…

  ta.bu.shi.da.yu

  16 replies

  16 years, 5 months ago

  By: ta.bu.shi.da.yu

• SQL Query by splitting the encoded text.

  Hi, I have a situation where I have bunch of 7-digit Encoded text in database like 0304182, now her…

  steven-733381

  3 replies

  16 years, 5 months ago

  By: J-F Bergeron

• Concatenate and Null value in Select

  I have Select that I concatenate the customer name. SELECT LastName + ', ' + FirstName+ ', ' + Midd…

  rothj

  5 replies

  16 years, 5 months ago

  By: The Dixie Flatline

• how to write a function that executes Sub- Store procedure

  Hi , Can anyone help to write a dynamic function that executes Sub Store procedure. here is the Sc…

  John Paul-702936

  32 replies

  16 years, 5 months ago

  By: Jeff Moden