troubleshooting Question

problems with adding a line into a select statement in sql2000

Avatar of Chris Michalczuk
Chris MichalczukFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL Server 2005
3 Comments1 Solution206 ViewsLast Modified:
I want to add a link to a view but I get an error with the output. where do I have to put the commas etc for the section after the AS OrdersComment  bit that starts with http:/ in the select statement below?




SELECT     ee.NewOrders_ID, ee.NewOrders_QuoteID, dbo.tbl_Orders.Orders_SON, dd.*, ee.NewOrders_Value AS OrderValue, dd.Users_Username AS Rep,
                      triscan_calls.dbo.UTC2Date(dbo.tbl_Orders.Orders_CreatedOn) AS Created, dbo.tbl_Orders.Orders_Comment AS OrdersComment,
                      'http://sales.systems.com/php/Global/StandardDocs/xml.php?ViewDocument=true&ViewDocumentProposal=1&ViewDocumentQuoteID' + ee.NewOrders_QuoteID
                       AS Links
FROM         dbo.tbl_Orders INNER JOIN
                      triscan_global.dbo.SiteView dd ON dd.Sites_ID = dbo.tbl_Orders.Orders_SiteID LEFT OUTER JOIN
                      vbi_quotes.dbo.tbl_NewOrders ee ON ee.NewOrders_SON = dbo.tbl_Orders.Orders_SON
WHERE     (dbo.tbl_Orders.Orders_StatusID = 21)
ASKER CERTIFIED SOLUTION
ralmada

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros