T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• help with joins

  i have 2 table with 1 to many relation table1 hid ,refid cid 500 4 1200 …

  ssurekha2000

  6 replies

  11 years, 10 months ago

  By: Snigdha Vartak

• SQL 2005 into designed Excel via Stored Procedure.

  Hi All, I need to export data from SQL 2005 into Excel. I know I can use bcp or OPENSOURCE, but the…

  BOR15K

  12 replies

  11 years, 10 months ago

  By: tim.hansen

• Need a batch process solution (Non-SSIS if possible)

  Hello... I have the following query which returns information to me on whether a user has gone from…

  SQL_ME_RICH

  2 replies

  11 years, 10 months ago

  By: SQL_ME_RICH

• How many triggers can be implemented in a single table

  1. Well the question is simple. How many triggers can be implemented in a single table. 2. If a tab…

  gopalchettri

  8 replies

  11 years, 10 months ago

  By: Gail Shaw

• how to compare two table and save result into 3rd table

  table1 number sec 1234 458 6895 458 2543 879 3289 84 table2 num…

  amit.overnet

  1 replies

  11 years, 10 months ago

  By: John Mitchell-245523

• Help Needed with TSQL Query

  I have two diff tables TBL1 and TBL2 in which they have mapping on CustNo and CustId ..TBL1 is the …

  Chinna

  12 replies

  11 years, 10 months ago

  By: Chinna

• help with incrementing

  I am not sure if "incrementing" is the right word to describe what I need but here it goes. I am p…

  is250sp

  8 replies

  11 years, 10 months ago

  By: Jeff Moden

• Creating comma separated values for a column in TSQL

  Hi All, Need help in writing tsql for creating comma separated values for a table based on batch si…

  sam 55243

  4 replies

  11 years, 10 months ago

  By: Jeff Moden

• displaying records only if both the values of a field are avaliable

  i have a table with 5 fields field1 will have values as 'd' and 'i' if the field1 of table has both…

  ssurekha2000

  6 replies

  11 years, 10 months ago

  By: Phil Parkin

• Need help in validating users input value(from Screen)

  Hi guys , Urgently i am in need of validating a input variable comes from screen i.e., i have t…

  JoNTSQLSrv

  5 replies

  11 years, 10 months ago

  By: Phil Parkin

• Primary Key

  Hi All, How many primary keys can i create in a table. I mean total number of primary keys in a tab…

  Austin_123

  9 replies

  11 years, 10 months ago

  By: Phil Parkin

• Problem with CTE and filter in Query

  Hi, I have this query that if I filter by 'AND [ORG LEVEL 2] like '%ZSW' it gives me the monthly am…

  krypto69

  2 replies

  11 years, 10 months ago

  By: Phil Parkin

• assign Null value to a column

  In a result sql dataset if the value of a particular column is 0 i need to return Null, how do i ap…

  PradeepVallabh

  2 replies

  11 years, 10 months ago

  By: Luis Cazares

• What is Cross Apply ?

  Hi I'm newbie to SQL ... Please explain in simpler words. What is Cross Apply ? Examples pls...

  vignesh.ms

  3 replies

  11 years, 11 months ago

  By: SQLRNNR

• basic sql question

  Hello! First time post here... hoping for help with what is probably a very, very simple question..…

  henrywinnersinn

  8 replies

  11 years, 11 months ago

  By: Koen Verbeeck