T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• sp_send_dbmail Query

  Regarding the @query parameter, BOL states: "Note that the query is executed in a separate sessio…

  dan-572483

  4 replies

  12 years, 10 months ago

  By: ScottPletcher

• Locking on update...inner join

  Thought I would re-write as it didnt make sense to me! When an update query is based on a join, so …

  david.alcock

  2 replies

  12 years, 10 months ago

  By: david.alcock

• complex joins retrive the echivalent results

  Hello I have a problem on doing an complex join between multiple tables : Here is my tables GLCMS …

  Beniamin Joke

  15 replies

  12 years, 10 months ago

  By: J Livingston SQL

• ALTER SERVER ROLE syntax error

  HI all I am trying to run the following but I get a syntax near 'ROLE' error, but it looks ok to me…

  Kwisatz78

  3 replies

  12 years, 10 months ago

  By: louigopal

• Denormalizing into a grid

  I just read the article on using UNPIVOT to normalize data. I noted that it said that UNPIVOT doesn…

  rray 44280

  6 replies

  12 years, 10 months ago

  By: Dwain Camps

• GetDate() 5 Years ago without time formated 'YYYY-MM-DD'

  I'm trying to restrict a query to go back five years ago. I have the following query which is not i…

  Welsh Corgi

  12 replies

  12 years, 10 months ago

  By: Steven Willis

• Check series is valid or not

  Hi, I have a scenario in which I have to check that whether I am correct no of series or not... Cre…

  kapil_kk

  7 replies

  12 years, 10 months ago

  By: Steven Willis

• Finding the most recently modified row from a group of tables

  I'm thinking there's some clever way of doing this, probably involving a CTE and recursion, but I'm…

  rray 44280

  6 replies

  12 years, 10 months ago

  By: ScottPletcher

• Running Dynamic SQL

  Hi All, I have in the past created dynamic SQL in a tally table and looped through to execute it. …

  Ness

  3 replies

  12 years, 10 months ago

  By: MMartin1

• performance of sp

  hi my sp is taking 5 min in prod.any way i can improve performance BEGIN TRY DECLARE @alerts TABLE …

  riya_dave

  7 replies

  12 years, 10 months ago

  By: Cowboy DBA

• MIN and MAX values with a subquery.

  Hi Everyone I have the following query in one of my databases. It returns 20 rows. SELECT C_…

  Johnny H

  4 replies

  12 years, 10 months ago

  By: Johnny H

• If Exists

  Hi all, I just want to know that in my below code is it possible to combine first two exists condit…

  kapil_kk

  9 replies

  12 years, 10 months ago

  By: kapil_kk

• APPLY Syntax

  I got the following example of some code to use an OUTER APPLY to get some data I need. I was able …

  rray 44280

  1 replies

  12 years, 10 months ago

  By: Sean Lange

• passing different values into a variable

  Hi I have a an SP that returns the size of the backup files into a table. To execute the Sp i have …

  PearlJammer1

  4 replies

  12 years, 10 months ago

  By: Sean Lange

• blocking remove

  hi i am adding new column with default value this table has millions of rows, so while i am executi…

  riya_dave

  2 replies

  12 years, 10 months ago

  By: WolfgangE