ST Alpha - "LIR: Jax. I think you can kinda "trick" it into generating a subquery like this using CONCATENATE" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 167

LIR: Jax. I think you can kinda "trick" it into generating a subquery like this using CONCATENATE

Posted by kilboooo (aka kkuphal) Oct 28 '08, 07:49

SELECT helpdesk_escalatedcount.[Taken By], helpdesk_notescalatedcount.LevelOneCalls, helpdesk_escalatedcount.LevelTwoCalls, [LevelTwoCalls]/[LevelOneCalls] AS PercentEscalated,

CONCATENATE("SELECT TOP 1 COUNT(application) FROM othertable WHERE name = " & helpdesk_escalatedcount.[Taken By] & " ORDER BY COUNT(application) DESC") as appcount

FROM helpdesk_escalatedcount
INNER JOIN
helpdesk_notescalatedcount ON helpdesk_escalatedcount.[Taken By] = helpdesk_notescalatedcount.[Taken By];

Responses:

Another option that might make more sense is to use a JOIN to a subquery. I'm not sure the syntax is exact but it's more "standard" than the concat - kilboooo Oct 28, 08:00 2
- Yeah, I'm playing with this. It didn't like Concatenate, but I'm thiking you're on to something here. Thanks! -- nm - JaxSean Oct 28, 08:04 1
  - Let me know how it works. It'll bug me unless I know it's right :) -- nm - kilboooo Oct 28, 08:14

Post a message top

LIR: Jax. I think you can kinda "trick" it into generating a subquery like this using CONCATENATE

Replies are disabled on threads older than 7 days.