This topic is making me wonder about a post I put in the Reporting Services forum about Integrated Security. I have no problem deploying reports that use a...

Well, no responses so far... dang... So, I'm now trying to use SERVER_LOGIN within the stored procedure, and it produces results just fine within Visual Studio, and...

Any given control in your report can be tied to one or the other of those datasets. A table or matrix control is only going to be...

Wow... that was too easy... but thank you thank you thank you for saving me the time of having to try and find it when I wasn't even sure where...

What about taking each inner query and dumping the results into a table, even if it's a temp table, and then indexing the resulting tables, then running that plus an...

I don't know about how things go for you, but where I come from, lazy options don't generally produce good results without a considerable quantity of dumb luck, and I'm...

You don't really need the wizard to put a table control in place. While it's a handy feature, you'll likely learn more if you try to put a...

Try this, but you'll have to adapt it as I can't create any tables so I had to use table vars:

DECLARE @Inks TABLE (

InkID int NOT NULL,

InkName varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS...

Perhaps one of our differences relates to when to use the Entity, Attribute, Value approach. There's never been a scenario where that was the entire solution - it...

Fantastic! Glad you got it working. Hopefully, this process of exchanging ideas was the progenitor for the idea to disable non-critical services. I can't tell...

TroyK,

I appreciated the story, and it was definitely a good read, but going from "EAV" to anything even remotely resembling what that story described is a rather vast leap. ...

Ok, so screen real-estate is at a premium. I don't see any reason why two queries shouldn't work, as long as selecting an item gets it added to...

On the network install, I would suggest mapping a drive letter from the machine "to be installed on" to the installation source. Then go to a DOS command...

I was looking to see if they were identical to the new machine or not. Knowing they're different leads to questions about the build process for the operating system...

TroyK,

I appreciate you providing some links - unfortunately, neither one provides ANY level of detail on what's wrong with an EAV design. All I got there were statements...