Eric M Russell (7/20/2011)

---

The skillset for database development and administration, specifically SQL, tends to hold it's value longer relative to other IT skills like web or mobile device development. New...

Its not about wanting "stupid" employees.

Retention is a concern, but I think moreso for certification of existing skills than training in new ones.

To me, the problem is in explaining to...

Ninja's_RGR'us (7/20/2011)

---

bitbucket-25253 (7/19/2011)

---

[Rant]

After getting the supposed incorrect answer, I cut and pasted the code into SQL 2005 and then again into 2008. Ran each not less than 15 times...

So what you are looking for is consecutive rows with the same...

If there is no definition, then everything is a pattern.

For example, in your sample data, every row is either 7,6,1,2, or 12 fewer or 15 or 12 greater than the...

Here is my solution.

This solution assumes each test will have a max of 5 results. It further assumes that examrowid will be spaced in relation to the rows as in...

I caught that, but based on his initial question (wanting specific columns up until result 5), I assumed he meant a student could have unlimited exams, and each exam would...

Does each exam at least have a fixed # of results (5, as in the example), or could one exam have more of them?

First, I don't think your test data shows your problem as it only shows 1 student (in which case your query actually works).

However, in a table with multiple students it...

Lets try this again.

john, THIS row of #MyAddress:

INSERT INTO #MyAddress VALUES(1,'A B 123456789','123 South River','Apt 1','Miami','FL','33133')

Matches TWO rows of #MySample

INSERT INTO #MySample VALUES (1, '1234567891011','Smith','Joan')

AND

INSERT INTO #MySample...

JohnDBA (7/15/2011)

---

This record does not match because in the #MyAddress table it is NO 'A...

I would suggest you build your query as a string, and execute it as dynamic sql.

Heading out now, but I may post an example later tonight.

Can you give a simplified example of what you're trying to accomplish?

What is the query that takes 30 seconds ... you didn't include it.

Does your query pull every record from the database? Or is there a where clause you're not...

I'd guess it has to do with using the float datatype for @Result1. Try it with DECIMAL and let us know if it works.

http://msdn.microsoft.com/en-us/library/aa258832(v=sql.80).aspx

FLOAT is not a precision data...