Re: Desparete for advice on stored proc from asp.net

From: Rob (fiddler27_at_att.net)
Date: 06/03/04 

Date: 3 Jun 2004 15:20:13 -0700

fiddler27@att.net (Rob) wrote in message news:<540e4d0b.0406031013.334c03d2@posting.google.com>...
> I have no hairs left and what is has gone gray.
> this makes no sense
>
> I have a datagrid page which allows the user to select certain records
> to do a bulk update... within my stored procedure that gets called the
> first "half" of the stored proc always fires fine, which all it does
> is update one table, the second half actually calls another stored
> proc which supposed to update a different table. THE catch is the
> second half never works the first time the code behind is called, upon
> refreshing the page or hitting the button on the web form again, the
> second half finishes.. I get NO SQL errors at all...
>
> any ideas?

A little bit more info apparantly for some god foresaken reason, the
whole issue lies in the fact that I cant seem to put a date variable
into a nvarchar variable. here is sample code
Set @usertxt=@UserName + 'has was converted on this date' +
Convert(char(12),@DateVar)
if I take away the convert statement, the @usertxt variable gets set
fine, but as soon as the date gets put in their, the whole @usertxt
variable becomes NULL

Even more bizarre, this DOES NOT happen through SQL Query analyzer..
only through asp.net application
PLEASE HELP