T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• HELP wanted in advanced group by, - thanks.

  Hi everybody - hope you can and will help. This is an table with potentiel dublicates in MSLINK and…

  ckri

  4 replies

  14 years, 7 months ago

  By: ckri

• temp tables

  Hi, I have been receving complaints about losing temp tables, USers say that they lost their temp t…

  Tara-1044200

  7 replies

  14 years, 7 months ago

  By: Johan Bijnens

• Optimize hint has huge implications. Why?

  I am a very large database specialist and came across very peculiar SQL Server behavior on which I'…

  nico van niekerk

  46 replies

  14 years, 7 months ago

  By: Ninja's_RGR'us

• SQL Code Help

  HI All I am trying to generate a customer error column which will be generated via code only and no…

  aarionsql

  29 replies

  14 years, 7 months ago

  By: ChrisM@Work

• Run Storedprocedure syntax dynamically in database

  I have storedprocedure .sql file, it contains content from "create proc ......". I want to run this…

  Sarvesh Kumar Gupta

  6 replies

  14 years, 7 months ago

  By: Divine Flame

• how to create a GUID for the following case !!

  i have the following table table1 customer inventory item billingzip tom, …

  koolme_85

  6 replies

  14 years, 7 months ago

  By: koolme_85

• sql query help

  select pricelist_header_guid ,[customer_name] ,'BKS_US_CONTACT' ,[Contract_Num…

  koolme_85

  5 replies

  14 years, 7 months ago

  By: koolme_85

• Update with Inner Join

  Hi All, I have an update statement i want to execute but when i do the select statement the number …

  martin.kerr 34088

  25 replies

  14 years, 7 months ago

  By: ChrisM@Work

• T SQL to track changes

  Hi, I have a requirment which i have never worked on and need some help to proceed. I have a list o…

  snigdha.mishra190

  4 replies

  14 years, 7 months ago

  By: sami.sqldba

• Updating column (MembershipNumber) using DELETE trigger

  Hi All, I hope you can help. I've got a membership table that includes a column "MembershipNumber" …

  kp81

  1 replies

  14 years, 7 months ago

  By: kp81

• Try catch in a transaction block or transaction in try catch block???

  Simple task - Perform a few inserts or updates on multiple tables in the same database. If there is…

  krishna.vanne

  32 replies

  14 years, 7 months ago

  By: SQL_By_Chance

• Adding a column alias to be the field name in a new table

  Hi, I am creating a staging table in sql 2008 R2.This will take all my data from 2 or more tables a…

  79J

  8 replies

  14 years, 7 months ago

  By: Jeff Moden

• To change datetype varchar(14)

  Dear All, i have column in my table which of datatype varchar(14) (20111107070115) , now i want to …

  rashid_alavi

  16 replies

  14 years, 7 months ago

  By: Jeff Moden

• Percentile function

  hi, it seems SQL 2012 had new function called PERCENTILE_DISC() which will find out the percentile.…

  dva2007

  10 replies

  14 years, 7 months ago

  By: Jeff Moden

• PIVOT function usage - Help needed

  Hello, I have a table with the following columns... CustomerID, OrderID, OrderDate, OrderAmount The…

  SQLCurious

  3 replies

  14 years, 7 months ago

  By: Jeff Moden