T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Question variable substritution

  Hi All, I have a question on variable substitution. I have secario-1 and scenario-2 In scenario-1, …

  Oracle_91

  4 replies

  13 years, 8 months ago

  By: Jeff Moden

• Multiple Records / Max Date with a Twist

  I have an interesting one here. I have a table of Purchase Order Item information where if there i…

  rmortellaro

  10 replies

  13 years, 8 months ago

  By: TomThomson

• Using Case and NULL values

  Hi all, New to SQL and I thought I had a solution in the following query, but realized that when on…

  djdeel

  5 replies

  13 years, 8 months ago

  By: Sean Lange

• Joining, but need to find the row with the min values in it

  Hi, I am LEFT joining to a lookup table by product code to find a product cost. The problem is that…

  greg.bull

  9 replies

  13 years, 8 months ago

  By: Mark Cowne

• Why is my transaction automatically rolled back?

  Hi, it seems like SQL Server silently rolls back my transaction in some cases. If you try to drop a…

  hemul

  3 replies

  13 years, 8 months ago

  By: hemul

• BCP - exporting SSRS

  I need to export my RDL files from my report server to a file(s). Here is the syntax to give me wha…

  krypto69

  3 replies

  13 years, 8 months ago

  By: rlue-882234

• DateTime Issue

  Hi all, i have two DateTime fields in my table (from and to) which can be null.i want to write a st…

  MuhammadShafiq

  6 replies

  13 years, 8 months ago

  By: Ninja's_RGR'us

• single query

  can we make the following into single query? Select count(*) count1 FROM (SELECT DISTINCT tro.reg…

  Anamika

  3 replies

  13 years, 8 months ago

  By: Mark Cowne

• 7405 Error

  I'm trying to set up a procedure to run at server startup. It access another db on another instance…

  mdevore

  1 replies

  13 years, 8 months ago

  By: Kaneabell

• iTVF: Better way to code this?

  Scenario: Given value1, return value2 which can have three possible values. Doing this as a scalar …

  Pam Brisjar

  18 replies

  13 years, 8 months ago

  By: Pam Brisjar

• Dynamic Variables in Dynamic SQL?

  Hey all. Thanks in advance for any help at all. I'm having problems declaring and using variables i…

  luckyb

  6 replies

  13 years, 8 months ago

  By: homebrew01

• Get Column and table name from given Query

  Get the all column and table name from sql query for example select emp_id, emp_name ,d.department…

  srikant maurya

  7 replies

  13 years, 8 months ago

  By: Lowell

• How to write use dbname in a loop

  Hi All, I am trying to to execute below script: DECLARE @intFlag varchar(30) set @intFlag = 'test' …

  Raghavender Chavva

  4 replies

  13 years, 8 months ago

  By: Lowell

• SQL Query Column Dynamic Alias Name Issue

  I have written a query which will return Rows as columns data for the past 5 years (dynamically). Q…

  sreeni2219

  3 replies

  13 years, 8 months ago

  By: Kalaivani.Ayyasamy

• Import Excel table data

  Hi all, i have excel(.xlsx) file having alot of data.how i can import it to sqlserver2005's table?

  MuhammadShafiq

  16 replies

  13 years, 8 months ago

  By: MuhammadShafiq