T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Alternative to Cursor for Inserts

  Please see the attached picture for the table structure I am dealing with. Essentially people will …

  Rob-350472

  4 replies

  15 years, 5 months ago

  By: Ben Teraberry

• pivot query

  Hi, I have following set of tables and data in it table1 col1 col2 col1 has a,b,c values col2 has…

  purushotham15

  1 replies

  15 years, 5 months ago

  By: WayneS

• join two select from one table

  hi friends i want to return all rows in MyTable and sum of all num fields: WITH MyTable as ( SELEC…

  dr_csharp

  2 replies

  15 years, 5 months ago

  By: spaghettidba

• DDL trigger

  Hi, I have 2 databases which contain the same table named "Login". If i insert,delete,update it sh…

  sheeba 88002

  1 replies

  15 years, 5 months ago

  By: Paul White

• Can i use Default in Alter Statements

  hi, I am having a table. which is taking by default NULL values... Now i want to update the Column …

  Pulivarthi Sasidhar

  2 replies

  15 years, 5 months ago

  By: Paul White

• Try..Catch.. and @@Trancount>0 location

  The following extract is from http://msdn.microsoft.com/en-us/library/ms175976.aspx >>> …

  Barkingdog

  6 replies

  15 years, 5 months ago

  By: Paul White

• The best way to add next month

  Please look at the follow code: - The variable @Date has the value is 201012 (yyyymm) - …

  nguyennd

  14 replies

  15 years, 5 months ago

  By: Paul White

• PATINDEX one set against another?

  I have a a table with a column of items, say: ALPHA_12, BETA_GAMMA_25, DELTA_PRODUCTION, TXEPSILON.…

  Seth Kramer

  9 replies

  15 years, 5 months ago

  By: Paul White

• selecting column name dynamically

  Hi all I have a scenerio where i have to select a column dynamically to update.. its some thing lik…

  simplykash

  6 replies

  15 years, 5 months ago

  By: Jeff Moden

• where is sys.functions?

  I was writing some sqls that was pulling out object names from the meta data: it's pretty intuitive…

  Lowell

  4 replies

  15 years, 5 months ago

  By: Paul White

• Generating delete statement from tablename stored in another table

  I have a function that returns me values passed in comma separated string in table format. select s…

  gaurav-404321

  5 replies

  15 years, 5 months ago

  By: Paul White

• Problem With Sum

  I have a table like this CREATE TABLE AAA(K int, K1 int, MONEY int) And i have a SQL like this SELE…

  nguyennd

  2 replies

  15 years, 5 months ago

  By: Paul White

• Help with keeping the leading zeros

  Hello, I run this query Select * into dbo.ReportFinal from ( SELECT A.MedRecNo, A.A…

  JasonYousef

  6 replies

  15 years, 5 months ago

  By: JasonYousef

• Stored procedure Logic

  Hi All, I am not so good at SQL coding and need your help in writing a SP which does the following,…

  Mohammed Mohsin-392707

  8 replies

  15 years, 5 months ago

  By: Lynn Pettis

• SQL Join

  Hi: I have to write a query to select data from two tables(table A and table B). Both tables have …

  h_maksuda

  5 replies

  15 years, 5 months ago

  By: h_maksuda