It's really easy

select @Count1=count(*) from [test] where [testcol] = 10

select @Count2=count(*) from [test1] where [testcol] = 10

IF @Count1<=0 AND @Count2<=0

BEGIN

-- Your SP code here

END

Also, you need to define more the logic you're using because you haev some possible flaws in your code and I see no reason to go row by (agonizing) row.

A...

Jeff Moden (6/6/2013)

---

BWAAA-HAAA!!! I have null idea of...

I have a solution for you that will get the result for a player with 3 consecutive games with the same score.

drop table #gamescores

create table #gamescores

(gameNo varchar(20) not null,

player varchar...

josh.granville (6/7/2013)

---

polkadot (6/7/2013)

---

Hi everyone.

I've got to figure out whose games scores changed the least over time. I've created DDL to illustrate

create table gamescores

(gameNo varchar(20) not null,

player varchar (20) not null,

score...

Aren't you missing the @ on your variable declaration?

DECLARE @BalanceDue money, @ktr int

Jeff Moden (6/6/2013)

---

Luis Cazares (6/6/2013)

---

Sean,...

Luis Cazares (6/6/2013)

---

ScottPletcher (6/6/2013)

---

Sean Lange (6/6/2013)

---

ScottPletcher (6/6/2013)

---

Ask them::

Given table1 with columns "id" and "value", where each id has 1 to 3 values/rows in the table:

Describe the essentials of a single...

ScottPletcher (6/6/2013)

---

Sean Lange (6/6/2013)

---

ScottPletcher (6/6/2013)

---

Ask them::

Given table1 with columns "id" and "value", where each id has 1 to 3 values/rows in the table:

Describe the essentials of a single query (no...

Sean, you gave me an...

Just another option

select CASE WHEN col1 + col2 IS NULL

THEN COALESCE( col1, col2, '')

ELSE col1 + '/' + col2 END as secondtry

from Table_1

It's not an elegant solution but it works

select isnull(col1,'') + ISNULL( RIGHT( col1 + col2 + '/', 1), '') +rtrim(isnull(col2,'')) as firsttry from Table_1

No need for a loop, what you need is a Tally (numbers) table.

The "Numbers" or "Tally" Table: What it is and how it replaces a loop.[/url]

I was going to suggest the CROSS APPLY UNPIVOT[/url] but I realized it was the 2005 forum.

There's not a great solution with denormalized data like this one. A UNION ALL...

This is not the optimal solution, you would be better using dates. For a better performing query, please post DDL and sample data as indicated on the article linked in...