T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• SQL statement to compare two values in the same column

  I have found a couple of examples of this but they do not work quite right . Basically what I want …

  tripower

  1 replies

  15 years, 7 months ago

  By: WayneS

• Update using case statement

  Hi, I have written the following update query that I can't get to work: UPDATE @tblResults SET To…

  DerbyNeal

  3 replies

  15 years, 7 months ago

  By: LutzM

• Where Clause - LIKE and IN

  What is the best way to modify a WHERE clause to include the condition LIKE and IN. Using the exam…

  EjSQLme

  3 replies

  15 years, 7 months ago

  By: John Rowan

• Time Duration for Middle Dates

  Hi, How would I get the duration of time for the middle dates part? For example, if we take Darnel…

  EjSQLme

  5 replies

  15 years, 7 months ago

  By: EjSQLme

• Exporting database with vbscript?

  I need to export a database from a hosted server to our own systems. I have only access to the webs…

  lenne_dk

  2 replies

  15 years, 7 months ago

  By: lenne_dk

• Best way to replace EXECUTE(@Query)

  Hi guys, I have a string of comma separated integers coming from a web form which I need to use as …

  Wobble Chops

  5 replies

  15 years, 7 months ago

  By: lenne_dk

• Understanding JOINS

  Hello All, I’ve read several articles on JOINs and totally understand the theory behind JOIN operat…

  Ronnie Jones

  4 replies

  15 years, 7 months ago

  By: scott.pletcher

• fine tune query

  Hi, I am passing variables from a web form and returning a dataset based on the form input paramete…

  Marcus Farrugia

  7 replies

  15 years, 7 months ago

  By: LutzM

• t-sql nested xml with xml explicit mode

  Hi guys, thanks for your time reading this . at the moment i m just trying to find a way to produce…

  rayan98

  4 replies

  15 years, 7 months ago

  By: maroon-78

• Table variables & Try Catch

  Hi Kindly let me know if we can use try catch block while inserting data in table variables... Rgds…

  Mohan Kumar VS

  4 replies

  15 years, 7 months ago

  By: WayneS

• sample database for sql server 2005

  Plese help me in finding a sample database for sql server 2005 which should run on windows 7. I am …

  hafizshahid_it24

  1 replies

  15 years, 7 months ago

  By: Carl Federl

• Database Help

  Hi guys Please advise me! Scenario is "Client"provide a database(has 48 columns) and db has no PK A…

  rocky_498

  3 replies

  15 years, 7 months ago

  By: adalberto-339588

• Age-old question: Cluster on Date or ID?

  I'm becoming more & more impressed with the community here. I've been reading and learning qu…

  jordantx

  19 replies

  15 years, 7 months ago

  By: Gail Shaw

• sp_send_dbmail ... Help

  Hi Every body.. Can any one suggest me how to attach the result of select statement to the mail, ma…

  Ram:)

  4 replies

  15 years, 7 months ago

  By: LutzM

• Dynamic Sql incorrect Syntax..

  DECLARE @Symbol VARCHAR(10) DECLARE @Period INT DECLARE @Period_sum DECIMAL(12,6) DECLARE @anchor I…

  Digs

  1 replies

  15 years, 7 months ago

  By: Nevyn