T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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, 4 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, 4 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, 4 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, 4 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, 4 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, 4 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, 4 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, 4 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, 4 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, 4 months ago

  By: Jeff Moden

• Aggregate Issue

  I have some base data which I will use to creat a cross tab report. The data consists ot trade tran…

  eseosaoregie

  1 replies

  14 years, 4 months ago

  By: drew.allen

• Dynamic SQL in a Function (again)

  I have a SQL Agent job which runs a query and does other things depending on if the query returns r…

  dan-572483

  12 replies

  14 years, 4 months ago

  By: dan-572483

• load sql server 2008 db to 2005

  Hi! i use Sql server 2008. i made my db in 2008. But my customer has sql server 2005. i need to loa…

  sa.ordekci

  2 replies

  14 years, 4 months ago

  By: SQLRNNR

• Size of each table per database per instance in one code

  Hello, I' m looking for t-sql code to obtain all tables size within instance. I tried to look on in…

  joonzz

  4 replies

  14 years, 4 months ago

  By: spaghettidba

• Multi Line output column

  Hi , I have a requirement to show an output with new line breaks in one of the output column. This …

  jyz

  1 replies

  14 years, 4 months ago

  By: SpringTownDBA