Would have a table say, signup_status with unique UserID and flags to identify whether an entry was made in the respective tables

create table signup_status

(

UserID int NOT NULL PRIMARY KEY ,

SignUp bit...

or u can try...

SELECT * FROM @TableVar

SET NOCOUNT OFF

instead of

SET NOCOUNT OFF

...

SELECT * FROM @TableVar

HTH

quote:

---

AFAIK it is not possible to directly pass GETDATE() to a UDF (sorry!)

---

Do try this...

oops...missed one thing...

SELECT * FROM myTableWHERE id IN (SELECT DBO.udf_Test(getDate()))

Sachin

SELECT * 

FROM myTable

WHERE id IN (SELECT udf_Test(getDate()))

HTH

Sachin

Happy 24

SELECT @MaxTime = MAX(CAST(REPLACE(Objvar,':','') As int)) FROM TblBid 

- Sachin

quote:

---

It could be shortage of memory resource

---

I have a sp that...

Taken from BOL as I could not put it in my own words 🙁

This is just a basic explaination...

When any SQL statement is executed in SQL Server 2000, the relational...

missed to mention in your 1st sp...

FETCH NEXT FROM TRs

INTO @HistoryID,  @TRno, @Date, @Worklog, @User, @LTIActive, @LTICode



If @LTIActive = -1

Begin

Set @Status = 'Long Term Issue'



Set @LTIField = 'Long Term Issue Code...

You can take a look at this...

http://www.novicksoftware.com/UDFofWeek/Vol1/T-SQL-UDF-Volume-1-Number-27-fn_dblog.htm

Also this function is undocumented, may not be reliable and should be used at

your own risk

HTH

Sachin

Something is better than nothing

Thanks Mark. It will be my pleasure to keep you posted in case I come across anything regardig this.

Sachin

🙂

Hi Mark,

I check out BOL for "fn_dblog" but did not find anything relating it. Where can I find the help regarding this function?

Sachin

🙂

Thanks Frank, I did feel I was pretty much out of luck while posting this 🙁

Haven't come across this site. Seems to be a good one 🙂 Running out of...

Thanks Mark, it works. Previously I did not get any such problem. But now I am working on Personal Edition and Desktop Edition (MSDE) and as u say....

Sachin

🙂