I think you can do that right in SSIS, but what I've done in the past is insert each into a separate "holding table", then use a query with the...

A useful trick to Begin...End blocks, is indent everything inside them by one tab. Helps you see the flow and make sure that you actually get where you need...

Are they something that needs to be run by a user, or would a scheduled job be a better option?

I would be more inclined to document on a company intranet. I like to use wiki software for that kind of thing, with DBAs, sys admins, etc., having write-access...

Split them off so each has its own table, with just the nvarchar and an ID column. Otherwise, you might have trouble with the other columns.

I'll ask Steve to...

select right('0' + cast(datepart(hh,getdate()) - 12 as varchar(2)), 2)

Try that.

Nah....

andrew gothard (4/8/2009)

---

GSquared (4/8/2009)

---

Robert Frasca (4/8/2009)

---

GSquared (4/8/2009)

---

On the "temp tables are bad" thing, the coding requirements for the place I work state that table variables should be used instead of...

andrew gothard (4/8/2009)

---

Manie Verster (4/8/2009)

---

DBA's have the assumption that all developers are bad for a database or bad SQL programmers. Well, I am a develepor cum DBA but before I...

While I'm assuming this is a homework problem, and I normally don't help with those, this was interesting enough that I couldn't stop myself. 🙂

You have a number of flow-of-logic...

They're just displaying it differently. 00:00:00.000 is 12 AM (midnight). The difference doesn't matter.

I'd say you need a lookup table that stores what date you want "Q1" to turn into. Would that be 1 Jan, 31 Mar, something else? With a...

I'm not sure what you mean. Are you looking at the data in SSIS? If so, how?

Cool biz. Always good to defeat one of these ones that looks daunting at first, isn't it?

Yeah, I took it at face value. I still don't understand what this has to do with leading zeroes, like the title.