thank you both for your replies 🙂 to clarify I want is to return rows that only contain the letters/characters outside of A through G and outside of 1234567890

so...

Yes person_id is unique , role_id is not

so the only way to validate either of them would be no harm testing etc rather than if the majority of queries use both fields , but some use either...

One question, why does it return NULL for the boundary_id for the final partition ? I understand why the boundary_value is NULL but the ID ..not quite sure !

thats brilliant thank you Sir !

Hey Jeff

takes 4 minutes amd returns 555 rows

thanks simon

Hey Jeff

thanks for the input

as far as I was concerned the updated flag was a poor choice but the only one I had, the updated data isnt visually...

thanks Gianluca much appreciated 🙂

thank you all for your replies and examples... really appreciated

~simon

sorry not familiar with the phrase "go down to the basement" ?

anyway yes sure this was an example string

declare @p2 varchar(10) set @p2=NULL exec sp_proc @Code='TF',@TypeCode=@p2 output select @p2

thanks...

sure here goes

also its still including duplicates 🙁

spidwaitresourcetypblockedlastwaittypelogin_timeopen_trancmdblock_level

57RID: 11:1:2937:8Blocking54LCK_M_U2014-03-07 11:27:34.1972UPDATE2

57RID: 11:1:2937:8Blocked54LCK_M_U2014-03-07 11:27:34.1972UPDATE2

CREATE TABLE [dbo].[Blocking_Detail2](

[spid] [int] NOT NULL,

[waitresource] [varchar](512) NULL,

[typ] [varchar](20) NULL,

[blocked] [int] NULL,

[lastwaittype] [nchar](32) NULL,

[login_time] [datetime] NULL,

[open_tran] [smallint] NULL,

[cmd]...

thanks jack ...the only problem is it takes 1 hr 15 mins to run on just a 1000 records !!

thank you both much appreciated

MyDoggieJessie (3/6/2014)

---

"It depends"

This would be specific to your environment, your databases, size, volume of data being moved around, etc.

At our shop, I typically look for anything over 250,000 reads. ...

not sure if forum ettiquette on here allows but bumping this thread as still in need of an answer

many thanks

simon