Alex

That would work so long as you have a row for every day for every volume. If there's any chance you won't, you ought to join to a calendar...

Alex

Not sure whether you want the average of all the drives for a particular day, or the average for a particular drive over all the days. But here's a...

Grant

Whoever is making these wacky claims, it's his or her case to make, not yours to rebut. If you're going to do a service to the community by rebutting...

You could use one of any number of auditing techniques instead - a logon trigger for example. But you'll still need to run it for a month (or whatever...

Steve

Have you specified DT_WSTR in the properties of the output column? Open the Advanced Editor for your Derived Column transformation, go to the Input and Output Properties tab and...

Ooops - double post.

It's been like this for several years now. It's always an hour out between when the clocks in Europe change and when those in the USA change. So...

I don't suppose you can reset the counter - it wouldn't be accurate any more if you did. What you could do is, when the alert fires, run a...

Here's your view definition in a format that makes it much easier to read. But we're also going to need table DDL and sample data for all tables, please.

CREATE...

The examples in Books Online are a good place to start. Here's an illustration (not tested) that I cobbled together. You might also want to bear in mind...

Are you familiar with the LAG and LEAD functions? I think you could use them to avoid the loops.

John

Steve

I think what I would do is this:

(1) Import your file into a staging table

(2) Move the rows with no product or valid product to the destination table

(3) Handle the...

sp_MSForeachdb will return one result set for each database and therefore you can't put the results into your destination table with a single INSERT statement. You'll need to embed...

Steve

I'm finding it hard to visualise this. Please will you show us the table structure and sample data, the SQL to create the foreign key constraint, and some of...

Thom's right. Go to the Security tab on your Linked Server properties and change the connection to Be made using this security context, and enter your SQL login name...