Yeah. The most likely explanation is that the person/people who built it don't understand what they're doing. Very true.

One way would be to get a full list of Canadian postal codes and use that. That's a bit of overkill, though.

Canadian postal codes are formatted with three characters,...

David Portas (1/14/2009)

---

This is a bit of a mess. In SQL Server 2000 semicolons were optional or in a few cases actually not allowed at the end of statements. In...

You're welcome.

Grant Fritchey (1/14/2009)

---

Hey Gail,

I see you suggested turning the safeties off to my bestest friend. Holy cow! Triggers calling unsafe CLR code. That ought to be entertaining. Some consultant somewhere...

Null in an FK value just means it doesn't have a parent relationship. Most of the time, that doesn't make sense, but sometimes it does. It depends on...

Have you tried looking at the data returned by the derived table to see if it's got any out-of-range dates?

If that doesn't help, try inserting into a temp table, then...

I've done that kind of thing before, and I usually use checks like IsDate or IsNumeric to validate the data before I try to run an insert on it.

I'm confused. I've been using SSIS since 2005, but I don't think I've ever "logged in" to SSIS. I've opened Business Intelligence Dev Studio (BIDS) to build/debug/refactor SSIS...

You can use Output Parameters on stored procedures. Those will return a value to the proc that calls a proc.

They look like this:

create proc dbo.MyProc (

@OutputParam int output)

as

select @OutputParam...

There's the Row_Number() function. Have you looked into using that?

DC (1/14/2009)

---

The only issue with doing it this way is that I need to be able to input different dates from a gui as oppose to hard coding a Start...

Something that strikes me as possibly erroneous in this query is that it has a Left Join, but there's a Where clause on the second table of the join. ...

Yep.

I guess I don't understand what you mean about not being able to connect to SSIS from an instance of SQL Server in Management Studio. What aren't they able...