Jason Selburg (7/19/2011)

---

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

---

I just googled it.

Detroit, Michigan, USA.

I rest my case. You can always trust what Google says...

Who...

Steve needs to impliment a "LIKE" button for SSC.

Ok here goes.....

DISCLAIMER: This only addresses one of MANY possible patterns.

declare @numbers table (nDex int)

insert @numbers (nDex)

values

(1),(2),(3),(4),(5),(6),(7),(8),(9),(-1),(-2),(-3),(-4),(-5),(-6),(-7),(-8),(-9)

-- just as Steve pointed out, there must be something that defines the...

bopeavy (7/19/2011)

---

Great Jason so then what direction would you go to find that out? Is there any post or blog on this matter to find an undefine or vague definition(how...

Not sure the specifics of where you're encountering issues.

But in general, you would create a procedure that returns the values you want in your drop down list and use that...

bopeavy (7/19/2011)

---

Thats it I do not have a definition. I am trying to determine is there a way to define that pattern without knowing what it is... and yes that...

I agree, before providing a solution the "Pattern" requirement will need clearly defined. 😀

Dynamic SQL

Dynamic SQL 🙂

Define "Invalid"

Have you tried?

ISDATE(yourColumn) = 1

1. Reverse the ORDER BY in the ROW_NUMBER()

2. Reverse the WHERE to be < 3

3. As a general rule, use table variables or temp tables in your questions/answers. Nobody wants...

And yet another option is to get the eval version http://msdn.microsoft.com/en-us/sqlserver/bb895906.

It's valid for 6 months.

I just ask Jeff. 😀