Point Made.

I would love to see your example on how to retrieve an image a display it to the clieint... I am still really new at this.. and would really like...

When ever you make your first trip to the database in order to retrieve the @TEXTPTR value and the DATALENGTH value.. AT THIS TIME ALSO RETRIEVE ALL OF THE...

i have got a solution for you... will post it later..

Are you accessing sql2000 with .net script?

erik

Need some help...

i am receiving this error when tring to run the procedure..

Server: Msg 8145, Level 16, State 2, Procedure xp_smtp_sendmail, Line 0

@ping is not a parameter for procedure xp_smtp_sendmail.

thanks,

erik.

will someone please help and o'll wondering soul out by giving me a human version of (NOLOCK)??

THANKS!

ERIK

will someone please help and o'll wondering soul out by giving me a human version of (NOLOCK)??

THANKS!

ERIK

I really enjoyed the article.

There is  huge benefit for dynamic stored procedures in when vb.net...

got the (all the zip codes with in a given radius )and it is right on the money.. i am stil working on the distance between.... but the new one...

There are two forms of this rule depending on if the values of the two Longitudes. If the Longitudes are both on the same side of the Greenwich Meridian, (i.e...

I am not sure if they are suppose to be positive are negitive...

do you know?

i am three days deep into this already..

this is...

I have got a resent set of data... i just posted a link yesterday with it in a zip folder along with two procedures and on function.... For calculating distance.

my...

finally got one of my distance procedures down.....

i'll give this one to the fourm...

i looked all over the net and never found a complete one just like this. this...

i believe that float is the magic type... i am trying to get a grasp on how to set the precision... or what that actully means

??????

does anyone know What is the correct datatype to store latitude and longitude with? 

  +40.813394,    -73.047175