it's actually usually used for parsing up a Server.Database.Schema.Tablename object, but like you identified, works perfect for IP addresses as well; anything that is getting chopped up by periods; I've...

if there are exactly 3 decimals/4 parts in your string, you can use the built in function PARSENAME.

otherwise, it's the same idea, just more involved by using CHARINDEX and SUBSTRING

declare...

why not use a windows group that has admin rights? you give them a network login, set the password to expire in three days or whatever, and you are done;

they...

ok this was a kewl project for me;

to solve it, i used a function similar to CHARINDEX, but i used the AT() included below...it returns the Nth occurrance of a...

frank what we are looking for is the specific rule so we can help you;

for example is this statment true:

in the data sample like this:

"from right to left,one subdirectory exists...

i think this is what you are looking for; you need to use a CASE to get your "conditional" count that you were trying to do in the internal WHERE...

the command you pasted is just one piece (actually the last step) of enabling FILESTREAM on 2008:

it's got a syntax error as well; it should be thisL

EXEC sp_configure filestream_access_level, 2

RECONFIGURE

http://msdn.microsoft.com/en-us/library/cc645923.aspx

Before...

not true; SQL 2008 Express supports filestream:

Microsoft (10/20/2009)

SQL Server Express

SQL Server Express supports FILESTREAM. The 4-GB database size limit does not include the FILESTREAM data container.

However, if FILESTREAM data is...

Elliot kick *** giving us the sample data to test with!

don't know how close it is to the original posters, but i got similar results whether i choose t1.ZipCode or...

an index scan is not really a bad thing; much better than a table scan.

I think it depends on the selectivity of the index in question as to whether you...

ok I was playing with this today and found that i somehow broke the code for an computed columns;

I fixed and tested the solution, and here we go again:

here is...

ahh;

thanks Dave; That got me jump started so i could make a 1-to-many table that i was fishing for.

Thank you again!

the default trace only shows DDL statements...create table/proc/alter/drop, for example.

you need a separate trace running for DML statments like select/insert/update/delete.

log reader like apex is the way to go here.

i may be wrong, but i thought a linked server only allows DML (data manipulation and no DDL; you can't create a temp table, nor use the "SELECT... INTO NewTable...FROM"...

Elliot thanks, I'm looking at it now, if i get it to work i'll add another version;

sarodude, thanks! i had it working, then was trying to find the right column...