T-SQL

• Topics

  Started by

  Posts

  Last post

• Truncating Date

  What is the best/most efficient way to truncate DateTime to it's Date value only? I have a stored p…

  Andrew Deren

  26 replies

  16 years, 10 months ago

  By: Jeff Moden

• WHERE col NOT IN (SELECT...) not working

  I have a parent child relation between to tables. Not all parents have children, some parents have…

  Dennis D. Allen

  17 replies

  16 years, 10 months ago

  By: RBarryYoung

• IF statement with Select INTO error

  sample script.... declare @type char(1) set @type = 'A' if @type = 'A' begin select * into #temp wh…

  is250sp

  2 replies

  16 years, 10 months ago

  By: is250sp

• Converting Decimal Field into a new Date/Time field

  Is there a way I can convert a decimal field in SQL into a new date/time field? The values in the d…

  Roger Abram

  4 replies

  16 years, 10 months ago

  By: Roger Abram

• How to Convert nx1 dimension table to 1x1 dimension table

  Dear Members, How to Convert nx1 dimension table to 1x1 dimension table here n - rows and 1 - colum…

  santoooo

  6 replies

  16 years, 10 months ago

  By: santoooo

• Update table won't update

  Hi, I posted in the wrong forum earlier. I can't get my update table to update. I know its reading …

  betsy.powlen

  1 replies

  16 years, 10 months ago

  By: ps.

• sql for Login and logout details of sql logins in mssql2000

  Hi, Can any body help me? I need a Tsql which gives the details of Login and Logout of MSSQL2000 us…

  hemant789

  7 replies

  16 years, 10 months ago

  By: Sergiy

• Trying to update rows in table-B based on values in table-A, but only works if value already exists in table-B

  Here's the scenario: Say we have two tables (tempTable and leaseInfo); both tables have leaseNum an…

  Pat_B

  7 replies

  16 years, 10 months ago

  By: Matt Miller (4)

• cursor within a cursor - second cursor needs a loop

  I have a detail file which contains over 200,000 records. I need to read each detail record sequent…

  shellyr

  7 replies

  16 years, 10 months ago

  By: Matt Miller (4)

• for xml and null values

  Hello, I am trying to return a xml string from a query using MSSQL 2000. Something like this... Sel…

  anuragingle

  3 replies

  16 years, 10 months ago

  By: SimonD-978595

• SAX XML Parser error

  Hi All, I am using SQLXMLBulkLoad.SQLXMLBulkload utility in a VBscript. I have been getting a error…

  vish-531091

  1 replies

  16 years, 10 months ago

  By: subrat.das

• How to use Bulk insert with file format "" and with out in cvs file

  Hello all I have cvs file format like this "0160","Abbeville","003",5,2 How to use Bulk insert with…

  william_do2000

  4 replies

  16 years, 10 months ago

  By: Sergiy

• CHECK

  How can I write a check constraint to prevent entering characters below char(32) (space) on a colum…

  daidalus

  4 replies

  16 years, 10 months ago

  By: AnzioBake

• Displaying SQLSErver locked Records.

  Hi, My table is like this: Empid Ename 1 XXXXXx 2 …

  Aswani kumar

  1 replies

  16 years, 10 months ago

  By: Johan Bijnens

• "Unable to open bcp host data-file"

  hi friends i am facing a problem while reading data from text file into a table using BCP utility,i…

  AMOL DASHRATH THOMBRE

  2 replies

  16 years, 10 months ago

  By: Old McDonald