If you have a Numbers table (some people call it a Tally table), you can query it using something like:

create table #Numbers (

Number int primary key);

insert into #Numbers (Number)

select top...

Have you tried changing to datetime instead of smalldatetime? Out-of-range errors on smalldatetime can often be handled that way.

If that doesn't do it, I'd start with analyzing the data...

Bert (2/12/2009)

---

GSquared (2/12/2009)

---

Sounds like we all agree on this, at least on the parts that matter. Now, our job becomes, to convince others to agree. That, my friends,...

Not sure what you mean. Do you mean store a specific login, or do you mean store the login that's running the package, or something else?

I would contact Microsoft immediately about this one. They need to know about it if they don't, and might have an answer for you if they do.

Sounds like we all agree on this, at least on the parts that matter. Now, our job becomes, to convince others to agree. That, my friends, is the...

Steve S. (2/12/2009)

---

Chris (2/12/2009)

---

Among the specialists, there is no debate. Climatologists from all over the world agree that global warming is real, and that it's threatening our food chain and...

Not sure what you mean by "free fuel tech". If you mean solar power, wind power, tide power, et al, those currently have a higher cost per watt than...

I'm not clear on what you're running into. Are you saying that logins don't exist at the server level but do exist at the database level? If so,...

Actually, I would call Socialism/Communism a religion. Has all the trappings of one. Specific statements about the existence of diety, mortality/immortality of the human soul, proscriptions and prescriptions...

I think normally you should get a PhD on some extension of what you did your Masters in. It shouldn't be something you're just starting out on, it should...

Per Books Online:

The DUMP statement is included for backward compatibility. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development...

Chris (2/12/2009)

---

On the global warming "debate" (akin to debating whether the earth is round or flat), you wouldn't request to see a podiatrist if your left arm started feeling numb...

jcrawf02 (2/12/2009)

---

Bert (2/12/2009)

---

I've intentionally held back here because I've been blasted on this forum before. But since you asked, here goes. While I'm not a Scientologist, nor would...

On the point of BI being misused to create problems rather than solve them, I definitely have to agree.

On the point of driving for enjoyment, I have to say that...