I just played around with Jeff's example a little bit. It seems that all prime numbers exhibit this bad DECIMAL behavior, and that the bigger the prime number, the worse...

Yes, it helps. Sometimes you can't see the forest through the trees...

I was trying much too hard, and wrote the following script. It needs a little work for weird...

Wow, Eirikur, this worked great! I think what was throwing me was revealed here in the outer SQL statement:

SELECT

12345 AS '@IDNUMBER'

,(

...

Sorry it took me so long to respond, I was temporarily assigned to other projects, but am now back to "XML Hell".

I'd like to thank Eirikur for putting together a...

Scott,

I totally agree that the logical model comes before the physical, but that wasn't exactly what I was asking. I'm going back even further before...

So there's no other way to drop it before that?

Why are you using a table variable (with...

You can also query sys.sydepends for more information. This is nice since you can join to it in SQL statements, unlike a stored procedure. There's more info at:

https://msdn.microsoft.com/en-us/library/ms190325.aspx

Are the databases on the same server? If so you should be able to use a SELECT...INTO... syntax to migrate the tables:

SELECT [Col1], CAST([Col2] AS VARCHAR(10),...)

INTO...

I have a hard time understanding your example, so I don't know if this is the answer you're looking for, but have you looked into the syntax for a MERGE...

Thanks Nevyn! That's the solution I was looking for! I did a little more research based on what you showed me, and sure enough, the information is buried on the...

Unfortunately, I am a developer working with a 3rd party ERP system rigorously controlled by DBA's. In other words, turning on full text search is not gonna happen...

Thanks, Jeff, this gives me something to focus on. Now all I have to do is cut out all the "uhhs" and "umms" from my answer (I sometimes talk like...

Jeff Moden (3/4/2015)

---

Heh... whether you're interviewing for a Developer's position or a DBA's position, one of the most important things would be "communication". You and I have just failed...

As a DBA, you'd better have a definite plan of attack on something like this and you'd better be able to explain what that plan is. And, no... it's...

Wow... I just checked back on my humble little post: 27 views, and no one willing to take a crack at the answer. Okay, you 27 don't get the job......