LutzM (1/4/2011)

---

@dave-3: I'm not sure if the REPLACE() is less costly compared to a LEFT(LEN()). Any reference for rough measures or don't you think there will be much of a...

something like

REPLACE(<yourstring>,'-large.jpg','')

Should do the trick

Had to share ... On facebook one of my wifes friends posts

On drilling into C++ from C#, I know now why C# is so called "word safe": Bloody hell C++...

LutzM (1/4/2011)

I sometimes have a hard time following Dave, especially if he dives deep into details.

My only chance is to read what he wrote over and over again until I...

Funnily enough , most people arent surprised to find out they are not following me 😀

Already did , maybe everyone was in a holiday mood 😉

Just...

Chris Morris-439714 (1/4/2011)

---

Craig Farrell (1/3/2011)

---

For anyone following the earlier infringment discussion, some sleuthing around SSC finally revealed the blog owner. A brief PM conversation seems to have dealed with...

kurniawan.kumala (1/3/2011)

---

hi, dave

may i question to you, base on your link.....

1. indexes IX_Dave_Items and IX_Dave_Price can be run at sql 2005?

2. at index IX_Dave_General, if i don't have trancode, so...

Happy new year to you too,

The key is now to find the first/earliest 'IN' stock movement , that still has stock remaining in the warehouse. Since you are...

Ok , so you have 5000 lines of stock,

how would you calculate the amount of stock for each line ?

Hi ,

im not going to give you the answer here ,

but answer me this (in SQL code) :

Can you tell me how much stock you have in your warehouse right...

use the modulus operator (%)

So if X%2 = 0 then even if X%2=1 then odd

Try this one which describes the code i wrote.

http://www.simple-talk.com/sql/performance/set-based-speed-phreakery-the-fifo-stock-inventory-sql-problem/

Take a look here

http://ask.sqlservercentral.com/questions/826/the-fifo-stock-inventory-sql-problem

IIUC , you only need to take it as far as the "LastPartialStock" subquery

Cant say im feeling flattered 😉

http://arabprogrammers.blogspot.com/2010/12/returning-top-x-row-for-each-group.html

EDIT :

And another...

http://www.salkhordeh.mihanblog.com/post/607