T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• preformance issue..with this

  We have this script..it takes over an hour to run if I uncomment the code in the select. Runs great…

  krypto69

  5 replies

  13 years, 2 months ago

  By: Grant Fritchey

• Constraint to prevent UPDATE after row is committed

  Hi, I'm wanting to prevent updates to a certain table after the row has been committed to the datab…

  David Wiseman

  17 replies

  13 years, 3 months ago

  By: David Wiseman

• Compare two tables: Which fields are different?

  I do not want to reinvent the wheel, but I need to write a procedure that can be passed two table n…

  mikeg13

  26 replies

  13 years, 3 months ago

  By: mikeg13

• Sum a column for a set of Trees on a Recursive Table

  Hi... I have a table (fctTable), which references another table (refTable) that has a parent/child …

  joshua.wallace

  4 replies

  13 years, 3 months ago

  By: joshua.wallace

• Query assistance request

  I have a table (JeffTest) that has two fields (Encounter, DocType). How can I get the Encounter tha…

  rothj

  12 replies

  13 years, 3 months ago

  By: brad.mason5

• Help on sorting results using sql

  Hi, I need your help on the following query that I want to build. I have a table with the following…

  panayotis 20784

  10 replies

  13 years, 3 months ago

  By: Eugene Elutin

• Converting varchar to datetime

  I have a varchar column with data as 10/28/2011 11:47:55.686455 AM whats the best way to convert it…

  ishaan99

  16 replies

  13 years, 3 months ago

  By: drew.allen

• Logical cascade constraint

  Hi, I have around 53 tables in my schema. Due to some business constraint , we have not implement o…

  thbaig

  3 replies

  13 years, 3 months ago

  By: Eugene Elutin

• need help w/ my sort coulmn

  I'll kind of explain the details next however i figured i'd put up the issue and desired output fir…

  Snargables

  8 replies

  13 years, 3 months ago

  By: Snargables

• How to convert some columns into rows with the first two columns still retained as columns

  Hi, Can PIVOT do the above function? I have the following table: SELECT [Column1] ,[C…

  rmelgarca

  9 replies

  13 years, 3 months ago

  By: rmelgarca

• Declaring table variables-Is this working as designed or is this a quirk or is this a a bug?

  I am surprised that the first set of statements work but the second set do not. Is this working as …

  Chrissy321

  1 replies

  13 years, 3 months ago

  By: Lynn Pettis

• Why I am getting this cursor error? I don't think there should be an error.

  Here is my sp, the error comes out at the first FETCH NEXT FROM c INTO Error: [highlight=#ffff11]C…

  halifaxdal

  15 replies

  13 years, 3 months ago

  By: Lynn Pettis

• using ' within a Unicode sting

  Sure this is a simple, and probably stupid question but I need help with the following; I run the f…

  AHWB

  3 replies

  13 years, 3 months ago

  By: Andy Hyslop

• CTE problem

  Ldate is varchar type, it contains values '11/02/01' and 'ZZZZZZ' I need record only if value is d…

  Dima-99208

  3 replies

  13 years, 3 months ago

  By: Vedran Kesegic

• Same exposed names - Worked in 2000 not 2005

  I knew before we upgraded there were changes to queries in the Order Clause. I fixed most (got me …

  Ken at work

  2 replies

  13 years, 3 months ago

  By: Ken at work