Matt Whitfield (9/14/2009)

---

No, not when the knights who say ni are no longer the knights who say ni, but the knights who say 'ekki-ekki-ekki-pitang-zoom-boing'....

Is there any issue with this thread not showing in the 'Active Threads' menu item ?

Log your data to a table variable.

declare @table table

(

col1 integer)

begin transaction

insert into @table values(1)

rollback

select * from @table

I stand corrected 😉

Just to further clarify what Paul said....

drop View VwNewCheck

go

Create View VwNewCheck

with schemabinding

as

Select abs(checksum(NewId())) as New_Id

go

Drop FUNCTION dbo.fn_test2

go

CREATE FUNCTION dbo.fn_test2()

RETURNS table

WITH SCHEMABINDING

AS

return

select New_Id from dbo.VwNewCheck ...

Are you calling the stored proc correctly ?, you need to specify OUTPUT at the caller level if you expect a value.

@@Rowcount should be fine...

ravi4work (9/14/2009)

---

I do not know why such a long query has been posted. it can be solved like this:

select * from vehicle_det A

where duehours= (select min(duehours) from vehicle_det where vehicle=...

nothing happens "at the same time", one event has the follow the next.

If the insert happened milliseconds before the select , depending on you isolation level, the select would...

Think these guys are on the same course ? No conferring now gentlemen 🙂

http://www.sqlservercentral.com/Forums/Topic787196-146-1.aspx

http://www.sqlservercentral.com/Forums/Topic787221-338-1.aspx

http://www.sqlservercentral.com/Forums/Topic787196-146-1.aspx

BOL States (http://msdn.microsoft.com/en-us/library/aa175085(SQL.80).aspx)

Modifications to database tables, operations on cursors that are not local to the function, sending e-mail, attempting a catalog modification, and generating a result set that is returned...

Sorry , but i dont understand the problem. Are you creating a rolling balance column ?

Can you post the code you presently have that may make things easier.

Simply put no.

You could through dynamic SQL , but i would suspect your design is wrong if you need to do this to meet you business needs

Glad of that.

TBH , i didnt know...

Except might be better

Select name from myTable

except

select productName from myAnotherTable

where productCode = 'SomeProduct'