If you look at your code you will see inconsistancies between column names in different parts of the code. Without looking back...

Never mind part of my comment above. I was looking at something else while writing it. Sorry, I'm a guy and have trouble multi-tasking sometimes. BUT more...

longobardia (1/30/2009)

---

The output returned is correct:

select t.employeeid, t.TranDte,

dbo.udf_getHistory(t.TranDte, t.employeeid, 1) as Address1,

dbo.udf_getHistory(t.TranDte, t.employeeId, 2) as Address2,

dbo.udf_getHistory(t.TranDte, t.employeeId, 3) as City,

dbo.udf_getHistory(t.TranDte, t.employeeId, 4)...

FYI, not everyone uses a case insensitive collation. It would be nice if your code was consistant in its use of case.

Based on the sample data you provided, what is the expected output?

Then you won't need the transaction log backup in the code.

Mike Levan (1/30/2009)

---

Thanks .

when running this query does the transaction log will be free for every 100,000 recrods? I am just trying to get how this will improve performace when...

You could try the following (in a test environment first)

declare @batchsize int;

set @batchsize = 100000; -- 100,000

while @batchsize <> 0

begin

update top (@batchsize) dbo.Rev set

...

This topic has been reposted with additional information, please go here.

Note, it would have made more sense to have added your additional info here instead of reposting.

If you are talking about adding backup log with truncate_only, please realize that option is being depreciated and may not be available in future versions of SQL Server. Again,...

The error in the title is cutoff. Could you please post the entire error message?

Actually, to save you time here is a link to the article: http://www.sqlservercentral.com/articles/64582/

Josh Turley (1/30/2009)

---

Ok, a little setup for my question:

I have a db, 6GB in size, with a log file that's almost double that.

It's my understanding that simply doing a...

The optimizer must feel that it is less expensive to do a table scan with the second query as a opposed to an index seek and bookmark lookup.

I guess to...

RBarryYoung (1/30/2009)

---

Lynn Pettis (1/30/2009)

---

RBarryYoung (1/30/2009)

---

OMG, you poor SOB! :crazy: I am sure that...