Viewing 15 posts - 6,226 through 6,240 (of 7,636 total)
Jeff Moden (7/23/2008)
That scenario (like many) audits the wrong thing... you should only Audit the DELETED table... the current value is always in the original table.
Actually, Jeff, I think...
July 23, 2008 at 9:33 am
Sailor (7/23/2008)
search Luke search yielded http://www.sqlservercentral.com/Forums/Topic416687-5-2.aspx🙂
Soooo... you're good?
July 23, 2008 at 9:15 am
Steven Cameron (7/23/2008)
You could use a separate table that tracks the last batch id used
Yes, and you could move batch-common stuff like the UserID into that table. That would...
July 23, 2008 at 9:13 am
Duplicate thread. Please respond here http://www.sqlservercentral.com/Forums/Topic539362-145-1.aspx
July 23, 2008 at 9:05 am
Duplicate thread. Please respond here http://www.sqlservercentral.com/Forums/Topic539362-145-1.aspx
July 23, 2008 at 9:02 am
Dean Jones (7/23/2008)
Thanks very much for the reply, can you please do me a favour by puting the script together as I keep geting errors whilst trying to do this.thanks.
Show...
July 23, 2008 at 8:55 am
It's ADO.net or the ADO.net provider that is having the problem. Two ways around it that I can think of,:
1) Write a View or Stored Proc, then...
July 23, 2008 at 7:45 am
Do it like this:
SET rs = conn.Execute ("SELECT name, Count(*) Over(Partition By 1) as [Count] FROM customers WHERE age<30")
July 23, 2008 at 1:36 am
Actually, what you want is the rarely seen "FULL" Outer Join:
select t.ItemNo, t.BatchNo, a.qty, b.qty, c.qty
From TableA a
Full outer join TableB b on a.ItemNo...
July 23, 2008 at 12:54 am
You can get estimated row counts quickly from this View: http://www.sqlservercentral.com/scripts/tables/62545/
July 23, 2008 at 12:40 am
Sandy (7/22/2008)
Then again come to design of ModifiedDate column and Make this column as GETDATE() as default value.
Actually, a default value is insufficient as this will have no effect...
July 23, 2008 at 12:32 am
You missed an " ON " on line 15.
July 22, 2008 at 4:23 pm
dlongnecker (7/21/2008)
I was hoping there would be some nicer solutions, but these will do!
Heh. My wife said almost exactly the same thing when I proposed to her. 😛
July 22, 2008 at 12:46 pm
Viewing 15 posts - 6,226 through 6,240 (of 7,636 total)