bitbucket-25253 (10/20/2009)

---

Wayne I submit that your problem is NOT with the developer but with either the hiring/current Manager who think that the individual...

Jeff Moden (10/19/2009)

---

WayneS (10/19/2009)

---

Hey Jeff... can you FedEx me your biggest, baddest pork chop launcher? I think I'm in dire need of it.....

Just had a "developer" send me some code.

SP...

Oh how I wish he were local... then it would be his head 😀

Hey Jeff... can you FedEx me your biggest, baddest pork chop launcher? I think I'm in dire need of it.....

Just had a "developer" send me some code.

SP "a" has a...

Both.

As mentioned, there will be many more that deal with things at the object level. But, someone has to move those bits around for those to do that.

You might check this link out - but be forewarned - it doesn't look like it's been tested.

Since you're talking about a new server, you also could restore the system...

GSquared (10/14/2009)

---

Some days, neither of those matters to me, and I'll spend hours on an intriguing problem. If the problem means I get to fire up some extra brain...

I used this for copying from SQL 2008 -> 2008. It should work 2005 -> 2008.

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...

GSquared (10/12/2009)

---

I could be mistaken, but he seems to believe that there's only one right way to do things. That's a significant part of what I've taken away from...

abair34 (10/9/2009)

---

CREATE PROCEDURE dbo.help_friend_with_homework (@NumberOfRecords INT)

AS

BEGIN

SET NOCOUNT ON

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'CHEATTABLE')

CREATE TABLE CHEATTABLE (id INT, name varchar(50));

WITH i_copied_this_from_the_internet_CTE AS

( SELECT row_number() OVER (ORDER...

Well, with 100+ points accumulated, you're not that new. But I'm glad that you will now be able to help us in the future... it really makes it sooooo...

Thanks for bringing this to us Jeff, I hadn't seen that reply. (And since...

Regarding Mark's solution, what would (IMHO) be better is if your application already had this table defined. Those codes are coming from someplace, just connect the ClassCode to the ClassType...

Damian, I also thought it was on the easy side. But, I was also (pleasantly) surprised at the high number of folks that got this right (69% at the time...