T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• 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

  9 years, 1 month ago

  By: Sergiy

• Converting Hex String to Int

  When converting a constant hex string '09FF000' to INT. It is simple as below Select Convert(Int, 0…

  AK007

  7 replies

  9 years, 1 month ago

  By: Sergiy

• get the first Sunday and last Saturday

  hI, can anyone help me how to get the first Sunday and last Saturday of every month for a year. i n…

  jagadeeps

  22 replies

  9 years, 1 month ago

  By: Lowell

• Help with select statement when WHEN Clause involving multiple databases

  I would like to write a Select Statement, which will bring additional columns from different databa…

  skb 44459

  3 replies

  9 years, 1 month ago

  By: Lowell

• Charindex in inner join affects the perfomance

  Hi, I have a procedure which has below query, Select a.column,count(distinct(c.column)) from table1…

  kore.sid

  9 replies

  9 years, 1 month ago

  By: Luis Cazares

• Read and parse XML -- tsql

  Hi All, I want to read the below xml and wherever i find p1id tag in the xml (as highlighted below)…

  sam 55243

  3 replies

  9 years, 1 month ago

  By: Eirikur Eiriksson

• Case Pivot Table inside Function

  hi Guys, Gals- I have the following query which works well. However, changing this to reside inside…

  fergfamster

  7 replies

  9 years, 1 month ago

  By: fergfamster

• sp_executesql : Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.

  Hi, I am using dynamic query in stored procedure. while i am trying to execute the SQL Query in th…

  antonyvijayan

  7 replies

  9 years, 1 month ago

  By: Gimli son of Gloin

• Sum with Isnull

  Hello, I am trying to add multiple row data with ISnull in but I couldn't seem to make it work. My …

  TeenaR

  8 replies

  9 years, 1 month ago

  By: TeenaR

• How to dynamically determine how many columns and their names that are in a work table

  Hello, I have an event process routine that creates a work table with one record in it with multipl…

  jpgillum

  5 replies

  9 years, 1 month ago

  By: jpgillum

• how do i capture the result set from a query into a variable @SQLstr so I can exec(@SQLstr)

  I have the following SQL that creates the output I need to capture in a variable like @SQLstr so th…

  jpgillum

  1 replies

  9 years, 1 month ago

  By: Lowell

• Query to get Last month's Data

  Hi...I have a requirement, A stored proc will be scheduled to run some day in a month. It has to ge…

  ssismaddy

  8 replies

  9 years, 1 month ago

  By: Jacob Wilkins

• MSG 444 - Select statements included within a function cannot return data to a client.

  I'm trying to create a user-defined function that will count the number of stores in each state and…

  ajwilliams504

  6 replies

  9 years, 1 month ago

  By: Luis Cazares

• The USE command and variables

  Sorry if this has been covered but as you might imagine searching for this has been problematic. I …

  Andrew Ryan

  9 replies

  9 years, 1 month ago

  By: Sgar...

• Deleting All Characters before 2 Set Characters

  I have a table that has data like DDR Return PP12345 DDR Resturns PP12356 DDR Retunrs PP12367 I ne…

  les.61

  4 replies

  9 years, 1 month ago

  By: Luis Cazares