T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Convert 3X2 rows,columns to 1X6 row.columns

  Hi Convert 3X2 rows,columns to 1X6 row.columns Phone +1 413 2220144 Fax +1 413 2221144 Ema…

  Muralidaran

  2 replies

  17 years, 8 months ago

  By: ChrisM@Work

• Need Help in CTE

  Dear all, i have a problem with the CTE and i need your help for this i have two table mana…

  Chandru -734144

  7 replies

  17 years, 8 months ago

  By: Chandru -734144

• Am I stupid? Version History

  I can't get started with the SQL required for this. Could someone point me in the correct direction…

  elliottayoung

  4 replies

  17 years, 8 months ago

  By: Tomm Carr

• Stored Procedure Returns 0 Instead of SELECT Result

  Hello, I'm trying to develop a stored procedure that searches for a file using xp_cmdshell. Instead…

  SJTerrill

  12 replies

  17 years, 8 months ago

  By: noeld

• msdb.dbo.sp_send_dbmail

  Hi I am using msdb.dbo.sp_send_dbmail and the property @attach_query_result_as_file=1; It works wel…

  pzmrcd

  1 replies

  17 years, 8 months ago

  By: GSquared

• Update with alias not working

  I have the following update statement : Update consultant.consultant SET SponsorXID = a.XID FROM[c…

  alorenzini

  5 replies

  17 years, 8 months ago

  By: John Rowan

• Updating all stored procedures / functions in a database

  the lead programmer slammed in a set of new database updates by scripting the entire set of stored …

  Seggerman-675349

  5 replies

  17 years, 8 months ago

  By: Seggerman-675349

• How to get the integer value from varchar field?

  I need to retrive the integer part from a varchar filed. A varchar filed contains SATHIK01,SATHIK10…

  sharma-691993

  12 replies

  17 years, 8 months ago

  By: Timothy J Hartford

• SUM function with VARCHAR

  sum(isnull('Premium' + cast(@i as varchar),0)) There are fields in the table - 'Premium1', 'Premium…

  levsha_z

  4 replies

  17 years, 8 months ago

  By: Vijaya Kadiyala

• Import--returning the next importid, sequenceNumber. Also incrementing batchNumber by 1 per import group

  /* I have an Import process. I am working with two tables, tblImportConfig and ImportHistory. In ad…

  dbdeli

  2 replies

  17 years, 8 months ago

  By: dbdeli

• Apostrophe Handling in Dynamic sql

  I am in a need to create a dynamic sql . But in this script column values contains apostrophes ( ' …

  REJI P R

  2 replies

  17 years, 8 months ago

  By: Christopher Stobbs

• trigger to delete FK and PK

  HI... I have a simple example: table 1 id int -> primary key table2 id int -> foreign key of …

  m12k_102

  4 replies

  17 years, 8 months ago

  By: Johan Bijnens

• output XML with combiantion of attribute & element

  I have one table declare @temp table (col1 varchar(300), col2 varchar(300)) INSERT INTO @temp VALue…

  gan-685682

  2 replies

  17 years, 8 months ago

  By: gan-685682

• UPDATE .... SET .Write

  Hi all, I just come across the .Write clause. Was wondering about some execution plan differences w…

  Christopher Stobbs

  4 replies

  17 years, 8 months ago

  By: Christopher Stobbs

• Generate XML output

  Hi I need to create xml files (to disc) by querying a SQL Server 2005 table. What is the best way t…

  Helmut Nielsen

  5 replies

  17 years, 8 months ago

  By: Ric Sierra