Hi Thanks,

I'll have play around with the code supplied.

Thanks for the help 😉

Chris

Hi,

Thanks for your reply.

If I understand correctly, I would need the centre point in order to use STBuffer().

I don't currently understand how to find the centre point from the...

Just to finish this topic off, I eventually got my data posting correctly in and out of CONTEXT_INFO as an NVARCHAR. I did however find one additional problem which I...

Howard, that is brilliant!

I had to tweak it slightly as follows to get the Byte I wanted but the method works perfectly. Here's the what I ended up with:

(CAST(SUBSTRING(CAST(device_status_flags AS...

John,

In this instance, Byte 0 is the Least Significant.

Here is the description of the encoding that I have been given:

Byte 0 (LSB) = status flags

Byte 1 Current voltage (the value...

Works a treat. 🙂

Thanks for the replies guys.

I need to create multiple rows and yet interleave the rows so that row1 created in table b is referenced by row 1 created in table...

Hi There,

Thanks for your reply. Actually, the reverse is true.

The end requirement is to indicate, in a bit field in the results of the stored procedure, if the row that...

Mr M: Yes, the field is an NVARCHAR. I tried reducing the size of the source data to NVARCHAR(64), it still didn't work.

Hi Mr Magoo.

Thanks for your replies.

I tried changing the size of my VARBINARY to both 256 and MAX.

Unfortunately I get the same result. It seems that when I set the...

Originally, I was using VARCHAR as follows:

DECLARE @SYSUSER VARBINARY(128)

SET @SYSUSER = CAST(CAST(@LoginName AS VARCHAR(128)) AS VARBINARY(128))

SET CONTEXT_INFO @SYSUSER

This worked.

Then came the new requirement to be able to support non-unicode characters...

Hi Lowell,

Thanks for the reply.

As far as I am aware, no implicit conversation from varchar to nvarchar is taking place. The source value (@LoginName) is nvarchar(128).

I am converting this...

Hi again,

I found a solution for this issue after trawling the internet for a bit.

http://www.dbtalk.net/microsoft-public-sqlserver-tools/ssms-2008-a-512328.html

Basically in my user profile, I backed up and then deleted the regsvr.xml file in

\Application Data\Microsoft\Microsoft...

GSquared,

Just tried that out and it works perfectly with my code.

Thank you so much, this was driving me nuts! 🙂

Chris

Having tried out both suggestions, I found that the method using STUFF worked best as I was able to adapt my existing code using a CTE to use this method.

I...