T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• 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

  17 years 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

  17 years 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

  17 years 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

  17 years 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

  17 years 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

  17 years 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

  17 years 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

  17 years 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

  17 years 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

  17 years ago

  By: Elliott Whitlow

• Crosstab query

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

  Eswin

  23 replies

  17 years 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

  17 years 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

  17 years ago

  By: sanjeev40084

• DATETIME difference. One client accepts 2009-06-30 in a script file, the other client doesnt accept it but accepts 2009-30-06.

  I have come across the following error: Msg 242, Level 16, State 3, Line 1 The conversion of a char…

  holtshousens

  4 replies

  17 years ago

  By: NazerMohamed

• last few hour of last few days

  Hi friends, i am just wondering how can i get number of activity from the table which is having dat…

  dva2007

  2 replies

  17 years ago

  By: NazerMohamed