T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Code with CTE works in SQL 2008, but not in SQL 2005

  Hi there! In short, the code below works in SQL 2008, but generates the following error when execut…

  GordonLiddy

  7 replies

  15 years ago

  By: Jason-299789

• comparing multiple rows from multiple columns

  Hi In the Data Warehouse we have recently installed i am trying to reproduce reports produced usin…

  LoosinMaMind

  2 replies

  15 years ago

  By: LoosinMaMind

• How much is too much for a table variabe?

  At what point should I decide not to use a table variable and go with a temp table instead?

  Khades

  12 replies

  15 years ago

  By: TheSQLGuru

• question about update record

  hi.i have a table that contains id,header,content,image fileds. id is primary key. Other fields are…

  sa.ordekci

  3 replies

  15 years ago

  By: Jeff Moden

• Extra space in string pivot CTE

  Hi All!! I often get given big lists of codes (account codes, call numbers, system numbers) to use …

  Jim Mackenzie

  3 replies

  15 years ago

  By: Jim Mackenzie

• Index requirement for logical operations

  Please help me build the index for the query.The table has more than 3 million rows and whatever in…

  chandan_jha18

  24 replies

  15 years ago

  By: Gail Shaw

• Problem in plsql function

  Hi, This is my function. I am facing the syntax error in this function. can you please help me to s…

  kousalya.krv

  2 replies

  15 years ago

  By: Vedran Kesegic

• Using FOR XML PATH with strange data structure

  Hi, i have a case where this XML is needed (it's a customer invoice printing xml format): <VWP…

  Peter Lagerberg

  8 replies

  15 years ago

  By: Peter Lagerberg

• ERROR with ACE.OLEDB not working after several tries

  Hi all, As JET.OLEDB does not work for 64 bit servers, I have to change to ACE provider in order to…

  vmgarzon

  4 replies

  15 years ago

  By: vmgarzon

• Update a Column that Exists in Any Table

  OK, this is ugly and as a newbie (since Last April) in SQL and this old RBAR programmer is having t…

  scprideandms

  8 replies

  15 years ago

  By: Ken McKelvey

• Stored Proc to send an Email?

  If I need to write a stored proc that can send an email based on input params, where do I start? 🙂

  Khades

  3 replies

  15 years ago

  By: Khades

• Migrate Oracle data to sql server

  I am migrating Korea data from oracle to sql server using linked server . I am able to downoad the …

  Priyanainar

  5 replies

  15 years ago

  By: Colleen M. Morrow

• Ignore an error in a trigger

  An application is inserting a row of data, I am extracting some of the data via an After Insert Tri…

  kwitt 74489

  1 replies

  15 years ago

  By: Lowell

• use go inside a transaction

  This is just for my curiosity. Why I can use GO after the use statement? Got syntax error if you ex…

  clare.xia

  3 replies

  15 years ago

  By: parthi-1705

• Date into VarChar Field

  Hi I am trying to insert a date into a table with a varchar data type so it will show in a format o…

  rcr69er

  2 replies

  15 years ago

  By: rcr69er