Showing posts with label useful. Show all posts
Showing posts with label useful. Show all posts

Wednesday, March 7, 2012

how to add a multi value select prompt

Thanks Wayne for the useful information but i am experiencing another
problem
I am not able to add a prompt in the reportwhich can allow multiple
values,
as in, if i want to write a query
select * from departments where departmentid in (@.PromptName)
i want to see the data for more than 1 departments, but if i specify a
comma separated list in the prompt, it gives me an error.......
please tell me if there is another way of doing so.Check
http://solidqualitylearning.com/blogs/dejan/archive/2004/10/22/200.aspx.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Gunjan jain" <gunjan@.nagarro.com> wrote in message
news:f8d018ec.0501172039.59a24cd2@.posting.google.com...
> Thanks Wayne for the useful information but i am experiencing another
> problem
> I am not able to add a prompt in the reportwhich can allow multiple
> values,
> as in, if i want to write a query
> select * from departments where departmentid in (@.PromptName)
> i want to see the data for more than 1 departments, but if i specify a
> comma separated list in the prompt, it gives me an error.......
> please tell me if there is another way of doing so.

Sunday, February 19, 2012

How to Accomplish MySQL-style LIMIT

I've graduated from MySQL to MSSQL Server, but the LIMIT command, which was very useful in MySQL isn't in MSSQL. There's the top command, but that doesn't really help me with my DataGrid paging needs. So how do I go about simulating the LIMIT command in MSSQL?

I tried searching the forums, but I couldn't seem to find anything...This link might be helpful|||Cool. Thanks. That was most helpful. I actually searched the forums for "paging," which returned a lot more results, but this was the best. Thanks again!