Not sure whether you've already worked this out, but sounds like you need

select cast(3434.3484365657 as decimal(19,2))

Standard Windows:

Shift-Alt-Spacebar x

How about creating an additional integer field with identity (to do the counting for you) and then create an insert trigger to set the field you want. 

Try running this and see if it gets you moving in the right direction:

declare @a float

declare @b-2 decimal(19,2)

set @a = 3434.3484365657

set @b-2 = @a

select @a Float, @b-2 TwoDPs

This thread should give you what you need:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=201594

Ace.

I'm sorry, but I'm afraid that confusion still reigns in my mind!  Why would you want to write a program that works exactly like IDENTITY?

Does your prog need to generate...

I think you're right - I tend to do dev and debugging on my PC and so it all works fine for me.

No problem about the help - people in this...

When you say 'automatic' - I presume you mean exactly that, ie users do not need to do anything special, they just INSERT to the other fields and the key...

OK - the code is in the right pane and there should be a yellow arrow pointing to the first line of executable code (after any declarations).

Just use the step...

Check out the NEWID() function in BOL and see whether that suits.

There's something fishy going on here - presumably the fields were defined as not null for a reason, in which case you should be populating them with sensible data.  Or...

Sounds promising ...

Debugging: right-click the stored proc in the QA object browser.  'Debug' should be one of the options available to you.

Regards.

OK, no offence intended.

This link may be of interest - they seem to have the same symptoms as you.

http://www.talkaboutdatabases.com/group/comp.databases.ms-sqlserver/messages/123008.html

Other than that, I'm running out of ideas.

Did you use the debugger to track down the NULL problem?  If not, running the stored proc step by step in debug mode might point you in the right direction. ...