Not built in (well there is, but not the way Excel does), but if it's just month, it's fairly easy to do. It still seems odd that the client would...

Ah, you want to duplicate Excel's behavior, not fix it? What Excel does with the Date function is take the year as passed, the month as passed, and the day...

I'd try running it locally with SET FMTONLY ON and as noted earlier, from a different database on the server, especially since it's dynamic SQL. The next step, since you've...

Since we don't know what your code does, this is just in case it's simply a typo causing the problem. You are passing two different values for @Param2 between the...

Jeff, we get dates in exactly three formats, MM-DD-YYYY, MM/DD/YYYY, and YYYYMMDD (this one has to be a string to work, but is in our case), all of which convert...

I guess I should answer your second question as well. If you want to do it, I'd use Difference in your case. You'd need to loop through your table, pulling...

We've only ever used Soundex/Difference for things that are then spot checked by a human. Sort of a "shrinking of the haystack so the needle is found much faster". In other...

Additionally, to tackle the MAC address, I'd probably do something similar to my other code, but with a hex conversion function. Since each of the 6 sets of 2 hex...

halifaxdal, in case you missed it, your reversal routine can be found in my code above.

It's because Excel does things a bit differently. The third parameter of your DATE function specifies which day to use when turning it into a serial date. So, it's returning...

That's pretty close, karthikeyan. At the very least, the following code is RBAR in nature, as you are looping through #Tranches a row at a time for all of the...

The funny thing is that I actually have that Convert styles table from BOL, including the footnote, printed out right in front of my face, as I often have to...

No comments or suggestions here, just a lot of questions that aren't being answered. I can't come up with a good reason to do what your code is doing, and...

I have a better idea. Why not use this as a learning experience for yourself?

At a glance, I see a single RBAR issue in your query. Can you tell us...

Not at all, and based on what I just learned, I'd definitely go with your method. I've never had to do a string to date conversion from a string that...