I found another solution which works exactly as i wanted. following is the query(try it on adventure works sample DB). Now the problem with this query is that it gives...

Thanks for all the responses.

Creating Stored Procedures for each query and use sys.dm_sql_referencing_entities is a good idea. but the problem is some queries will have variables used with out...

@Gail Shaw - Makes Sense. thanks i created a function to split the string and that worked. Thanks for your help.

@Lynn -Thanks for your help.

SSCommitted - Perfect! works like a charm! Thank you so much. your help is much appreciated.

SSCrazy - Thanks for your help too.

Great work. keep going guys.

Many Thanks,

Alvin

Sorry i guess the statement 'Archive DB is a copy of the Main DB' is not correct.

Data in the Source Database and Archive Database is different. so we want to...

Awesome. That worked like a charm. Thank you so much for your help!

Hi pietlinden,

Thanks for your swift response. basically i have around 7 to 8 very complex reports that i need to merge. in my explanation i just tried to pick some...

Koen,

Thanks for your interest.

I tried the sub report with Agent Parameter approach and it worked for one Agent at a time. But when i pass multiple Agents then sub report...

Worked like a charm!

Thank you so much.

Awesome! both solutions work good. thank you very much guys.

Alvin

Let’s say my report(SSRS 2005) have 5 columns. And I want to show/ hide columns based on a parameter(multi select with all 5 column names) selected by user. do as...

Hi,

if I was to do something like this, then i would

1)do as pitso.maceke said. limit it to 30 days or

2)set the default value for the end date parameter to...

Nop. it wont let me preview the report so i can not export it .

Hi All,

I finally managed to write the code .Thank you so much for all your support.Really appreciate it.

I found a similar approach as LutzM suggested. see following

--Start--

CREATE FUNCTION dbo.fn_nums(@n AS...

Hey Lutz,

sorry my bad! i guess i have to look at the DelimitedSplit8K link first and then run the above query?

by the way when i run the query i got...