T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Get Record parent table based on child table. Plz help

  CREATE TABLE [dbo].[Managements]( [ManagementId] [int] NOT NULL, [FTAManagementNo] [varchar](35) …

  shkoli

  1 replies

  9 years, 7 months ago

  By: Phil Parkin

• Can't CAST as INT and back again

  We have a table that stores a time in a char(5) format, as in '10:15' I want to advance the time …

  dan-572483

  13 replies

  9 years, 7 months ago

  By: dan-572483

• Which is more efficient? WHERE SUBSTRING = ...or... WHERE fldField LIKE 'x%'

  Hi all, I'm a SQL newbie who sort of inherited a 2005 db. I've got a query that returns a SUBSTRING…

  Renée

  26 replies

  9 years, 8 months ago

  By: ChrisM@Work

• multiple attachments

  I got this script from my DBA and it works fine for single attachments. I need help in modifying i…

  is250sp

  2 replies

  9 years, 8 months ago

  By: Ant-Green

• ADD CARRIAGE RETURN IN A VARCHAR

  I HAVE A CHARACTER LIKE THIS FOR EG ('THIS IS A TEXT MESSATE SORRY IT IS A MESSAGE'). I HAVE TO IN…

  Kingsleen Solomon Doss

  7 replies

  9 years, 8 months ago

  By: Michael L John

• How to calculate Time difference between 2 ranges and tally up each hour????

  Hi, I'm new to SQL and am facing a query which I don't know how to write SQL for... I need to displ…

  rkelly58

  49 replies

  9 years, 8 months ago

  By: J Livingston SQL

• Returning multiple fields in a subquery based on each row of the master query.

  Hello, I'm trying to get multiple columns from a subquery based on a query. The problem is that the…

  rmcomics

  5 replies

  9 years, 8 months ago

  By: swti6690

• Creating Temp Table with records by running Stored Procedure

  Is there a way to create Temp Table Dynamically by running Stored Procedure . I can create a do thi…

  skb 44459

  1 replies

  9 years, 8 months ago

  By: Gail Shaw

• Passing filename as variable in OPENROWSET(BULK filename)

  Hi everyone, I am writing a stored procedure that updates a field in a SQL table with a value obtai…

  christine.lawrie

  5 replies

  9 years, 9 months ago

  By: colinvennebekken

• VARCHAR(x) VS VARCHAR(MAX)

  As far as I know, VARCHAR(MAX) is essentially the replacement for the old TEXT data type. My questi…

  kramaswamy

  10 replies

  9 years, 9 months ago

  By: Matt Bond

• How to Delete Multiple ID

  Hi Experts, How can i accomplish to delete a selected ID's using T-SQL. I have use this query DELET…

  jaquino012

  2 replies

  9 years, 9 months ago

  By: jaquino012

• how to create/send HTML email in SQL and confirm READ without asking?

  Hello folks, I know there are lots of useful script/approaches on how to send out HTML email from S…

  halifaxdal

  6 replies

  9 years, 9 months ago

  By: Jeff Moden

• Seeking guidance regarding a tSQL Script

  Its trivial compared to what most on here speak of, I know, but here it goes.. I have a SELECT sta…

  tjs8984

  18 replies

  9 years, 10 months ago

  By: tjs8984

• Old brain, new question

  Rather than posting all of my failed queries, I'll just show what I'm trying to do. auctions fields…

  vance.king

  7 replies

  9 years, 10 months ago

  By: Jeff Moden

• Finding the first credit balance date

  I have a transaction table with account number, sequence, date, amount, and running balance. The r…

  ArcticEd32

  9 replies

  9 years, 10 months ago

  By: Luis Cazares