T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Replace Function in SQL 2005 and 2008

  try this in sql server 2005 SELECT REPLACE(CONVERT(CHAR(10),GETDATE(),112),'/','')+'.' returns 2010…

  dant12

  4 replies

  15 years, 10 months ago

  By: dant12

• Help in converting Query

  Hi Guys, I built a query using temp table and recursion to get a report of file details of various …

  SQLbee

  2 replies

  15 years, 10 months ago

  By: SQLbee

• reg sql query

  Hi, we have two tables employee and employee1 where it has data like Employee: id name sal 1 A …

  Ashok Nalam

  3 replies

  15 years, 10 months ago

  By: Panks-913490

• How to send query results to another server/database

  Apologies if this is very simple, but I can't seem to find anything on the internet to help me with…

  craighenderson

  2 replies

  15 years, 10 months ago

  By: craighenderson

• Week Calculation returning unexpected results.

  Hi , I am thankfull to all forum members who helped me in all ways and made me learn many new trick…

  descentflower

  14 replies

  15 years, 10 months ago

  By: Fazalul Haque

• number rows by group

  I haver a query that i need to add row numbers by group. Can someone please help? This is the sql i…

  collie

  2 replies

  15 years, 10 months ago

  By: Steve Jones - SSC Editor

• what is the equivalent of sql getdate() in AS/400

  I have a datetime column in AS/400 file, I want to update that column which is in AS/400 with the c…

  Mh-397891

  1 replies

  15 years, 10 months ago

  By: Steve Jones - SSC Editor

• Extract X and Y coordinates out of a string and check if within range

  Hi can someone please help with the following problem... I have a table - MapItems Structure... Map…

  Charlottecb

  19 replies

  15 years, 10 months ago

  By: Jeff Moden

• How to assign Random Row -- Need help to built SQL

  /*My tables and rows as follow*/declare @tAllBus table ( BusTypeCode varchar(30) not null, BusN va…

  miss.delinda

  2 replies

  15 years, 10 months ago

  By: miss.delinda

• Truncate incorrect DB table - need to rollback sql2000 DB on sql management studio 2005

  Good day, i urgently need help as i messed up. I have to DB with all tables exactly the same one be…

  Ismail Cassiem

  1 replies

  15 years, 10 months ago

  By: Gail Shaw

• Batch update,Insert Trigger

  I have two tables Temp1 and Temp2. Data is inserted into Temp1 table continuously from the applicat…

  Ashwin M N

  11 replies

  15 years, 10 months ago

  By: Ramesh Saive

• Dynamic Order by - is there any way to sort Dates correctly

  I am using a dynamic order by in a SSRS Report (note this is not a working query for example only) …

  bboufford

  13 replies

  15 years, 10 months ago

  By: LutzM

• truncate partition?

  Hi, is there a counterpart for the following statement in oracle? alter table tab1 truncate partit…

  Tobias Kiemes

  4 replies

  15 years, 10 months ago

  By: vidya_pande

• Generating HTML TABLE from a select query

  Hi, I have a simple select output that i need to send to a user through email from sql server 2005.…

  descentflower

  7 replies

  15 years, 10 months ago

  By: Ramesh Saive

• TSQL Help - Calculate Months

  Hi All, I hope you can help. I have a query that produces the total price for a certain date range.…

  SLLRDK

  6 replies

  15 years, 10 months ago

  By: Jeff Moden