T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• need north american zipcodes db. More concerned w/ vilidity than cost

  Do any of you have a trusted one that i can buy. Not concerned w/ cost. i just need the data to be …

  Snargables

  5 replies

  14 years ago

  By: Snargables

• My problem with output parameters

  Is there anyway we can check the value returned by output parameter... Like for example Create sp_E…

  itskanchanhere

  14 replies

  14 years ago

  By: Lowell

• Dead Lock Victim

  How SQL server choosing the Deadlock Victim???~~??

  mc2601

  5 replies

  14 years ago

  By: Gail Shaw

• Smallest Decimal

  Hey all, I have a percentage stored as a decimal as per this: 87.41 is 87.41% It is stored in a dec…

  danielfountain

  14 replies

  14 years ago

  By: danielfountain

• Simple Insert Stored procedure

  Need to write a simple Insert stored procedure (Single insert)with proper error handling.. The sp s…

  itskanchanhere

  20 replies

  14 years ago

  By: Mike John

• Why is this T_SQL update not working ??, Please help to understand

  Declare @table_S table (i int, j int,k int) Declare @table_D table (i int, j int,k int) Insert into…

  Mathew Abraham

  12 replies

  14 years ago

  By: Lynn Pettis

• inserting to primary table and secondary table at the same time

  Hi All, Assessments (assessmentid identity(1,1), title varchar(100),sectionid int,maxpoints decimal…

  Sarsoura

  1 replies

  14 years ago

  By: LutzM

• how to dynamically create columns for single row result set.

  Given this table data; ID StartDate EndDate 239 2011-05-05 00:00:00.000 201…

  Geoff A

  7 replies

  14 years ago

  By: Geoff A

• T SQL joins to ansi sql joins conversion

  Is there an easy way to convert T-SQL (*=) joins into ANSI ( LEFT / RIGHT) joins, rather than going…

  jayan_unni

  16 replies

  14 years ago

  By: Orlando Colamatteo

• I need some help with PIVOT please

  I need some help with PIVOT please. I just can't wrap my head around this one... CREATE TABLE #Tes…

  Chrissy321

  5 replies

  14 years ago

  By: ColdCoffee

• Comparing columns in two tables for unequal values

  Hi, We have a double data entry process and want to compare the entries of one record in Table A to…

  mapperhd

  9 replies

  14 years ago

  By: vikingDBA

• Check Duplicate with Composite Key

  Hello, Sorry if this topic already exists but I did not find it. I have a table Allocation used to…

  Scaramouche

  2 replies

  14 years ago

  By: Scaramouche

• Handling Deadlocks

  I have one procedure which is run parallely multiple times to insert data into one table for differ…

  sqlnaive

  3 replies

  14 years ago

  By: Gail Shaw

• Merge statements and how to get around them...?

  I have a bit of a problem with getting some data updated properly but am unsure how to proceed. I'm…

  tacy.highland

  4 replies

  14 years ago

  By: tacy.highland

• question regarding local variables

  basically I have a sequential index on this table and Im trying to combine the results into 1 colu…

  jfriedl

  3 replies

  14 years ago

  By: jfriedl