T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Parsing multiple key-value pair columns at once

  Hi, I have a table where the data has been loaded in this format (I know it should have been parsed…

  chintan.floydian

  1 replies

  9 years, 10 months ago

  By: Mark Cowne

• getutcdate during daylight savings time

  Our nationwide call center needs to determine if they are making a call between 8 a.m. and 8 p.m. i…

  Marcia Q

  15 replies

  9 years, 10 months ago

  By: MMartin1

• TRY - CATCH with multiple errors

  If I open a new window in SSMS, attempt to backup a database, and the operation fails, I get two er…

  Dave Mason

  10 replies

  9 years, 10 months ago

  By: Dave Mason

• Filling Buckets

  A customer had reported an issue with one of our stored procedures so I took a look and found that …

  David Betteridge

  25 replies

  9 years, 10 months ago

  By: ChrisM@Work

• 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

  9 years, 10 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

  9 years, 10 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

  9 years, 11 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

  9 years, 11 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 se…

  louise 28346

  9 replies

  9 years, 11 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

  9 years, 11 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

  9 years, 11 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

  9 years, 11 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

  9 years, 11 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…

  analoglife23

  5 replies

  10 years, 1 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

  10 years, 1 months ago

  By: Sergiy