T-SQL

• Topics

  Started by

  Posts

  Last post

• Carriage return in xp_sendmail

  Hello, I'm running into a very annoying issue that I haven't been able to find any information abou…

  jcantlon

  9 replies

  15 years, 5 months ago

  By: jcantlon

• what is the difference between CAST and CONVERT Function?

  what is the difference between CAST and CONVERT Function? which one is preferred?

  Ripal Patel

  6 replies

  15 years, 5 months ago

  By: Erwin Oosterhoorn

• Correlated Subquery WITHIN a Join

  Hello, I'm wondering if this is even possible: I'm trying to run a query on the msdb database to g…

  seisner

  8 replies

  15 years, 5 months ago

  By: Sergiy

• Vchar to datetime

  I would love a little help with converting the varchar to a datetime. The varchar data is in the fo…

  Uroc

  3 replies

  15 years, 5 months ago

  By: Uroc

• Create date range with only one date using previous record's END DATE

  I need to be able to write a query that will build a start and end date. The end date already exis…

  timmynew11

  15 replies

  15 years, 5 months ago

  By: Jeff Moden

• Calculate growth - difference between currnet and previous row with a little twist

  Hi to all SQL lovers, I am trying to do one tricky calculation. So far I've got half success. Here…

  Pvm_25

  2 replies

  15 years, 5 months ago

  By: Pvm_25

• TRICKY SQL QUERY

  Dear Experts , I would like to do the following :- get the date out of a certain column in a table …

  martin.edward

  7 replies

  15 years, 5 months ago

  By: Garadin

• Issue with Ordering of Location names in table

  Hi, I am executing a SP on SQL Server 2000, to produce a format I require (attached below for refer…

  Sanchit297

  11 replies

  15 years, 5 months ago

  By: LutzM

• Data Matching

  Hi All. I have a table which has following colums with more than 10 million records. COLA COLB Now …

  Austin_123

  2 replies

  15 years, 5 months ago

  By: Austin_123

• date issues

  SELECT * FROM Table1 WHERE mydate =convert(varchar, getdate(), 111) I am running this query in SS…

  mtz676

  5 replies

  15 years, 5 months ago

  By: Lynn Pettis

• Importing data from txt file (fixed length fields)

  Hi folks, hope someone can help? I am trying to import data from a text file, the data does not hav…

  sqletom

  21 replies

  15 years, 5 months ago

  By: moh

• help with update database

  hi, I have a error - property cant be updated or deleted. property 'Domain' does not exist for 'ob…

  Aviad C.

  2 replies

  15 years, 5 months ago

  By: Aviad C.

• Removing Duplicate Records from a Report

  Hi, I have a report that has a summary and a detail/drilldown version. There are two companies with…

  Janie.Carlisle

  3 replies

  15 years, 5 months ago

  By: Janie.Carlisle

• Select distinct top 5 column1 from table order by column2 desc

  I have to get top 5 distinct salesid from the table order by dealid desc.The Dealid is a ever incre…

  Ashwin M N

  1 replies

  15 years, 5 months ago

  By: RP_DBA

• Want to insert Blank inside the main table instead of Null

  Hi, I want to insert data into table such that I get output something like... Location Id Uniqu…

  Sanchit297

  10 replies

  15 years, 5 months ago

  By: Sanchit297