T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Urgent: Please Help me

  This sounds like a repost, but i hope not. If it looks so please forgive me. But i am in urgency, p…

  rahulsony111

  10 replies

  16 years ago

  By: rahulsony111

• Error in Select Statement

  Row_id_no is the column. This is the code SELECT max(DWT40034_BZL_VAT_TAX.ROW_ID_NO) fr…

  rahulsony111

  5 replies

  16 years ago

  By: rahulsony111

• Convert DATETIME to TIMESTAMP

  As i said i have to convert DATETIME to TIMESTAMP. But i cant do it directly converting MSSQL DATET…

  rahulsony111

  1 replies

  16 years ago

  By: Lowell

• Need to place a condition on a select statement to determine which table to use in a query.

  I am a newbie to sql. I am needing to show the vst_int_id's if the diag_ty='P' then use Table3 or i…

  stiltneraw

  1 replies

  16 years ago

  By: Gail Shaw

• To display database records b/w 100 -200

  Dear Experts, Good Morning.Suppose i have 500 records in table name called author table. …

  venktsrinivas.gv

  2 replies

  16 years ago

  By: venktsrinivas.gv

• Find Max Field Length Multiple Tables and Multiple Fields

  I uploaded a bunch of Access tables to SQL and have to convert the Access data into tables used by …

  Roger Abram

  3 replies

  16 years ago

  By: Roger Abram

• list of single user databases

  How can i find list of databases in single user mode and its size.

  Tara-1044200

  2 replies

  16 years ago

  By: Johan Bijnens

• Convert dates

  Hi All! I currently have the following date stored in one of my tables: 2008-01-01 00:00:00 Anyone …

  clarks

  3 replies

  16 years ago

  By: clarks

• Converting decimal field (Hours Worked) to varchar(6) and displaying in a specific format (2080.00 --> 208000)

  I need help with converting a decimal field (Hours Worked) to a varchar field. Required format: 208…

  jpalmer-755805

  3 replies

  16 years ago

  By: jpalmer-755805

• Problem in Building comma separated string for query result

  I need to build a comma separated string of the multiple rows returned out of query result. Select …

  RamG

  4 replies

  16 years ago

  By: The Dixie Flatline

• SSIS and Insert Triggers

  Hi I have a table which has triggers that fire if a particular column is populated. I have tested t…

  qamar.hussain

  3 replies

  16 years ago

  By: Old McDonald

• Help in Bulidng a Query

  Dear All , Please find below the data MonthStart MonthEnd MonthTotalDaysAmount Mar3/9/09 0:00…

  Prakash-485822

  2 replies

  16 years ago

  By: arun.sas

• Help in Bulidng a Query

  Dear All , Please find below the data MonthStart MonthEnd MonthTotalDaysAmount Mar3/9/09 0:00…

  Prakash-485822

  2 replies

  16 years ago

  By: arun.sas

• Table backup

  I need to take a backup of a table into another database I tried to create a new backup table in da…

  newbie_sql

  1 replies

  16 years ago

  By: Glenn Dorling

• Query an XML Column To Extract Values

  Hello, I'm trying to pull the values off an XML column and I can't seems to find why I can't. I rea…

  idorner

  6 replies

  16 years ago

  By: mister.magoo