T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Incluse Saturday and Sunday in calculation

  Hello, I have a query that aggregates a value based on a date range and excludes business hours. I …

  DaveDB

  13 replies

  11 years, 4 months ago

  By: Phil Parkin

• Apportion amounts between account holders when amount is uneven

  I have a T-SQL problem I need to sort and need help as my grey matter is hurting! CREATE TABLE #Cus…

  MacDaddy

  3 replies

  11 years, 4 months ago

  By: MacDaddy

• Sorting Week Range in Pivots

  I have this query that gives me Select WeekRange as WeekRange, [Open] as 'Open', [Resolved] as '…

  ashok.theagarajan

  1 replies

  11 years, 4 months ago

  By: Dwain Camps

• How to optimize case statement

  Hi, I have several rule on my item name to compute its gender. I know this structure might need to …

  thbaig

  4 replies

  11 years, 4 months ago

  By: ChrisM@Work

• Concatenating field values in one string

  Hi All. I am trying to concatenate multiple field values from a table in one string. Example: IF S…

  indio0617

  30 replies

  11 years, 4 months ago

  By: Jeff Moden

• Nulls inside Cursors

  I can't understand what is happening inside the cursor when you set a variable to null: SET @str…

  phineas629

  8 replies

  11 years, 4 months ago

  By: Luis Cazares

• delete from table based on where exists

  hi i'm trying to delete products in a media event details table where no base forecast exists for t…

  spin

  15 replies

  11 years, 4 months ago

  By: Gail Shaw

• Date Range Search

  Hi im having a problem with date range searchin in SQL... the database consist of 2012 -2013 data. …

  sharon.sfy2k

  3 replies

  11 years, 4 months ago

  By: Luis Cazares

• Holiday table

  Hello and happy new year! I wrote a stored proc that basically aggregates some data based on how ma…

  DaveDB

  7 replies

  11 years, 5 months ago

  By: Phil Parkin

• How to tell if your code is executing inside sp_ExecuteSQL?

  I've got a development scenario where stored procedures (sprocs) will output diagnostic/debug messa…

  Peter E. Kierstead

  3 replies

  11 years, 5 months ago

  By: Dwain Camps

• Size of Query result set

  Hi, I am in process to compute query result set size to compute its impact on network. I am using c…

  thbaig

  1 replies

  11 years, 5 months ago

  By: Christian Graus

• Substring and trimming

  Here is what I have, DECLARE @document varchar(200); DECLARE @document1 varchar(200); SELECT @docum…

  dallas13

  3 replies

  11 years, 5 months ago

  By: dallas13

• SubProcedure (Subroutines) within Stored Procedure

  Is it possible to write the Sub Routine inside the Stored Procedure like below ? The reason I would…

  skb 44459

  6 replies

  11 years, 5 months ago

  By: ChrisM@home

• SUM of COUNT

  Hi, I want SUM of count of the number of records available in database for first WHEN in below quer…

  nasy_mcs

  9 replies

  11 years, 5 months ago

  By: Lowell

• Encrypt and Decrypt

  Hi All, I have an requirement that, i have to Encrypt Salary's Information in my database. Basicall…

  sqlusers

  1 replies

  11 years, 5 months ago

  By: Christian Graus