T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• ntext datatype issue in ssis

  Hi All, I have a xml file to import into SQL server 2005. Now the xml file has a description sectio…

  arijit rath

  4 replies

  16 years, 10 months ago

  By: Gift Peddie

• Derive Values for Update

  I am new to sql server so I was hoping I could get some help? I have a table structured and populat…

  za34571

  3 replies

  16 years, 10 months ago

  By: nathan.syverson

• multi-part identifier could not be bound

  Hi guys, I am receiving the error: The multi-part identifier could not be bound. Here is the code: …

  trudye10

  10 replies

  16 years, 10 months ago

  By: trudye10

• Conditional Where clause which has 'in' .

  Hi, i have to select rows from a table based on an 'in' . I will pass a parameter to the procedu…

  descentflower

  6 replies

  16 years, 10 months ago

  By: terrance.steadman

• Calculating Decimals when dividing whole numbers

  OK, I must be missing something obvious. Why does only the last calculation return a fractional val…

  homebrew01

  4 replies

  16 years, 10 months ago

  By: LeeM

• calling NewSequentialId() indirectly from a query

  hi I have a table column with default value newsequentialid() , but I need to get the new GUID gene…

  waleed_m_M

  4 replies

  16 years, 10 months ago

  By: AmolNaik

• Keyword Case

  Choose one. There are no special teachers of virtue, because virtue is taught by the whole communit…

  Orlando Colamatteo

  6 replies

  16 years, 10 months ago

  By: david.tyler

• Try/Catch check for parameters?

  I am having problem throwing error when i have to check for parameters that exists in stored proc.…

  sanjeev40084

  1 replies

  16 years, 10 months ago

  By: Matt Miller (4)

• Find the substring in string

  I have a string in the database like this... >Agenda and Minute >Member Application I need to retr…

  rpyerneni

  11 replies

  16 years, 10 months ago

  By: terrance.steadman

• If Satatement

  Hi there, The below select statement pulls back all the Schedule of Rate Jobs that are held agains…

  TSQL Tryer

  6 replies

  16 years, 10 months ago

  By: Elliott Whitlow

• NEED HELP WITH T-SQL ...........MORE OF A DISCUSSION; MICROSOFT'S GUI DESIGN..

  We all have these issue once in a while ( please wait until I post my question or just say discussi…

  SSISSSRSSSAS

  11 replies

  16 years, 10 months ago

  By: LutzM

• Value of bit field changed on table - trigger to track when/how it changed?

  So we have a table, it has "stuff" in it. One of those columns is a bit and we found a handfull of …

  Maxer

  4 replies

  16 years, 10 months ago

  By: Elliott Whitlow

• Crosstab query

  Hi, TABLE SomeTable1 ( Year SMALLINT, teacher varchar(5), studen…

  Eswin

  23 replies

  16 years, 10 months ago

  By: ramdas.narayanan

• Payroll Database

  Hi All, I need to design a Payroll database for my Mid Size Company. Our Employees are all salary b…

  vblllove

  12 replies

  16 years, 10 months ago

  By: GSquared

• Try/Catch and Finally Block in sql server

  Does Sql Server supports 'Finally Block' in query? Begin Try End Try Begin Catch End Catch Beg…

  sanjeev40084

  2 replies

  16 years, 10 months ago

  By: sanjeev40084