T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Cursor and update

  Before Script Runs Seller_No|Product_No|Product_Status 99999 |100000 |Availalble …

  phineas629

  10 replies

  11 years, 10 months ago

  By: ChrisM@Work

• Stuck on Substring/Left/Charindex Problem with Description

  This works for some items and not others. I can't explain it. What I need is value of 20, 15, or 10…

  SQL_Enthusiast

  1 replies

  11 years, 10 months ago

  By: SQL_Enthusiast

• Strange behaviour of some jobs ...

  I have no idea where to even start with this one. I have a schedule which has about 40 jobs running…

  kramaswamy

  6 replies

  11 years, 10 months ago

  By: SQLRNNR

• Nan,#Error,Infinity Values displaying in ssrs reports

  When I use calculation in generating reports, I get Nan,#Error,Infinity values in preview , I want…

  battula.ramu6

  2 replies

  11 years, 10 months ago

  By: doug.brown

• Get Unique Transaction ID For The Current Transaction

  Hi all 🙂 When multiple tables are updated in a single transaction, is there any way to tie those ch…

  hjo-483301

  22 replies

  11 years, 10 months ago

  By: skudumala

• List DB users

  I was looking for a method of querying my SQL Server 2000/2005/2008 databases to gather a list of D…

  Jpotucek

  5 replies

  11 years, 10 months ago

  By: leon.booij

• Index with a column varchar(50)

  Is recommended that créate an index with a column that is varchar?

  sistemas_casinomnes

  3 replies

  11 years, 10 months ago

  By: Eugene Elutin

• Calculate Past Due Principal and Past Due Interest Based on Due Dates

  Hi with respect to my subject, need to calculate -Calculate Due Amount Principle + Interest after D…

  shiva.reddy06

  7 replies

  11 years, 10 months ago

  By: Sean Lange

• Trace Script for XP_CMDSHELL

  Is there a way to use a trace and capture only when XP_CMDSHELL is used, and what used it?

  dwilliscp

  4 replies

  11 years, 10 months ago

  By: datwungai

• How to write a Query to get related result

  I need help to write a query like below oupt put. create table #table (id int, cid int , startdate …

  suresh0534

  1 replies

  11 years, 10 months ago

  By: SQLRNNR

• Data containing '

  Is there any way to delete data that contains ' ? example - desc field is "Bene's" Trying to delete…

  damcguire

  9 replies

  11 years, 10 months ago

  By: Sean Lange

• Query advice on removing duplicate fields

  hi all i have a query - which i may be best going back to the start on, but ill ask first if someon…

  dopydb

  10 replies

  11 years, 10 months ago

  By: dopydb

• Query Question Using Distinct concept in table joins

  Hi - I have 4 tables that I need to join and return distinct results. TableA is my main table and …

  Bron Tamulis

  3 replies

  11 years, 10 months ago

  By: Bron Tamulis

• How to pivot but to keep one column unchanged

  i have a table with 3 columns like below ID, Name and Value. It has like 1000 records ID Name Value…

  MadRazzi

  3 replies

  11 years, 10 months ago

  By: Luis Cazares

• CTE results storage same as temp table?

  Simple question, are the results of a CTE stored in the same place as a temp table (tempdb)? Thanks

  smallmoney

  2 replies

  11 years, 10 months ago

  By: Gail Shaw