One (perhaps not very efficient) approach is to have a separate query for each OR condition, which adds a column describing the where criteria and then merge (UNION) the results...

Perhaps someone can correct me, but I found the bit datatype a dissapointment for a couple of reasons:

1. Since T-SQL doesn't understand TRUE/FALSE you are still stuck testing for 1...

My guess is that the actual paths are to follow the lcd and cd commands, while the file name would follow the put command. (Note that there are some optional...

Let me admit that I don't use Report Builder (and can't spell SaS). (You may want to stop reading...)

Instead, for similar requirements I publish a general use Excel workbook that...

I agree with Matt. Further, if you let Excel do the import from external data, you can set the query properties to preserve expressions in adjacent columns.

Excellent Guarave!

That looks like a strategy to avoid SSIS, and its FTP task inability (as near as I can tell) to work with sources/destinations (e.g. IBM mainframes) that do not...

My apologies! Guess I never followed the link to the full question.

I'm not sure if I didn't see the listed answers because:

1. I figured I'd be unable to answer a...

This question is one example of a frustratingly frequent practice of posting a multiple-choice question without the choices. "Which of these..." sort of suggests a list of possibilities should follow:-)

The .mdw file is the detailed permissions file that is only established if you are not using the default security in Access. The .ldb file is a temporary file that...

...and those of us who mostly lurk also appreciate the many contributions of folks like Gail. Thanks and hats off!

Matt Miller (2/8/2008)

---

Jim Russell (2/8/2008)

---

I guess I...

dbDever (2/7/2008)[hr

I'm curious as to why you can't check them as they're inserted. I used to manage an SQL2K warehouse that took nightly loads of production data from a...

Matt Miller (2/7/2008)

---

Jim Russell (2/7/2008)

---

"Whilst you may know how they join, an end-user making a simple report has a much easier time if the joins are already defined for them."

Tell...

"Whilst you may know how they join, an end-user making a simple report has a much easier time if the joins are already defined for them."

Tell me more about that...

FWIW, I have not seen performance problems using either CROSS or OUTER APPLY, nothing like would be seen from other RBAR approaches. Maybe I have just been lucky.