Not sure if this is what you are looking for?

select convert(int, 0xFFFF)

Select convert(varbinary, 65535)

you'd use len as suggested by GSquared if its a variable length value,

Select RIGHT(wday,LEN(wDay)-1)+ LEFT(wDay,1) FROM @tday

Not sure what you are describing here(images are not displayed), but looking at the topic subject, i think this is what you are looking for?

http://www.sqlservercentral.com/articles/Crosstab/65048/

A broken link

or may be this?

select name,city,email, sum(amount) as amt

from tb1

group by name,city,email

Having sum(amount) > 500

You gotta give some test data in a consumable format (sorry if you are just asking for a direction/suggestion only?)

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Edit: Sorry, dint see the post from Chris.

I guess u were close ( if i am not wrong about your requirement).

(Please read this for your future posts, (u might get quicker and varied responses)

http://www.sqlservercentral.com/articles/Best+Practices/61537/)

DOes this help?

Create...

Your insert throws an error I guess(may be because of the identitiy insert)

Anyhow, if I am anywhere close to what you are looking for, see if this helps please.

Select...

If the difference between start and end is within the limit of 2047, then this is 'one' of the method,

Declare @start int

SET @start = 12000

Declare @End int

SET @end =...

dupe I guess,

http://www.sqlservercentral.com/Forums/Topic838859-338-1.aspx?Update=1

Not that I know the answer completely, but it would help all of us here if you can post the data like this and on what basis the amount(last column)...

You want these to act as columns of your resultset?

Not sure what your problem is, but just to help you to help us to help you,(:-)) post the data like this and show us whats your problem

CREATE TABLE...

Its all about formatting the data I guess, have you tried anything?

'BlKBy' column of sp_who2 (stored procedure) should tell you that!