I agree that I would opt for a solution that doesn't use a mask. However, I'm curious about an implementation. John is right that the update statement won't loop through...

Is the Dept field also supposed to be a mask? Meaning if the customer shopped in both departments 1 and 2 then he should have a value of 3 (or...

Bipinkumar. I don't think that will work if you pass in a table with more than 1 row unless I set it up wrong.

Cliff

I haven't really used table valued parameters much but I'll take a stab. First, if I try to set the default of the parameter to null I get an error....

Way back in SQL Server 2000 we used a product called AspEmail from Persits. It just installs as a COM object that can be called with the sp_OA procedures and...

Thanks for the thoughts. Basically, I was reviewing some code and came across the IF implementation and thought why not just use a CASE statement.

You're right. The presentation layer is the place for formatting. But why even have the convert(varchar, date, style) as it if formatting? Legacy perhaps?

I'm wondering how you are seeing a datetime field returned as YYYY-DD-MM. But let's just say that's true and you are asking how to show it to the user as...

I work for a small company and have become the accidental DBA. I also manage the network, develop our application, help out with sales, marketing, and support; basically I do...

There sure are a lot of variations on this idea. The accountants are even trickery than I thought. 🙂

Good point about the date format. I've rarely dealt with dates outside the U.S. because my company only has local to me clients so I didn't even think about it....

Using a table is preferable. You'll see better performance out of queries. Something interesting that came up during the comments on Part 1 of the article is performance issues with...

Thanks for the detailed implementation. They just published my Part 2 where I talk about getting the Period. http://www.sqlservercentral.com/articles/function/68323/. I mentioned in there that people do the counting...

Thanks for the comments. It somehow slipped past me that the article was published already. Any other comments are much appreciated.

Cliff

drnetwork (9/29/2009)

---

How common is this 4-4-5 (or variant) thinking in modern accounting systems? This is the first I've heard of it and I've DBA'ed behind three different fairly popular accounting...