This sounds like it might be due to differences in the language settings between the various computers. To prevent these kinds of problems, you want to make sure

* ...

Formatting should be left to the presentation layer, because it can vary depending on the language or user preferences. Dates should be stored with the DATE datatype, so that...

This will happen automatically in SSMS for anything that's...

There is actually another possibility, but it's highly unlikely.

Your table is set up with case sensitive column names and you have another column in that same table that differs only...

I'm pretty sure that you do and the fact that you are only "pretty sure" and not positive indicates...

Narud (12/20/2011)

---

Sami,

I'm a little bit confused about the field names and the content of your sample code, but I think that this would give you a near result to your...

You probably have two tables named "stores" under different schemata. Adding a condition for Table_Schema should fix the problem.

Drew

The problem is that your hierarchy is improperly modeled. Your structure is incomplete. You have node data and depth data, but you don't have the information about how...

He's confusing the UI (SSMS) with the database. SSMS will display XML results as clickable text when using the grid display.

Drew

You want to totally scrap your method and start over using a set-based approach. CURSORS are as slow as molasses in January.

This is essentially a reverse running total. ...

Your Current_Stmt_Date is coming in as a BLANK not NULL. Your DateAdd is converting the BLANK to 1900-01-01 and then adding 16 days to it to get 1900-01-17. ...

You should be able to answer this for yourself. Ask yourself...

You're going to...

CELKO (12/15/2011)

---

Oh, we also used to put commas at the start of punch cards to make the deck easier to re-arrange – just like you have! I am not kidding...

You're using the wrong field for your current value to add to the running total. You're using MinutesRunningCount when you should be using TotalHoursInMinutes. (BTW why isn't this just...