Actually, I refer to CASE as a statement all the time. Call me lazy. I think I picked up the habit from the programming languages I learned in HS and...

Jan Van der Eecken (2/9/2011)

---

You know, I read through that whole thread, and somewhere mid-way I started wondering whether nadabadan himself wasn't actually the interviewer. I guess I am certainly...

An additional note about SSIS, you can multicast the same data to do different destinations at the same time. That's one of the reasons why I like it for situations...

What is the error message? Please post it.

Actually, that's just the wind blowing up your kilt. @=)

Seriously, though, are you just moving on...

I'm betting it's a QD problem. I've seen similar problems before and the query you presented us with looks exactly like it was "written" by Query Designer. QD just doesn't...

Are you seeing performance issues with any other processes, views, or queries?

EDIT: Are you using Query Designer?

Nevermind! It's my bad.

I failed to notice that the ClientIDs are different as well as the ClientNumbers and that some of those IDs are filtered out of the Fact table...

It looks like you've posted your question in the wrong forum. This forum is for backup related issues and your query doesn't look like it's saving backups or doing restores.

I'm...

Oh, this sounds like a Question of the Day scenario. One of you should totally send this in.

Post the query you're using and we'll see what we can see.

I forgot to ask. What is the exact text of the error you're getting?

One thing that may help (in the long run) is to come up with a DOs and DON'Ts list (Database standards). If you're cleaning up the code, you know the...

I advise using SSIS. You can set up filenames using expressions in SSIS and make it repeatable.

Ninja's_RGR'us (2/9/2011)

---

One more option maybe the op didn't consider.

Do you have by any chance a copy of the script you use the create or load the table? In that...