Hi,

Thanks.

Circular stuff worked but not the rectangle, but for now, i think we are ok with the circular working.

Thanks & Regards

Krishna

Hi howard and micky,

Thank you so very much. Both the solutions are working now. Micky thanks for saving me an additional work of reversing the string. Now I know the...

Hi,

Thank you so very much for the detailed explanation. I think i am not following the left hand rule. I will try this out and will let you know.

Thanks...

Hi,

Thanks for replying.

Lat: 11.05135492884294

Long: 76.9410753250122

If you see the first insert query, i have the long first followed by Lat but that did not work whereas my second query has...

Hi,

Thank you for the links. Can i get some more links where we have TSQL examples of creating tables with spatial data types, data insertion and data manipulation queries.

Also...

Hi Mauve,

Thank you so much. It saved a lot of my R & D time.

Thanks again to all who checked my issue and for giving me a solution.

Warm...

Hi Lowell,

thank you for the quick response.

Is there any better way to find the word count. I mean is there any keyword or option to get the word count...

Hi All,

Thanks for your replies.

The replies from experts will always be a proof to what i have already informed to my client.

Thanks again,

Regards

krishna

Hi Paul & Steve,

Thanks again for your replies.

I have my table already designed as you have mentioned and I am following second example model that steve has mentioned.

I...

Hi Steve and Paul,

Thanks for your prompt reply and sorry for replying back late.

The table that i have stores the details of automobiles. There are lots of qualifiers /...

Hi Paul,

Thank you. I started with Varbinary Data types for the fields that needed encryption. Then i learnt that NVarchar can also be used. I thought that I can...

Hi All,

Thank you so much for your inputs and it has helped me immensely. The requirement is such. Our client needs data encryption to be done on date data type.