it might help...the devil is in the details.

the pseudo code example we have so far doesn't give us enough to work with...if the big table has an index on the...

I think by just adding to the WHERE statement to Gianluca's fine example, you'd make sure you don't change fields where they already match, you'll prevent re-processing of the same...

get a copy of the free program SQLRecon from specialopssecurity.com[/url];

it is the most full featured pprogram I've found for discovering all the SQL servers on a network;

the documentation says it...

Once again, you guys helped me be a better programmer; I learned a lot with this thread.

converting that MTVF to an ITVF made me understand the concept better, and this...

something like this Simon;

the CHARINDEX function lets you find the position of specific strings within strings; then it is just a bit of tweaking to skip the parts you do...

the issue is data related; you are going for a diff in seconds; the max value is an integer(2147483648 or unsigned 4294967296?)

but the difference between the two dates is bigger...

you have to use a split function which changes the string @tech_list into a table function. otherwise you are trying use IN on a string which just happens to contain...

the error is related to the row size of the insert; > 8062

for example, if i have 25 columns, and they are all defined as varchar(500), 25 X 500 =...

a login has only one default database, even when he has access to multiple db's thru different roles;

ig you go to SSMS>>Security>>Logins, you can find either his domain username or...

i just re-wrote it as well, but the math is quite not right; i'm basically using multiple CTE's to do the intermediate variables as columns, as soon as i have...

there is an article "zip code Radius search" that can help get you started:

http://www.sqlservercentral.com/scripts/Miscellaneous/30878/

it basically requires a table of postalcode/latitude/longitude, and finds all the records that match within the inputed...

I'll admit it, I'm weak on inline TVFs; had to look it up;

i've saved a lot of Paul's recent code that was converting other's scalars to inline tvf's but my...

you might be appending a null to the variable being used for the @body element;

ie SET @body = @firstname + ' ' + @lastname + ' a bunch of info'

if...

this is a common security issue.

Because "Local System" never logs into a domain, it can never access a share. The logging into the domain is when permissions on shares...

Seth yes i had actual plan on, but even with it off it's still ~36 seconds;

there's no space expansion or anything going on behind the scenes; i can run...