Returning an additional row (error) when only 1 row is returned

[WMitchellCPQ]

I am using a two SQL Querys - one is nested inside the other. I want to have the subquery (Query 2) generate an additional row if only one row is returned. Any ideas

Query 1:
Select TOP 1 * WHERE asdf = "XX" ORDER BY asdf ASC
{
Query 2:
Select TOP 2 * WHERE bla = "YY" ORDER BY bla DESC
}

Thanks as always
W

 

[donutman]

It's not clear what you are asking, but one solution that should work no matter what you are asking is to use an IF statement. This is probably not the best way, but without a clear understanding of what you want, it's the best I can do.
IF 1=(Select count(*) From SomeTable Where SomeCondition)
SomeQuery
ELSE
SomeOtherQuery
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[ESquared]

look into the UNION keyword