T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Cursors and Table Variables

  I have a condition where I needed to create a Table variable and insert into that table. Now I need…

  Faye Fouladi

  3 replies

  14 years, 12 months ago

  By: Johan Bijnens

• Fetch Data For the 2 previous Quarters , Current Quarter and next 2 quarters

  Hi All , I am confused in getting the data from Store Procedure to one of my report . My scenario i…

  rajeshm.0019

  3 replies

  14 years, 12 months ago

  By: Robert Klimes

• Indexed Computed Column Not Used to Perform Seek

  Hi, To set the scene, I saw that an end user query in an reporting application was using a case sta…

  HowardW

  20 replies

  14 years, 12 months ago

  By: HowardW

• Remove Characters which lies between special Characters

  All , I am looking for a t-sql command which gives me best output for the character field i have ,,…

  rajeshm.0019

  4 replies

  14 years, 12 months ago

  By: The Dixie Flatline

• How to display the database data

  How to display the database data

  tamir-859073

  2 replies

  14 years, 12 months ago

  By: toddasd

• Understanding update statement

  hi all, sorry for my poor english hope someone can help me understanding something that i couldn´t…

  kharlos

  6 replies

  14 years, 12 months ago

  By: GSquared

• Need Cascade Delete like Stored Procedure

  Hi Gurus, I require to delete the data from reference tables (child tables) and then delete…

  francissvk

  5 replies

  14 years, 12 months ago

  By: Lowell

• Need Concatenation result

  Hi, Create table script, create table abc_test2 (adr_club_name nvarchar(10) null, adr_state nvarcha…

  kiran.rajenimbalkar

  3 replies

  14 years, 12 months ago

  By: kiran.rajenimbalkar

• Procedure is becoming slow but equivalent query is coming faast

  I have a strange issue. I have a procedure with two parameters. If I execute that procedure by givi…

  ashokdasari

  3 replies

  14 years, 12 months ago

  By: ashokdasari

• LEFT OUTER JOIN if True INNER JOIN if False

  I have a stored procedure as such DECLARE @Flagged bit SELECT a.[ColumnA] , a.[ColumnB] FROM […

  Always Learning

  10 replies

  14 years, 12 months ago

  By: mtassin

• Double the resultset for reports

  Hi all, I have a delivery report (Crystal Reports XI) which I want to get printed out twice. And th…

  reto.eggenberger

  1 replies

  14 years, 12 months ago

  By: jeedee

• how to trim only the leading zeros in the tsql query

  Hi Folks, i have a tsql query as below, see the highlighted bold: SELECT RTRIM(ISNULL(dbo.Perso…

  parthmeister

  4 replies

  14 years, 12 months ago

  By: Lowell

• stored procedure

  I have a requirement whereby I have to query 3 different tables and return the results in one resul…

  solus

  6 replies

  14 years, 12 months ago

  By: solus

• Dates must be shown as string with comma separtor

  I have table User ID Date 1 01\03\2011 1 02\03\2011 1 03\03\2011 1 07\…

  sujavani.l

  5 replies

  14 years, 12 months ago

  By: Jeff Moden

• How to return hrs,mins and secs from a function when date time stamp is passed to that function..

  Hi All, Can anyone please let me know how to write a function ... for returning days,hours,minutes …

  srividyakudumula

  9 replies

  14 years, 12 months ago

  By: WayneS