BenWard (7/20/2011)

---

bopeavy (7/20/2011)

--------------------------------------------------------------------------------

I agree the question was misleading!! I ran it 20 times and always returned 5 rows! If the question was in reference to the UNION ALL it...

I agree the question was misleading!! I ran it 20 times and always 5 rows affected! If the question was in reference to the UNION ALL it should have been...

Yes it is more a curiosity type thing, looking more to see for some type of trend...

Maybe you could do something like this:

DENY SELECT ON SCHEMA::SCHEMA1 TO User1;

Or something like that?

opc.three

That at least helps give some sort of direction, Thanks.

@jason

It may have but what opc provide will help me see the pattern yours was alittle harder to see...

Steve (7-19-2011)

---

You could also do something like running a rolling regression analysis, or a rolling look for multiples of some sort as well, but you'd end up coding each one...

opc.three (7/19/2011)

The Dixie Flatline (7/19/2011)

--------------------------------------------------------------------------------

Call the people at SETI.

Seriously, I think T-SQL may be the wrong tool for the job of discovering undefined patterns. This...

Steve,

Yes I do have an ID column that is (1,1) identity, As for the patterns Yes they can and no they may not that I have not been able to...

Nevyn

Yes thats about as close as it comes.

Oh---Root Canal!

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 often...

Would this be what your looking for?

Select a.Rep ,a.total_audits, b.total_Passes, c.total_Failures from

( SELECT [Rep], COUNT(audits) as total_audits

FROM [master].[dbo].[AggregateTable]

group...

Nevyn

In that case the definition would be how often a number or numbers follow the number before it.

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 does...

Try running a query trace or a block trace on that server.