i'd do it almost the same as the thetodaisies,just changed it to be ready for more dates to exclude:

valuedate NOT IN('20070731','20070724' )

way to go for posting the test data!

the trick is to join the table against a copy of itself.

the join condition is the orderlineid's must equal, but the statusID for...

i fiddled with COLLATE but couldn't find anything that works, so i reverted to a tally table to test true/false for High Ascii characers.

someone might have a better solution, but...

uogmsmith (9/17/2009)

---

Right, But once the data is put into the table, how do you keep it going to manipulate it? Trigger? Daisy Chained SPROC(Nesting)? Functions? know what I mean?...

sample data below, i was trying LIKE '%[^A-Z,a-z] %' but that's not working for me yet; still playing

create table names(

namesid int identity(1,1) not null primary key,

TheName nvarchar(60) )

insert into names(TheName)

SELECT...

also SQLRecon; it uses a combination of different techniques to find all the registrations, their versions, and more...even identifies blank "sa" password installations.

yeah with my method, it requires some disipline to create an extended property for all objects subject to versioning; it's a bit of a pain sometimes. if there's no current...

this might help:

if you have a stored procedure that returns a resultset, wether one row or a million rows, you have to define a table(probably a temp table) to capture...

the only way i could think of doing this was with a check cosntraint and a user defined function.

if you could have provided more details, we could have helped with...

you cannot create a table on the fly across a linked server. the select into...from tries to do that.

you can only insert into tables that exist.

so INSERT INTO ...

I've used extended properties for this purpose; then i can test if the extended property has the desired value before decinding to allow a script to run or not.

[here's an...

you get the best results here if you provide full details(if you can), the CREATE TABLE, the specific condition(THIS column changes, affect THIS OTHER column)

here's an example which *I Think*...

so you need to generate just under a million rows;

here's how i did it:

DECLARE @StartRange BINARY(8)

DECLARE @EndRange BINARY(8)

SET @StartRange = 0x00000004A500114B

SET @EndRange = 0x00000004A50F11FF

--select convert(integer,+ @EndRange)...

Nice solution, Jonathan;

only thing i thought is he might want the preceeding zeros for comparison, if he needs the values as flags?

for example the value 2 returns "10",where he might...

ok here's one way:

i'm assuming you want it in the same format i see when i do ipconfig/all

pairs of [0-9,A-E] with dashes:

cross joining the widget below against a row-number derived...