OK I've got ~140 or so points accrued from the QOD section, that are not applied yet to the points viewed in the forums; right now my rank is "SSCrazy",...

after you stop and restart the server, the tempdb gets recreated....if it is small by default,(say 10 meg) the first SQL that inserts those 11,000 rows into the temp table...

i have this saved in my snippets,it's supposed to find all zip codes within a given distance, assuming you have a table with zipcode, lattitude,longitude in it:

hope this helps:

/*

Returns zip...

isn't the table scan and not using the index due to the SARGable condition?(Search ARGument)

column = @value can be used to search as boolean match to the index

column is...

adrish sorry about the late followup; the forum doesn't seem to notify the author for posts on content the way it does for forum threads.

since this version got created, I've...

show us your function call;

here's an example of using a linked server to get a function call back, does this help?

exec ServerName.master.dbo.sp_executesql N'Select SERVERPROPERTY(''MachineName'')'

thanks for the feedback Bill;

I had initially tried to use the INFORMATION_SCHEMA views to build a script like this...the problem is, those views do not contain all the information. which...

it's in books oline:

BACKUP MASTER KEY

RESTORE MASTER KEY

http://technet.microsoft.com/en-us/library/ms174387.aspx

excellent job posting the CREATE and INSERT statemetns.

Thank you!

getting the output you want is easy; it's exactly what the new row_number() function is for.

updating the existing table is hard,...

if you could provide the actual table definitions, you could get a more refined answer.

basically what you want to do is LEFT join all the tables, so you get either...

I'm assuming you want to see the text of your procs....

any of of these will get you started:

select * from INFORMATION_SCHEMA.ROUTINES

select * from sys.all_sql_modules

select * from sys.procedures --just procs

only way i could think of was to use parsename and do a double convert from int back to varchar:

declare @ipAddress varchar(20)

SET @ipAddress='010.000.123.094'

SELECT

CONVERT(varchar(3),convert(int,parsename(@ipAddress,4))) + '.' +

CONVERT(varchar(3),convert(int,parsename(@ipAddress,3))) + '.' +...

you might want to attach your proc, instead of copying and pasting it.

just from what you pasted, i see one way to improve it:

you mentioned you are using some functions,a...

I've done almost the same thing that Grant is talking about;

for a .net web page suite, we slapped together a couple of utilities that spidered all the web pages so...

not really...you could call the procedure prior to your users calling it to get it compiled, but it depends on what it is doing. does it just SELECT data or...