Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2011-06-07 : 00:22:14
|
| Hi,.In the below query what is wrong with the unclosed quotation declare @sqlstr as nvarchar(1000) declare @dbname varchar(30) set @dbname = @empowerdbname set @sqlstr = 'SELECT e.ID, e.date_modified, e.modified_by, e.product_ID, e.logger_ID, e.enquiry_category_ID, e.consumer_ID, e.HCP_ID, emp.NameGiven '+" " +' emp.NameFamily AS logger, CASE WHEN e.consumer_ID IS NULL THEN HCP.NameGiven '+" "+' HCP.NameFamily ELSE c.name_given '+" "+'c.name_family END AS reporter, CASE WHEN e.consumer_ID IS NULL THEN HCP.NameFamily ' +"," +' HCP.NameGiven ELSE c.name_family ' + "," +' c.name_given END AS reporter_reverse, e.summary, e.entry_channel_ID, es.[name] AS enquiry_status_name, e.enquiry_status_ID, p.generic_name, p.brand_name, ec.[name] AS entry_channel_name, ei.[name] AS category_name FROM enquiries e LEFT JOIN users u ON u.ID = e.logger_ID LEFT JOIN enquiry_status es ON es.ID = e.enquiry_status_ID LEFT JOIN ' + @dbname + '.dbo.employee emp ON emp.ID = e.logger_ID LEFT JOIN ' + @dbname + '.dbo.HCP HCP ON HCP.ID = e.HCP_ID LEFT JOIN consumers c ON c.ID = e.consumer_ID LEFT JOIN products p ON p.ID = e.product_ID LEFT JOIN enquiry_channels ec ON ec.ID = e.entry_channel_ID LEFT JOIN enquiry_categories ei ON ei.ID = e.enquiry_category_ID WHERE e.ID = @enquiry_ID ' exec sp_executesql @sqlstrThanks,Gangadhara MSSQL Developer and DBA |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-06-07 : 02:33:59
|
replace the double quotes " by single quotes '
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
|
|
Unclosed quotation