T-SQL

• Topics

  Started by

  Posts

  Last post

• Is it Possible to Execute Two "Select" Statements in SP Parallely

  Dear all, Please confirm me, is it possible to execute two sql statements in SP paralley. why i see…

  santoooo

  7 replies

  17 years, 5 months ago

  By: Jez-448386

• xp_cmdshell

  this is what I have select 'BCP "Select * from MyTestDB.dbo.v_CSVExport where DateRegister > dat…

  ZA_Crafty

  3 replies

  17 years, 5 months ago

  By: Johan Bijnens

• foreign key constraint options

  Hi, I 'm trying to create a foreign key constraint using t-sql. Two of the options in the propertie…

  aggelosmeletiou

  2 replies

  17 years, 5 months ago

  By: Wildcat

• Using 'Where' with 'LIKE' 'AND' 'OR' with NULL values mixed in.

  I'm still a novice at SQL and I'm stuck trying to set up a search on a table that could have four '…

  tybee

  6 replies

  17 years, 5 months ago

  By: tybee

• How to fetch recordsby passing a column name (table is containing more than 5 lakhs records)

  Dear All, I have table which contain more than 5 lakhs of records. When i exectue select * from tab…

  Prakash-485822

  1 replies

  17 years, 5 months ago

  By: tosscrosby

• pls help...need guidance in this stored procedure

  this is my code for stored procedure, ALTER PROCEDURE [dbo].[tray_history] ( @history as varchar(1…

  malar_jay

  10 replies

  17 years, 5 months ago

  By: malar_jay

• SELECT only one row from each group

  The following query: SELECT a.ProgramID, a.Term, b.shortname FROM dbo.tblProgram a JOIN tblProgram…

  Jonathan Matt

  2 replies

  17 years, 5 months ago

  By: Jonathan Matt

• Time Calculation

  Hi guys, This is my first post, I am not too experienced with SQL so please bare with me. I have go…

  InFrA007

  29 replies

  17 years, 5 months ago

  By: MVDBA (Mike Vessey)

• Query for Convert Variable No of Rows into columns

  I am having data in a table like this: ID Name Value Posn HOXE EMAIL g.mang@tjh.com 30 HOXE EMAIL g…

  Muralidaran

  3 replies

  17 years, 5 months ago

  By: Telammica

• DB Migration Checklist

  I suppose to migrate Sybase12.5.4 database to sqlserver2000 database. 1) Copying Schema 2) Copying…

  karthik M

  2 replies

  17 years, 5 months ago

  By: karthik M

• OpenXML problem,HELP!!!

  Hi guys, I need help. I need to update table from xml and I am getting error :' Server: Msg 6603, L…

  natalie_orlovsky

  4 replies

  17 years, 5 months ago

  By: natalie_orlovsky

• query help

  I have a table tbl1 with columns name and number. DECLARE @number int SELECT * FROM tbl1 WHERE numb…

  sql_2005_fan

  2 replies

  17 years, 5 months ago

  By: sql_2005_fan

• Like operator problem

  Hi all. I used like operator to search my customers. But i had problem. In sql query analyser it w…

  sampathsoft

  7 replies

  17 years, 5 months ago

  By: Hari.Sharma

• Transpose data

  Hi, The Table is as follows: Pk Value 1 2 1 Erik 1 Ringberg 1 NewYork 2 3 2 …

  JoyKing

  1 replies

  17 years, 5 months ago

  By: Jeff Moden

• calculating hours worked

  Hi i am having table with emp code and transaction,i want to calculate how many hours he worked for…

  s_lamani

  2 replies

  17 years, 5 months ago

  By: goodguy