Nothing right out of the box that i know of. You will probably have to write your own. (or borrow somebody else's)

You could think of a sql job as similar to a windows scheduled task and an SSIS package as the task that is scheduled.

The subquery in your case statement is returning more than 1 value. It looks like what you are trying to do is a conditional result set based on the value...

Excellent question! I noticed the lack of defining the size and my initial response was 1;1 but since that was not a choice I figured there must be something in...

Pretty hard to guess what you are trying to do but maybe you can declare a table variable with the same structure as your function.

declare @MyTable....

insert @MyTable

select * from dbo.abc('parameters...

The term "default" should have been pretty obvious...

I was completely stumped by the answer choices. Like everyone else I missed the semicolon in the subquery and was focused on trying to figure out which of the other...

Toreador (6/24/2010)

---

A good idea, but a bit too easy to guess! Even though I failed to come up with an example, I got it right as the obvious answer was...

Another good straight forward question. Thanks!!!

I too kept looking at the syntax thinking there must be something in there...then wondered if it were one of the questions about exactly how it was worded and intended....

bkubicek (5/24/2010)

---

Sorry for the misdirection. I thought it was what made this question fun. I found a problem just like this in some code I inherited from some...

Chris Jackson-371542 (5/7/2010)

---

When debugging existing code, this a common response from support:

It is "Working as Designed"

1. This is what the code is supposed to do based on original expectations.

OR

2. Yes...

Let's not leave out "User hostile". The kind of system that makes it easy to picture an end user smashing their computer with a 4# sledge hammer. 😀

Just wanted to note (and I'm shocked, SHOCKED, that with 27 posts thus far in this discussion, no one yet noted this) something which I trust everyone would agree is...

Excellent question!!! I like the ones that appear easy on the surface but make you think before you answer.

With all the nitpicking lately I am surprised that nobody complained that...