I'm with Wayne. I simply can not bring myself to help someone devise a cursor-based solution when another solution is available. I tried. Even if your current...

As everyone stated, there's nothing wrong with using a view in a FROM clause. However, when you JOIN a view against a table (or another view), you are typically...

If you do determine that you need the indexes on the staging table, you may want to consider dropping them when you clear the table, and recreating them after the...

By the way: no one will (should) judge you for using staging tables. Not only are they faster in your case, they also allow you to rebuild the data...

My solution for this is a little more general purpose that what you're looking at, but it should work.

Turn on SSIS Logging. From the menu: SSIS > Logging....

Ok, that makes sense.

Typically when I set up a multi-value parameter, the default is to select all. This way they get all the data, but have a flexible filter....

It's worth mentioning that because my example references a dataset, it can't be used in the header. It can still be placed at the very top of the body,...

Just to clarify: every UPDATE query should have a WHERE clause. I've often thought it should be a required clause, because something like "UPDATE [Table] SET [Field] = 1"...

I'm not sure exactly what you're trying to do, but it sounds like you are trying to do an UPDATE ... FROM, which allows you to update a table based...

Ganesh has lead you down the right track. That is exactly what you need to do.

However, I usually take it a step further. When they select ALL of...

In the MVC architecture, SQL Server is the model.

In SSRS, the function is called MID(), but it does the same thing. There is also a RIGHT() and LEFT() function that do approximately the same thing. You...

Yeah, I probably should have read a little further into it. Our SAN provides snapshots too, which are largely analogous with SQL Server database snapshots. Only the snapshot...

What you're suggesting shouldn't have any impact on the SQL Server installation. Regardless, I understand your hesitation. The safest way to proceed would be to image the drive...

The creation of a snapshot takes virtually no time whatsoever. No data from the database is copied until it is changed. Only the snapshot header is written when...