Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
select orderheader.orderno, companyname, jobheader.jobdesc, section.title, orderheader.coverpagination, orderheader.textpagination, section.depth, section.width, sourcingbrands.branddesc, section.papertype, orderheader.completedate, CASE WHEN iscover = 1 THEN papergsm else '0' END AS [cover weight], CASE WHEN iscover = 0 THEN papergsm else '0' END AS [text weight] from section inner join orderheader on section.orderno = orderheader.orderno inner join customers.dbo.company on orderheader.customer = customers.dbo.company.coid inner join jobheader on orderheader.orderno = jobheader.orderno inner join binding on jobheader.orderno = binding.orderno inner join sourcingrequest on jobheader.jobno = sourcingrequest.jobno left outer join sourcingrequestxref on sourcingrequest.sourcingid = sourcingrequestxref.sourcingid left outer join sourcingpapermaster on sourcingrequestxref.paperid = sourcingpapermaster.paperid left outer join sourcingbrands on sourcingpapermaster.pbid = sourcingbrands.brandid where section.recordtype = 'ppe' and binding.recordtype = 'ppe' and orderheader.completedate > '2008-01-01' and binding.description not like '%guillotine%' and binding.description not like '%folder%' and binding.description not like '%sitma%'and binding.description not like '%pre stitch%' and jobheader.jobno = '7005' order by orderheader.completedate
|Returning data in a different format||8||46|
|Extract string portion||2||14|
|Diagnosing if a MSSQL statement is doing something in MSSQL 2008R2||8||15|
|T-SQL: Carrying a Figure from One Row to the Next||14||31|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!