T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• datetime difference and display in years

  i want to get date difference like a start date and end date and find difference in years but i wan…

  scottichrosaviakosmos

  8 replies

  15 years, 5 months ago

  By: Jeff Moden

• Need to Swap the word in SQL

  Hi all, I have a column with the name of Author more than 1 lakh, examples value Friel, Joe …

  Saravanan_tvr

  6 replies

  15 years, 5 months ago

  By: Cadavre

• Current QTD, Previous QTD

  Hi Experts, I have a detailed date dim table trying to figure out a way to create a column that ind…

  jay83091

  1 replies

  15 years, 5 months ago

  By: Eugene Elutin

• Delete too long

  I am running hte following query to delete since 7 days its not yet finished, any thoughts ? and th…

  Tara-1044200

  15 replies

  15 years, 5 months ago

  By: Paul White

• Finding the sum of date difference of a tricky situation using sql

  Hi, I have the following sample table: cust_num inv_num type inv_date due_date diiferenc…

  gamaz

  3 replies

  15 years, 5 months ago

  By: LutzM

• Impossible query performance only when criteria includes "today" date/times

  I have a Photo database for a newspaper company. The main Photo table has about 700K rows. One of t…

  Joel Paula-461376

  4 replies

  15 years, 5 months ago

  By: Gail Shaw

• Importing XML into a table

  I have not done any XML importing before and I know the data that I am starting with is not in an a…

  rightfield

  2 replies

  15 years, 5 months ago

  By: rightfield

• SQL Join Help

  Hello, I am relatively new to writing sql queries and this particular one has me stumped. Any help …

  zcradic

  6 replies

  15 years, 5 months ago

  By: zcradic

• Finding total in a complex sql statement

  Hi, I have the following table as temporary table output. site customer ytd_sales 11099C000120…

  gamaz

  4 replies

  15 years, 5 months ago

  By: gamaz

• Reading xml child node data

  declare @x xml set @x = '<ROOT> <Createstudent> <id>30</id> <classI…

  sql_novice_2007

  3 replies

  15 years, 5 months ago

  By: sql_novice_2007

• Replace single or multiple hyphen(-) with a space.

  I have a column with multiple hyphens(-).I want to replace the multiple or single hyphens with a sp…

  Ashwin M N

  9 replies

  15 years, 6 months ago

  By: Eugene Elutin

• Code to convert varchar datatype that contains a numeric expression to a date

  Hi All I need some help please the DB holds the date like this 131402524 in another Col the time li…

  Northern Monkey

  22 replies

  15 years, 6 months ago

  By: Northern Monkey

• Extremely puzzling >_<

  I'm totally stumped on this problem. I have a stored procedure. Running the contents of the stored …

  n00b

  2 replies

  15 years, 6 months ago

  By: Gail Shaw

• First Tally Table T-SQL

  Hello, I am attempting to use my first Tally Table and I'm not sure I am using the correct approach…

  nfs_john

  20 replies

  15 years, 6 months ago

  By: Paul White

• Variable Table Names in SP ?

  I inherited a manual procedure from someone who left the company. Twice a month he runs all these m…

  homebrew01

  9 replies

  15 years, 6 months ago

  By: ColdCoffee