Don't thank me yet, I think I'm stumped on this one as well.

If you haven't already, try the following:

Backup a copy of your rdl file before you do either...

write that query for 10 fields instead of two, then you'll understand my pain 😀

seriously, I've already done it (i ended up writing code to create the code). But I...

can you provide both datasets (the one using the parameter, and the one used to populate the parameter's drop down list)

If you mean it's MD5 encrypted, you can't unencrypt it. However I don't think yours is MD5 encrypted as it would required varbinary of at least 32 bytes. Also, there's...

Usually, that happens when your data set depends on another parameter, but is further down in the list. Move the problematic parameter all the way down to the bottom and...

I am seeing if it is possible to assign a variable, and utilize the same variable that I assigned all in one query. Here's some examples:

declare @int_num int

select @int_num =...

It can be done if it's only variables (I've included an example below). However I'm looking for the holy grail of actually assigning and using the the variables in the...

This happens if you reuse the same sheets/file over and over again. I'm not sure the exact reason why, but I know each Excel cell that has been modified (i.e....

So then, just confirm, you're saying SQL Server knows what FG each transaction in the transaction log belongs to. Because if it doesn't then the transactions that occured on FG2...

GilaMonster (5/21/2008)

The difference comes when you have multiple different types of queries. Let's take your example.

An index on (Country, Account) is fully seekable for queries that filter on Country and...

I understand how the command works, I'm asking is there a way to have it automatically set that way for certain users whenever they login.

I figured it out. I created a ADODB object in VB and created a connection to the database.