T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Convert() problem

  I'm getting an error on a subquery... Msg 245, Level 16, State 1, Line 1 Conversion failed when con…

  J M-314995

  3 replies

  16 years ago

  By: J M-314995

• Retrieving a parameter using sysmail_help_configure_sp

  I am writing a stored procedure that uses Database Mail to send e-mail sometimes with attachments, …

  Julie Hargraves

  1 replies

  16 years ago

  By: Mike01

• Can I use PIVOT for this Problem?

  Hi, I can't figure out if I can use PIVOT for this or some other solution. I have: create table s…

  sean_denney

  5 replies

  16 years ago

  By: LutzM

• Query Performance

  Hello All.. Let me know if anyone feels this should be expected. The performance doesn't feel right…

  BAGs

  20 replies

  16 years ago

  By: BAGs

• Query executing

  Hi, I wrote the following query which returns a result of 13388 in 2 or 3 seconds. SELECT COUNT(*)…

  comanche

  7 replies

  16 years ago

  By: comanche

• CONCATENATE fields in JOIN

  I need to concatenate 2 fields in table A in order to join to field in table b. Table A: Year int (…

  2Tall

  4 replies

  16 years ago

  By: 2Tall

• Need to know from which application the data has been inserted to a particular table

  Hi, Is there any way to find out from which frontEnd application the data is inserted into a partic…

  Santhoshkumar KB

  1 replies

  16 years ago

  By: spaghettidba

• Color data type for SQL

  Is storing color really that hard? We will be storing true RGB and shades. I am thinking hexidecim…

  JKSQL

  4 replies

  16 years ago

  By: JKSQL

• Convert GETDATE() to NUMBER

  In a SSIS package i have a column with value GETDATE(). In target table column is defined as number…

  rahulsony111

  7 replies

  16 years ago

  By: Jeff Moden

• Looking at someone elses code

  Never seen this type of from statement before. Does anyone use it and know if it's exactly like an …

  smallmoney

  16 replies

  16 years ago

  By: Jeffrey Williams

• XML to relational

  XML (stored in a table column): <catalog> <book id="bk101"> <author>Gamb…

  Positive

  3 replies

  16 years ago

  By: LutzM

• cursors and order by

  I'm having an issue with a cursor and ORDER BY clause. I have the following cursor that inserts da…

  Magy

  24 replies

  16 years ago

  By: sqlrunner

• Invalid column name error

  Hi I have this Select query - SELECT a.IPEquipmentID IPEquipmentDataRowID, a.IPEquipmentName, a.IP…

  namrata.dhanawade-1143388

  7 replies

  16 years ago

  By: ChrisM@Work

• transaction log

  The transaction log on hosting took an excessive size. Once he was truncated when assistance BACKUP…

  ENadtoka

  6 replies

  16 years ago

  By: ENadtoka

• msforeachtable

  How to avoid some tables while using msforeachtable?

  rpatil22

  2 replies

  16 years ago

  By: Jack Corbett