T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• UNION ALL/TOP x Issue

  I have a few SELECTS joined by UNION ALL... pseudo code: SELECT somedata FROM Table1 UNION ALL SELE…

  rruest

  9 replies

  17 years ago

  By: rruest

• queries usingLinked Server

  Hi there, I am doing some testing & for the same,I am running queries using linked server. Wh…

  MuditGupta

  2 replies

  17 years ago

  By: MuditGupta

• T-SQL Book

  Hello, Can anyone recommand me some good T-SQL book? Thanks a lot, Hary

  hbpank

  12 replies

  17 years ago

  By: Ulysses_Infinity

• How to link view and table together

  Hi all, I have a small technical question which I really need all of your expertises and that quest…

  josephptran2002

  8 replies

  17 years ago

  By: Vladan

• Two different columns to one single column (JOIN)

  Hi fellow DB folks, I've got a query that is puzzling me on how to make it work. I have two tables …

  Fábio-917326

  6 replies

  17 years ago

  By: Fábio-917326

• updatingData in MS ACCess from SQL Server 2005

  Hi, I would like to update few data which is in SQL Server to MS Access. TableA in SQL Server 2005 …

  dakshinamurthy-655138

  1 replies

  17 years ago

  By: David Benoit

• Updating values in a table based of table in another db

  I have a situation where I have two copies of a database. One db with correct values in a column n…

  AdamHall

  8 replies

  17 years ago

  By: Dugi

• Help needed with variables and cast statement

  Let's say I have a software version 16.04.01 I set variables to get 1604 out of that value (see bel…

  iluvmyelement

  9 replies

  17 years ago

  By: andrewd.smith

• Datetime Checks

  I have a table with a column as dateentered with datatype varchar(10). I want to check this column …

  ishaan99

  5 replies

  17 years ago

  By: Jeff Moden

• Update column3?

  write a query to update column3 from table such that column3 contains whatever be the greater value…

  vishudata

  5 replies

  17 years ago

  By: Jeff Moden

• sql code to divide header value based on number of detail records

  I need to join the order header and order detail tables; and create a new column calc based on head…

  Richard Cranston

  6 replies

  17 years ago

  By: Garadin

• four part function name

  if i create a function: CREATE FUNCTION dbo.MyFunction () RETURNS INT AS BEGIN RETURN 1 END SELECT…

  JuncTheMayl

  11 replies

  17 years ago

  By: Jeffrey Williams

• Exporting to Text File

  I need to export data to a text file within a Stored Procedure. The file name and location is alway…

  JuanBob

  2 replies

  17 years ago

  By: Luke L

• How to change output format

  Hi Folks, I have a table which has the following data. DateLunValue 1/6/2009 22:42Lun17 1/6/…

  rw_ebox

  3 replies

  17 years ago

  By: rw_ebox

• WHILE loop issue

  I have a SP that creates a temporary table whose rows (1000+) are looped through with a WHILE state…

  sean.rodwell-simon

  8 replies

  17 years ago

  By: sean.rodwell-simon