T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Problem with grouping on multiple columns with subtotals

  Hiya guys, I have a table like below: SELECT [Province] ,[Date] ,[Region] ,[Sto…

  jeedee

  1 replies

  15 years ago

  By: Orlando Colamatteo

• How to tune text queries

  Hi, I am trying to search the possibilities for tuning the query in which it goes for index scan. s…

  AJ07

  14 replies

  15 years ago

  By: Paul White

• Is there any way to keep one global temp table, and avoid to be changed by other SQL Script?

  Hi everyone, Is there any way to keep one global temp table, and avoid to be changed by other SQL …

  lindsaywang

  5 replies

  15 years ago

  By: sturner

• Stored Procedure: IF...WHERE help

  Hi everyone I have this stored procedure. CREATE PROCEDURE [dbo].[sp_EE_A_disabled] @inT1 VARCHAR…

  Jako de Wet

  3 replies

  15 years ago

  By: Jako de Wet

• Another Bulk Insert Question

  Is bulk insert only from file -> table? Or can you use bulk insert from table -> table withou…

  Khades

  2 replies

  15 years ago

  By: Paul White

• t-sql OUTPUT clause vs. scope_Identity()

  It is common practice to use scope_identity() to return the identity value of a newly inserted reco…

  Barkingdog

  1 replies

  15 years ago

  By: Paul White

• Problem with Stored Proc returning XML using For XML

  Hello All, Please help me with this problem. I have a UI which has some combobox for selecting Data…

  varshavmane

  3 replies

  15 years, 1 months ago

  By: Matt Miller (4)

• Computed columns

  I have this other scenario: Select a.Id, (Select Sum(b.quantity) from TableB b from b.Id=a.Id) AS …

  camiloaguilar1

  2 replies

  15 years, 1 months ago

  By: camiloaguilar1

• Difference in tables columns

  Table 1 OrderID | ProductID | Quantity | Price | Total --------------------------------------------…

  camiloaguilar1

  5 replies

  15 years, 1 months ago

  By: camiloaguilar1

• Help with getting a value in correct order

  Please bear with me through what I am being requested to do... it is a bit confusing. I need to gen…

  Paul Morris-1011726

  3 replies

  15 years, 1 months ago

  By: Paul Morris-1011726

• Trigger help

  i have the following trigger. basically, anytime i update a table, i need to copy the row to a his…

  tkacyndra

  11 replies

  15 years, 1 months ago

  By: Sean Lange

• Dynamic pivot Table with operator PIVOT

  Hello comunity -i have the following script based on my invoice table to return by customer the amo…

  luissantos

  1 replies

  15 years, 1 months ago

  By: kumar20

• Trigger Problem

  I have a "TimeSlot" table. I created a trigger to prevent overlaps. When I try to do updates that s…

  BSavoie

  2 replies

  15 years, 1 months ago

  By: BSavoie

• Database table Change

  Please could someone help with the Immediate decision.. we have an application and there are 500/60…

  Lucky9

  2 replies

  15 years, 1 months ago

  By: Lucky9

• Finding sets of records

  I think I'm overthinking this query...if anyone can point me in the right direction it would be mos…

  tacy.highland

  39 replies

  15 years, 1 months ago

  By: tacy.highland