How would such a parameter string look like?

Could you attach a fake sample?

I'm just wondering what kind of query would require more than 8k for parameter...

Ninja's_RGR'us (5/4/2011)

---

kim.etcheson (5/4/2011)

---

We bought a vendor package where the vendor hardcoded the db logon and password in the application that we couldn't change on the database or the app wouldn't...

You could either use PIVOT or the CrossTab approach.

For the former, please have a look at BOL, the concept of the latter is referenced in my signature block.

As a side...

Instead of using GOTO I'd recommend you either include those code sections directly into the related IF block. If there's too much code, use separate sprocs and call those.

Do you have a chance to either create a view or a sproc at the db referenced in OPENQUERY that would hold the content of @sqlquery? Then you could just...

You could either add a foreign key constraint with no cascading actions or change the user permission to deny update of that specific column. The former would be the solution...

[SET SARCASM ON]

The products mentioned above must have great community web sites. What else would be the reason to ask for recommendations like the above in a SQL Server forum?

[SET...

I don't think your latest reply will return the same result since you'd only number the rows with filed1=0 instead of all related rows.

Regarding PARTITION BY: it owuldn't make a...

Does the sproc return any error when run from SSMS (Management Studio)?

If so, what tool do you use to "run (and design) the report in intranet"? Assuming it is SSRS...

I'd like to ask for table def and sample data to verifiy if the query is exactly what you're looking for.

But there's definitely one thing I'd change: replace the name...

raistlinx (5/4/2011)

---

...

Yes that is what I understood the problem to be from the analyst who gave it to me. I knew it had to be a common problem. Is there...

Looks like a "classic" triangular join to me.

It might be a better way to use ROW_NUMBER() instead of the COUNT(*) in a subquery approach.

Would it be possible to post table...

I'm guessing toward the same direction as Stefan:

Assuming V_KASSTRNS and V_PERSONAL are views, both could have the hardcoded APP06 linked server referenced in the underlying query.

I'd check the definition of...

You might also want to have a look at Gails blog regarding the caveats of catch-all-queries[/url]

I'm from around here, too. How come we never met? :-D:-P

Regarding the subject (but not...