I would like to took up this task. Hope a short series with 4 or 5 article is good enough for this Add-on series over the existing Stairways to SSIS

Interesting Question. Got something new to learn. Thanks a lot! 🙂

Same Bad Feeeeeeelllll 🙁 as others.. My answer is correct for nvarchar.....

Good Article.. Thanks for posting such helpful topics...

peter-757102 (2/21/2011)

---

Richard Warr (2/21/2011)

---

DATENAME() is fine for SQL Server 2005 and later. However the article stated that it was for SQL Server 2000 so is of use to those of...

Richard Warr (2/21/2011)

---

DATENAME() is fine for SQL Server 2005 and later. However the article stated that it was for SQL Server 2000 so is of use to those of us...

hi peter,

The function DATENAME( datepart, date ) alone is enough to return the required data [MonthName], Is it necessary to use the combination of DateADD function too??

Please refer above code...

Hi All,

I donno how the UDF code was missed while publishing, I update the code as a new article, however I'm providing the same here also..

if exists (select *...

Useful Article, in sense the author explain a new alternate of GROUP BY for DISTINCT ( Surely Unknown to many ).

For finding the Duplicates, the Query is Okay, but in...

It gives an error......

Error: "Column name or number of supplied values does not match table definition