This kind of thing:

http://www.sqlservercentral.com/Forums/Topic1343859-1292-1.aspx

Where in the world are these jobs where someone can get hired with 0 experience in the position? I don't think that kids fresh out of school...

Does this work? How about this?

rVadim, Thank you for posting about the Monty Hall problem. I had not heard of this one in any of its various names but I'm always fascinated by logic...

Maybe this way[/url]? Not sure if it still works in the latest Notepad++ and I don't have an instance I can check it against at the moment.

Not sure about this one. The only SQL-oriented plugin I've found is the Poor Man's TSQL formatter. Perhaps the plugin has been deprecated? In Notepad++, try Plugins>Plugin...

I have to second Jeff's sentiment. You should also be using some kind of version control on the code. Whatever tool you're comfortable with is fine. I...

That's a pretty long thread. Can you mark one of the posts as the accepted answer so people will know what there specifically fixes the issue without having to...

Why not use something like SQL Delta[/url] or Redgate's own SQL Compare[/url]?

Freddie Mercury

I thought Lowell and I were gently nudging rather than outright slapping 😎

How did I know Lowell would chime in on this one? Oh wait, it's right there in his sig!

Your query needs and ORDER BY clause if you want them returned in a specific order.

ORDER BY ID

would do what you're looking for

Click on the Progress tab. What does it say there?

Nice!

Don't check "Enable Identity Insert". You would only want that if you actually had the ID column with values in the data you're trying to import. With that...