T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How do I get last record in a month when no guarantee month exists of unique dates

  okay in a pickle following table global_usage ID varchar (contains alphanumeric values,not unique) …

  Resender

  6 replies

  10 years, 5 months ago

  By: Resender

• Need help to display row as 2 days ago, 1 hours 34 Minutes ago, 11 minutes ago

  My table as data as follow, IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[d…

  Qira

  6 replies

  10 years, 5 months ago

  By: ScottPletcher

• Update statement performance

  Hi all, While working on a performance task I need to optimize the performance ofthe query which is…

  kapil_kk

  6 replies

  10 years, 5 months ago

  By: ScottPletcher

• Suggest TSQL for this logic

  I have 3 tables 1.Stage 2.Master 3.History all the three table having same table structure. eg. Col…

  Gaja

  2 replies

  10 years, 5 months ago

  By: Sigerson

• Order change in Parent to its child tables using FK relations

  Hi Experts, I have used Aasim Abdullah's (below link) stored procedure for dynamically generate…

  Naveen J V

  1 replies

  10 years, 5 months ago

  By: Sean Lange

• Instead of Delete Trigger

  I have one 'instead of delete' trigger on one table, which I want to use to control what gets delet…

  vincent.baxter

  3 replies

  10 years, 5 months ago

  By: John Mitchell-245523

• Get last non null value from column

  Hi I have tried a number of different attempts to get this going and am not having any luck, I hav…

  Marcus Farrugia

  8 replies

  10 years, 5 months ago

  By: serg-52

• You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field.

  Hello Friends I have written a query that have a sub query. That works fine for fetching single col…

  hasnain_ahmad

  3 replies

  10 years, 5 months ago

  By: MadAdmin

• Two from clause in DELETE statement -- issue

  Hi Experts, I am supposed to delete all rows from USER and its child tables based on PracticeID = '…

  Naveen J V

  5 replies

  10 years, 5 months ago

  By: Gaja

• substring xml data

  i have a table that has defined as xml. I would like to parse out one of the values, as a row by r…

  tcronin 95651

  4 replies

  10 years, 5 months ago

  By: tcronin 95651

• Difference in query output

  Hi all, Can you guys please tell me why I am getting different rows in output from below queries: S…

  kapil_kk

  3 replies

  10 years, 5 months ago

  By: serg-52

• Unusual Recursive CTE with non-unique codes

  Hi all I think this is an unusual circumstance because I cannot find any info to help with this and…

  david.edwards 76768

  6 replies

  10 years, 5 months ago

  By: david.edwards 76768

• PeopleSoft query expression to calculate age on SQL server

  I have been trying to calculate age and the results either round the age up one year or down one ye…

  khandwerk582

  3 replies

  10 years, 5 months ago

  By: Lynn Pettis

• Varchar(8000) Concat

  I have two string variables each has Varchar(8000) Declare @VariableA varchar(8000) Declare @Variab…

  kcj

  3 replies

  10 years, 5 months ago

  By: Eirikur Eiriksson

• Create Trigger On master.sys.database_mirroring ?

  Hello, I tried a quick search about this subject but cannot find any relevant topic. I don't even k…

  franck.maton

  8 replies

  10 years, 5 months ago

  By: Jacob Wilkins