"Oleg Yevteyev" wrote:
> You can do something like
>
> --declare @variable int
> --set @variable=3
> set rowcount @variable
>
> SELECT Ticket.problem AS Issue,
> COUNT(Solutions.solution_date) AS [Tickets Touched]
> FROM Ticket INNER JOIN
> Solutions ON Ticket.ticket_number = Solutions.ticket_number
> WHERE GROUP BY Ticket.problem
>
> set rowcount 0
>
> commented lines are for you to test.
> just pass @variable as a report parameter
>
>
>
> "agenda9533" <agenda9533@discussions.microsoft.com> wrote in message
> news:B17A34B3-9689-4570-BCA0-C2BBAF77F47A@microsoft.com...
> >I want to do something like this: SELECT TOP @variable .
> > I've read all related topics BUT I cannot use stored procedure for this
> > report, 'cause I do not have access to prod db, I'm just sending rdl for
> > upload. How to make it work on dataset level or through the report layout?
> >
> > I know SQLServer doesn't recognize "Select Top @variable" statement.
> > SELECT top &variable, Ticket.problem AS Issue,
> > COUNT(Solutions.solution_date) AS [Tickets Touched]
> > FROM Ticket INNER JOIN
> > Solutions ON Ticket.ticket_number = Solutions.ticket_number
> > WHERE GROUP BY Ticket.problem
> >
> > Or
> >
> > SELECT Ticket.problem AS Issue, COUNT(Solutions.solution_date) AS [Tickets
> > Touched]
> > FROM Ticket INNER JOIN
> > Solutions ON Ticket.ticket_number = Solutions.ticket_number
> > WHERE GROUP BY Ticket.problem
> > HAVING (COUNT(Solutions.solution_date) > CAST(@num AS int)) doesn't work
> >
> > Please, help![I]
> >
>
>
