here is a script to run on your instances to find out what port it is using.

CREATE TABLE #GetPort

(

token varchar(100),

value varchar(20))

go

DECLARE @inst varchar(200)

DECLARE @inst1 varchar(100)

--Determine registry path and key

IF(charindex('\',@@servername) >...

Thanks Remi; that got me over the hump; here's an example of a pretty complex table that my function returns the ddl as an example:

it still needs some work, because...

just wanted to flesh the background of the question out for some less knowledgable readers:

you can "pin"  a table, or mark it so that it's contents are held in memory,...

by default i think the datatype selected for a datetime conversion is smalldatetime, and it really needs to be datetime.

change datatype on column 4 to datetime, and also any other...

i think that you can simply tell them that it is the industry standard and also against best practices to modify system tables.

That should be enough, in my opinion...some...

another thing could be the definition of the import table, or a convert function:

a varchar field, if no size is given defaults to 30 characters.

select convert(varchar,'This value is actually 44...

EM is not a catch all edit all editor; it does a good job on many things, but not all things.

making a grid that could allow the editing of a...

are you sure about the floor function returning an approximate number? the BOL says it returns the integer portion of the value, and returns it as the same data type.

I...

Phil's reply is spot on; exactly what I would have suggested for a specific date it identifies all projects open on the date passed in;

and if you wanted to test...

yet another version:

declare @m as money

set @m = 200.2365

select floor((@m * 100)) / 100

results:

200.2300

I think you can assume that if getdate() is between a projects start and end date, then it is active; that's pretty straight forward.

select * from projects where getdate() between...

I'll tell you, i love this distraction; Scott's function works well, but I seem to get a much smaller result set than Dewaynes.

I used this SQL to find items within...

sorry; i wanted the conversion for the distance calculation to miles; the "distance" column is  a value, but i don't know what kind of units it's supposed to be.

i don't...

ok i have that same zipcode database , and this SQL seems to work:

select  SQRT(POWER((38.492497 - latitude),-2)  + POWER((-121.404807 - Longitude),2) )  as distance ,zipcodes.* from zipcodes

where SQRT(POWER((38.492497 - latitude),-2) ...

there's nothing wrong with using the IN operator and having only one item in the selection list:

so if [#ABN_RUInput] only has one row witht he value 220056 , it...