just insert it. SQL Server handles the encrypting of the data before it gets written to the table.

Sure. Post the CREATE TABLE scripts too. Should be enlightening.

Then we can all see if you really needed a cursor to accomplish the task.

Oh for crying out loud. Why do professors teach you how to use cursors, but not in the proper place? I'd challenge the professor and ask why it can't be...

Maybe this article will help?
http://www.sqlblog.nl/dynamic-refresh-ssrs-cache-using-sql/

(Doesn't directly answer your question, but explains how to refresh the cache on a schedule)

And you've been using SSRS for how long now?
1. datasets on the RIGHT are for the PROJECT. datasets on the LEFT are for the report you're working on. If...

Since you can only round numbers, you'd have to cast the values as a decimal and round those. You can't round a string.

Don't think it will work unless the first 2 characters of a the strings are unique, so you wouldn't have something like
Ball
Bath
as members of the set. If...

Elegant? That's the standard pattern for this kind of question. AFAIK, that's the way to do it.

I think you're missing a table.
Package (PackageID*…)
Server(ServerID*,..)
ServerPkg(ServerID*, PackageID*)   (basically the "contents"/inventory of each server)

One way to do it is
(Package CROSS JOIN Server)...

What I'm trying to get at is this: Is there another way of doing this search?
All the NOT LIKE and NOT IN clauses are going to kill performance. Think...

(Maybe I should have read more carefully!)
Those NOT LIKE and <> s are going to cause table scans. Performance will be brutal.

I'm probably going to get grief for saying this, but have you considered creating a view containing the filters you always use and then querying that? I freely admit that...

Before I suggest anything, I'd like to be sure I know the problem. There's a really good article on Subclassing by Rebecca Riordan (but she's implementing it in Access -...

Okay.
SSIS just baffles me. How much RAM am I supposed to have for this? If I open a Script task, it takes like 15+ seconds to close again. WTH???!!!...