Yes, that's all. (You'll see if you try...;-))

How about having a look at BOL, section "GRANT Object Permissions (Transact-SQL)"??

I strongly recommend you number the rows prior to import.

I'm sure there are tools available on the web that will add line numbers. I, personally, use a DOS batch file...

First: What's the reason to use SSIS for it?

Create a lookup table holding your website_name and your ordering number. Use something along "ROW_NUMBER() OVER (PARTITION BY email ORDER BY website_name_order)...

TIM.OGRADY (6/19/2010)

---

Is there a way to ensure that a flat file is loaded into sql in the exact sequence of the source file?

I am having a similar concern with a...

My pleasure 😀

Yes.

You could provide the primary keys as a comma separated list (without blanks) and use a split string function to covert that list into a table (search for DelimitedSplit8K on...

Stefan Krzywicki (6/17/2010)

---

However, even the standard datetime has that problem if you're not dealing just with England, America and other former English posessions. Russia used the Julian calendar until 1918,...

I don't think it has to do with the server upgrade...

it's more likely caused by the ISNUMERIC(ML.MISC_LAB_VALUE) = 1 function together with the CONVERT(DECIMAL...).

Reason: ISNUMERIC() will return 1 for values...

nikhil0416 (6/17/2010)

---

... Comparing two values of the Date data type will almost always perform better than comparing an int with a date value(in which case one has to be implicitly...

Glad I could help 😀

Jason Messersmith (6/17/2010)

---

I forgot to mention that this is in a data warehouse. so maybe it was to be able to join to a fiscal calendar quicker?

I...

There a several ways to get the quarter of a given date (in the order of my personal preference for result in an INT format):

1) use a calendar table that...

Stefan Krzywicki (6/17/2010)

---

...

If you can change it to a date column, I think you should. There may be others who can give you a good reason to keep it...

If you have any chance to get the money back from that "consultant": go for it!

It's one of the worst choices I've seen to store a date value. Even worse...