T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• CONVERT date with century

  I am using the CONVERT function to format a date with the century. My code is like this: CONVERT(V…

  bryan.duchesne

  2 replies

  15 years, 5 months ago

  By: bryan.duchesne

• Improve query performance with comma separated result of each member.

  Hi, I have a problem with query which is returning more than 45000 records. I have applied covering…

  Sagar Sawant

  11 replies

  15 years, 5 months ago

  By: Ben Teraberry

• Find Avg based on Date

  Hi, I would like to take the average of size if the month and year measure date are the same for th…

  EjSQLme

  9 replies

  15 years, 5 months ago

  By: EjSQLme

• searching from comma separated string

  I have a table where Job Seeker's Preferred Job Locations are getting saved as: JobSeekerID …

  gaurav-404321

  2 replies

  15 years, 5 months ago

  By: Mike01

• Returning data from Multiple tables.

  hi, I have 3 tabled mt_wpr, and mt_tags, and mt_tags_rel. I need to retrieve data from mt_wpr and f…

  John Peter Fernandes

  1 replies

  15 years, 5 months ago

  By: Eugene Elutin

• Create a table called #test, and create a table called test in the tempdb, what’s the difference?

  Hi guys, In SQL Server 2005(2008 not tested), you can't create a temp function like #function_name,…

  ogrishman

  17 replies

  15 years, 5 months ago

  By: Paul White

• Cursors to compare to values

  Hello, I am trying to compare values found in rows of my table and conditionally label each row. I …

  TIM.OGRADY

  13 replies

  15 years, 5 months ago

  By: Paul White

• Between Statment only for current day

  SELECT min(upvolume),min(downvolume),MAX(upvolume),max(downvolume) FROM DBVaskVbid WITH (NOLOCK) WH…

  jon pill

  46 replies

  15 years, 5 months ago

  By: Jeff Moden

• joins to the same table

  Hi, I have a transaction table where I have 'receivedby' and 'orderedby' columns. Both the columns…

  Anamika

  3 replies

  15 years, 5 months ago

  By: Kingston Dhasian

• distinct again

  for example: column1 col2 col3 col4 1 a b c 1 a c b 2 a c b 2 c b a 1 c a a 3 a c b now when i fetc…

  scottichrosaviakosmos

  2 replies

  15 years, 5 months ago

  By: thecoding

• All Joins at once, or only when View is queried?

  I have a view which brings together a bunch of data such as employee ID, Date, Result, ContaminantI…

  loki1049

  1 replies

  15 years, 5 months ago

  By: Jeff Moden

• COPY SQL QUERY

  Hi, We have a database to store all the data which is updated or deleted in other databases(around …

  Ram:)

  12 replies

  15 years, 5 months ago

  By: David Webb-CDS

• Need list of orders with a specific value associated with most recent update in xref table

  I have a table of orders, a table of orderLocationHistory and a table of orderLocations. The orderL…

  ian-822162

  12 replies

  15 years, 5 months ago

  By: ian-822162

• calling xp_fixeddrives on a remote server

  Hi, My goal is to have a stored procedure go through all servers and store the results of xp_fixedd…

  SQLdba-473999

  9 replies

  15 years, 5 months ago

  By: Matt Slocum

• WTF?? concatenating Date and time varchar fields messes up the milliseconds!!

  select '2009-09-15', '10:54:08:531', '2009-09-15' + ' ' + LEFT('10:54:08:531',12), CAST…

  mberry 51447

  16 replies

  15 years, 5 months ago

  By: mberry 51447