T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Function to format a number

  Never mind - I using Char instead of varchar ******************* What I lack in youth, I make up fo…

  brosspaxedi

  4 replies

  15 years ago

  By: brosspaxedi

• Select rows based on 5 min interval

  Hi All, I found this, but it is for Oracle. I'd like to apply the same concept in sql server. Can…

  joemai

  9 replies

  15 years ago

  By: ColdCoffee

• Compare Records in Table On coloumns

  I have a table with 5 columns. My requirement is if record in each column is equal to one 1 then it…

  rav999

  7 replies

  15 years ago

  By: DougGifford

• Using condition in the select clause based on a sub query

  I'm trying to achieve the following. Table A holds fake names and i want to replace them with the r…

  Lior.F

  6 replies

  15 years ago

  By: Lior.F

• DELETE FROM Table WHERE TableId = 1. 0 row(s) affected. Gives me 2 Reads in Profiler

  I am deleteing some data fom one of the table, which does not have any value. I have some indexes d…

  Abhijit More

  2 replies

  15 years ago

  By: Abhijit More

• execution of sql statement on a linked server

  What are the problems in execution of sql statement on a linked server... Is constraints are availa…

  VENUGOPAL.RR

  2 replies

  15 years ago

  By: VENUGOPAL.RR

• InitCap Function for multiline input.

  Hi All, I want to convert my input in proper format. (initial latter capital.) Input: PRAVIN B PATE…

  Pravin Patel-491467

  1 replies

  15 years ago

  By: HowardW

• Multpile rows in a single row

  Hi i got a table which has data like Table Col1----col2----Col3 X--------1-------a X--------1------…

  tripri

  2 replies

  15 years ago

  By: Tarun Jaggi

• Add Auto Increment type to a column

  Hi, I am migrating from MS access to sql server 2005, and I am facing a problem, In acce…

  chereku

  2 replies

  15 years ago

  By: WayneS

• Vbscript to check if there is any file in a folder

  Hi, I am looking for a vbscript to check if there is any file in a folder, C:\test If there is a f…

  QQ-485619

  2 replies

  15 years ago

  By: Eugene Elutin

• Populate table as per validation

  I have little to no SQL experience so bear with me on this. I have a table say table1 with columns …

  Deepthy

  3 replies

  15 years ago

  By: Eugene Elutin

• TALLY TABLE REPLACING LOOPS

  I have been reading a lot of the tally table articles by Jeff Moden and I have been very impressed …

  sqlislife

  4 replies

  15 years ago

  By: WayneS

• INSERT INTO and UNION

  Hi all, Not a problem more of a 'why does it do that' I have a script that does this: SELECT …

  chris.sennett

  2 replies

  15 years ago

  By: chris.sennett

• Help with understanding a WHERE clause

  Hi All, Working on SQL Server 2005. Have a query that has a WHERE clause as follows: WHERE (Documen…

  Denesh Naidoo

  3 replies

  15 years ago

  By: Denesh Naidoo

• Need a Help from XML to TEmp table

  Dear all, I have a XML database Ex, Validated DTD is <?xml version="1.0"?> <!ELEMENT note …

  Saravanan_tvr

  2 replies

  15 years ago

  By: Saravanan_tvr