This is untested, but it might give you an idea.

SELECT MedRecNum,

VisitID,

VisitDate,

MAX(CASE WHEN Answer <= 1 THEN Answer ELSE...

They don't seem extremely difficult. Unfortunately, many people will get them wrong.

It seems like a nice test which will separate good from bad ones. However, on question 2, the queries...

SQL is delicious (6/5/2014)

---

SQLRNNR (6/5/2014)

Great. I love that excuse "It's the way we/I have always done it".

That kind of excuse right there shows a base incompetence. Everything he...

If you insert your information into a properly normalized table, the rest is easier.

To do so, you can use the DelimitedSplit8K found in here: http://www.sqlservercentral.com/articles/Tally+Table/72993/

And work with something like this:

WITH...

Jeff Moden (6/4/2014)

---

Luis Cazares (6/4/2014)

---

sqldriver (6/4/2014)

---

I didn't see this code in the initial capitalization thread. It's what I've been using happily for a couple years. Not sure how it compares...

Where are you adding your conditions?...

My magical crystal ball can't find the error. Could you share it with us?

rn is the column that I added with the value of ROW_NUMBER() OVER(PARTITION BY n.NewTitle ORDER BY n.NewId).

If you need to know what ROW_NUMBER() does, read the following: http://technet.microsoft.com/en-us/library/ms186734(v=sql.105).aspx

Basically, something like this?

WITH CTE AS(

SELECT ROW_NUMBER() OVER(PARTITION BY n.NewTitle ORDER BY n.NewId) rn,

n.NewId,

...

Just another option based on the fact that you're using 2 columns.

WITH SampleData AS(

SELECT 'This is a test' [address], 'This' strtype UNION ALL

...

Here's the whole code with no errors.

What rules do we follow to get to your expected results?

CREATE TABLE News(

NewId bigint identity ,

...

Can you explain how do you get to that result?

Why are you joining all three tables if you only use tables from News?

Could you post sample data and expected results? preferably in the form of INSERT statements.

Here's how you're...

Maybe a new database or a new server. :hehe:

We can't see what's going on, so we can't really help.

A stored procedure (yours) can call another stored procedure (sp_executesql) without a problem.

Do you want to insert the results on a temp table? That would cause more difficulties but it...