T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• UDF - Is Transaction Control possible?

  Hi everybody, i have a problem with a scalar valued function. There are two systems who will use th…

  NewbyUser

  9 replies

  8 years, 3 months ago

  By: Gail Shaw

• looping help

  I have 3 tables. The script below returns 3 records. What I need to do is go through each record …

  is250sp

  5 replies

  8 years, 3 months ago

  By: drew.allen

• Temp Table 'vs' Table Variable 'vs' CTE.

  Hi All, I wants to clear my concept about Temp Table, Table Variable & Common Table Expression…

  IN_Sandeep

  49 replies

  8 years, 4 months ago

  By: Matt Miller (4)

• Invalid use of a side-effecting operator 'INSERT EXEC' within a function:

  -- HERE IS THE PROBLEM.. I CAN NOT USE THE T-SQL (INSERT EXEC) IN A FUNCTION -- ADDITIONALLY, WEL…

  John Esraelo-498130

  52 replies

  8 years, 4 months ago

  By: Lynn Pettis

• selecting top rows by counting a variable total

  Hi currently Ive been using set @rowcount to select the top subscribers in a list Now I wish to sel…

  louise 28346

  9 replies

  8 years, 4 months ago

  By: drew.allen

• I need the list of those left and right side members list in binary tree along with sum(Amount Invested under his left and right side).

  Suppose I have a tree --' RootNode --' --------|------- --' …

  mcasuman2004

  7 replies

  8 years, 4 months ago

  By: chintangandhi007

• help with effective dating logic

  I have a table PS_JOB with the following records..... emplid effdt effseqjobcode 0…

  is250sp

  5 replies

  8 years, 4 months ago

  By: is250sp

• Using Charindex

  Hi All, I'm using stored procedure where i'm getting role Id in comma separated values and i need t…

  sam 55243

  3 replies

  8 years, 4 months ago

  By: Alan Burstein

• Select from two tables, side by side

  I feel like this should be simple, but I'm stumped... I have two tables, with a common ID column, w…

  mannaggia

  7 replies

  8 years, 4 months ago

  By: dindinudin

• Given a date, return nth weekday of month?

  Hi there - I can't seem to gather the steam to figure this out today. I need to find out what the n…

  analoglife23

  5 replies

  8 years, 5 months ago

  By: lhayes.email

• Getting the VARBINARY data into a VARCHAR field

  Hi there! I'm facing a problem. I have loads of data in a table that is converted using the HASHBYT…

  Danspojken

  15 replies

  8 years, 6 months ago

  By: Sergiy

• Insert Same rows Multiple times

  Hi All I got stuck in a place where i don't know what to do next, CREATE TABLE #Temp (Txt…

  CrazyMan

  8 replies

  8 years, 6 months ago

  By: durga.palepu

• Locking during Transactions

  Hi All, I have query regarding locking during transactions. In below query the locks on TABELA is h…

  sam 55243

  2 replies

  8 years, 7 months ago

  By: John Mitchell-245523

• Using CTE Common table expressions with SELECT CASE statement

  Hi, What I need is a way to run different CTE based on the condition. Something like this: WITH CT…

  _UB

  12 replies

  8 years, 7 months ago

  By: drew.allen

• How do I capture the active Stored Procedure Name to use in an error message

  Hello everyone, Does anyone know if there is a variable name which contains the active stored proce…

  jpgillum

  3 replies

  8 years, 7 months ago

  By: Sergiy