2012年2月16日星期四
BatchOptimistic
I want to read dataset records from other dataset before updatebatch
process. Is this possible ? If this is possible how can i do ?
-- all DataSets locktype is BatchOptimistic
Thanks for adviseAre you talking about ADO? I see no reason why you can't read records from
one recordset and update records on another recordset using optimistic
locking, but try getting an answer from the microsoft.public.data.ado group.
"SharkSpeed" <sharkspeedtr@.yahoo.com> wrote in message
news:%23TfwfaG9FHA.500@.TK2MSFTNGP15.phx.gbl...
> Hi everybody,
> I want to read dataset records from other dataset before updatebatch
> process. Is this possible ? If this is possible how can i do ?
> -- all DataSets locktype is BatchOptimistic
> Thanks for advise
>|||DataSets LockType is BatchOptimistic.
Yes ADO and Database server is SQLServer
2012年2月9日星期四
Basic Reporting Problem
Hi
I am having a problem with reporting. I want to query SQL data using dataset using a query which looks lie this.
slect thisparam,thatparam from tablex where thisparam = @.thisparam
thisparam is a user prompt. When the user leaves prompt value to be empty and clicks on view report i want to display the data
select thisparam,thatparam from tablex
else use the above statement with the parameters.
Could someone help me with this. Should I user filters or expression.
Thanks
SQL NEW
You can do this in your SQL statement:
select thisparam, thatparam
from tablex
where thisparam = @.thisparam or @.thisparam is null
If you want to treat the empty string and null as the same, then just add another or:
where thisparam = @.thisparam or @.thisparam is null or @.thisparam = ''
|||Thank you it worked. Can you tell me if there are any tutorials to start for reporting services please let me know .
Thanks
SQL new
|||Hi - I've been enjoying the traffic on some of the other SQL Forums, which inlcude a forum for T-SQL Syntax that you might find helpful. The SSRS Forum is highly trafficked, however as a result any off-topic questions you post are likely to be absorbed in the conversation stream and disregarded.Other forums:
http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1
Enjoy - Greg