Another way of achieving the same result...I am not sure about the nature of your ID column. It appeared to me to be a candidate for Primary Key but since...

You can try this too...

convert the float value to int and then convert the resultant to varchar

consider this:

/*Assuming you have a float value*/

declare @f float = 12345678

select convert(varchar(10), convert(int, @f))

One...

For people wishing to learn SET BASED T SQL Programming - I recommend this post whole heartedly. Every single word needs to be understood at the utmost microscopic detail. Many...

That's surprising! Is there a way to verify this? I always thought that the entire Select Statement is executed atomically - meaning all at once. This seems to suggest that...

Dear Jeff:

You are truly awesome. Heartfelt thank you for explaining it so succinctly and beautifully. I was able to understand every syllable of it.

Regards,

Saurabh.

Dear Jeff: Please pardon me if this seems to be a naive question - however I wanted to understand why you have chosen to use the Newid() function here when...

Hmmm... sounds pretty interesting! What kind of problem are you working on? Would it be possible for you to share some details with us - unless confidentiality requires otherwise...

My bad...

😀

My bad...

😀

Apologies for multiple posts....there was some problem with my internet connection. I have deleted the multiple posts anyway.

Viki - It would be instructive to familiarize yourself with Question Posting Best...

Deleted Multiple Post

Deleted Multiple Post

I am truly honored to hear the good words from you, Jeff. It's a big encouragement and kind of vindicates my decision of posting my code (I had debated whether...

I did it slightly differently and realized that I have a lot to learn as far as sql coding is concerned. But I just wanted to present another way of...

roxanadima1 (6/3/2009)

---

I need to make a SELECT with a call of a stored procedure in the WHERE clause.

It should be something like that....

SELECT distinct top 10 i.x, d.droit

FROM v_droit...