T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Concatentate nvarchar(1024) field for text mining

  Greetings! I have a table which is primarily used for chats and stores chats as text segments with …

  anish_ns

  3 replies

  15 years, 6 months ago

  By: LutzM

• How do I show items dated 1 day from current date?

  Greetings experts, I have strongly very much with this query all day today. I have a fieldname of d…

  simflex-897410

  47 replies

  15 years, 6 months ago

  By: simflex-897410

• parse Real data type

  HI All, For folloing code, I wanted to get '163773.58', but actually I got '163774'. Can any one he…

  wwei

  12 replies

  15 years, 6 months ago

  By: Giri Duddu

• Need to take one row with max of id from a table with multiple rows with same data

  hi, i have a table with few columns as table source (id,memno,date_trans,name1,name2,x,yz..) after …

  dsandhyarao

  4 replies

  15 years, 6 months ago

  By: sunjer777

• Cross Apply, Help me ?

  create table A(A1 int) insert into A(A1)values(1) insert into A(A1)values(2) insert into A(A1)value…

  nguyennd

  8 replies

  15 years, 6 months ago

  By: Paul White

• How to get the duplicate count

  Hai To all this is a query WITH A AS ( begin declare @tblname varchar(8000) declare @qry varcha…

  sqlfriends@sql.com

  2 replies

  15 years, 6 months ago

  By: thecoding

• Complex T-SQL query

  Need to write a T-SQL query to retrieve the following information: In the case below, I require Fai…

  kevin_nikolai

  21 replies

  15 years, 6 months ago

  By: LutzM

• Very complex - How to count difference data

  CREATE TABLE [dbo].[AAATable]( [col1] [int] NULL, [col2] [char](1) NULL, [col3] [char](2) NULL )…

  nguyennd

  15 replies

  15 years, 6 months ago

  By: Jeff Moden

• i cant get the column headers added when i do a bcp queryout

  Is anyone aware of a way to ensure when i do the bcp queryout that the column headers will be inclu…

  BaldingLoopMan

  1 replies

  15 years, 6 months ago

  By: Welsh Corgi

• using dynamic query to alter / create database objects in all databases

  Hi, We are using sql server 2008. We have a separate database for each of our clients. Some of the …

  Sridhar-137443

  8 replies

  15 years, 6 months ago

  By: BaldingLoopMan

• How do i select the top1 column from a table in a select statement which contains multiple columns from multiple columns

  I am trying to get the top1 column from a table in a select statement which contains multiple colum…

  Ismail Ahmed

  5 replies

  15 years, 6 months ago

  By: LutzM

• Arithmetic overflow error converting float to data type numeric

  Hi All, I imported some data from text file to sql server 2008. Import Export wizard created a tabl…

  apat

  22 replies

  15 years, 6 months ago

  By: LutzM

• Question: Profiler trace!!!

  Hello again, As i was reading in a fantástic link send by Gail Shaw, i put a profiler running to ca…

  JMSM

  2 replies

  15 years, 6 months ago

  By: JMSM

• How do I delete duplicates in a COUNT result?

  Hi, I run this query to find duplicate fields(duplicate values in the FieldName column) in this tab…

  rnunez

  4 replies

  15 years, 6 months ago

  By: mister.magoo

• Problem in join update

  I have created the following update: update a set a.Test = '-Grid ' + b.comp_ + '- ' + Comments2 f…

  DobermannCanis

  21 replies

  15 years, 6 months ago

  By: SQLRNNR