T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Converting Oracle SQL statements to SQL 2008

  Oracle SQL: SELECT (NVL(v1.non_credit,0) - NVL(v2.credit,0)) settle_amt from (SELECT sum((trans_a…

  Patti Johnson

  11 replies

  15 years ago

  By: Patti Johnson

• How to Compare Month\date

  Hi All, i have below requirement, we are checking only month and date. If the FYME is < or = pay…

  sambireddy chirra

  5 replies

  15 years ago

  By: kramaswamy

• Need help with store proc.....that great

  Hi, I need to write a store proc to move the data from table1 to table2. Both tables are in differe…

  sqlmaverick

  2 replies

  15 years ago

  By: GSquared

• Need help with store proc.....that great

  Hi, I need to write a store proc to move the data from table1 to table2. Both tables are in differe…

  sqlmaverick

  2 replies

  15 years ago

  By: Lowell

• Question about MERGE with DELETED

  I have a situation where our data pump 1) copies (saves) rows into a history table if it's going to…

  BobMcC

  4 replies

  15 years ago

  By: Orlando Colamatteo

• Performance of Output Parameter

  Is the no. of output parameter will hit the performance of a procedure?? if yes why?

  ghanshyam.kundu

  3 replies

  15 years ago

  By: Grant Fritchey

• A good T-SQL Programming book

  Hi everybody, could you suggest a good book for SS programmer? Some time ago I loved the one by Kev…

  valeryk2000

  9 replies

  15 years ago

  By: Welsh Corgi

• Restrict Autogrowth size( File Growth ) of a Database to 10 percent :)

  I wish to restrict Autogrowth size ( File Growth ) of all the data files and log files of the Users…

  aby_dvd

  2 replies

  15 years ago

  By: calvo

• Joins based on condition

  Hello I need to join Table A with Table B or Table C based on condition My Table A consists a colu…

  Sachin4all

  5 replies

  15 years ago

  By: Sachin4all

• Why Sql server?

  Hi We need to choose our database server. Everyone suggests different servers. They are putting var…

  vmssanthosh

  6 replies

  15 years ago

  By: Jayanth_Kurup

• Change email Subject based on query output

  Hi all, I need help with the following. The code below works fine but I would like to change the su…

  d.raes

  3 replies

  15 years ago

  By: d.raes

• Restore slowdown

  Hi all, There are 3 of developers here in my office. Two of them can restore a database (4GB comp…

  mike 57299

  2 replies

  15 years ago

  By: Welsh Corgi

• How to avoid pulling the same record from the same table

  SQL Server 2008, EE, 64-bit I've got a table in a DB that get's populated with daily reporting info…

  MyDoggieJessie

  3 replies

  15 years ago

  By: MyDoggieJessie

• Copy From FlatFile Using Wildcard in File Name

  Hello all, What I'm trying to do is: -Grab info from a flatfile that is dumped by an external progr…

  jason.spamalicious

  10 replies

  15 years ago

  By: Orlando Colamatteo

• One procedure to insertupdate all master tables using if statements

  hi our manager is giving a new idea of having only one procedure for insert update and deleting all…

  vmssanthosh

  27 replies

  15 years ago

  By: Orlando Colamatteo