GilaMonster (10/25/2008)

---

Jeff Moden (10/21/2008)

---

Shifting gears a bit here... What a PITA.... I hate it when they do stuff like that... In 2k, the default was OFF, in 2k5, the default...

1mwalsh1 (10/25/2008)

---

Hi all,

Working with SQL Server 2008 Express, I am trying to match user answers to correct answers and tally up the score. Tables are as follows;

Answers

GameNo

Ans1

Ans2

Ans2... etc.

PlayerAnswers

GameNo

Player

Ans1

Ans2

Ans3... ...

Heck... make it as pretty as you want... that's only part of the "best practice". What is a "best practice", though, is actually posting...

baumgaertner (3/31/2008)

---

Thank you for you answer, Karl.

But I do not want to rename the table and then insert the data to the new table.

When you have big tables this approach...

It sounds like you're passing each stage as a parameter and that you're looping through each stage. It sounds like each stage may be different enough where you are...

First, what do you get when you run the following?

SELECT * FROM tabUserInfo

Where (UserID Is Null or UserID <= 0)

Now, what do...

If the table is that large, consider splitting it into smaller tables based on a PK and then build a partitioned view to put it all back together again. ...

smunson (10/24/2008)

---

It's good to have a working solution, but the performance of a WHILE loop construct for splitting strings could have problems with performance when dealing with a large number...

I guess I'd have to argue that developers are sometimes even more arrogant than the DBA. What makes a GUI developer think (s)he knows something about how to store,...

Doing it the old fashioned way using a "Derived table" instead of a CTE...

SELECT orig.AgentID, orig.AgentType

FROM #a orig

INNER JOIN

...

Don't know because we can't see the "Tally Data". There's lot's of ways to "see" file data as if it were a "linked server", but it depends, a lot,...

Paul,

It would help us give you a better answer quicker if you posted Table A and it's data in a readily "consumable" format. See the link in my signature...

Lynn Pettis (10/24/2008)

---

Well, first of all, I had to fix the code you posted. Both tests ran the same stored procedure. After fixing the code, yes the stored...

Crud... I gotta learn to keep everything. I can't find the code that I wanted. I do remember that it's not the same as the following which seems...

Heh... thanks Fraggle... I guess you really do hate RBAR after all! 🙂