Many legacy systems from the 20th century stored dates as decimals due to limitations of the technology at the time. For example 08/03/2011 would be stored as a decimal with value 20110803. Modern reporting platforms that enab...

Izenda Reports and Dashboards (IRD) is the easiest and fastest way to create ad hoc reports from SQL Server data bases....

Financial organizations often want an aging report that categorizes transactions into 30 day blocks. How would you code a query for this type of requirement....

Replicate() function can be used to replicate characters. suppose replicate('a',5) will returns "aaaaa" When you are using replicate function, if it returns more than 8000 characters, it will truncate that. To prevent that, you need to cast to nvarc...

Replicate() function can be used to replicate characters. suppose replicate('a',5) will returns "aaaaa" When you are using replicate function, if it returns more than 8000 characters, it will truncate that. To prevent that, you need to cast to nvarc...

Replicate() function can be used to replicate characters. suppose replicate('a',5) will returns "aaaaa" When you are using replicate function, if it returns more than 8000 characters, it will truncate that. To prevent that, you need to cast to nvarc...

Replicate() function can be used to replicate characters. suppose replicate('a',5) will returns "aaaaa" When you are using replicate function, if it returns more than 8000 characters, it will truncate that. To prevent that, you need to cast to nvarc...

Replicate() function can be used to replicate characters. suppose replicate('a',5) will returns "aaaaa" When you are using replicate function, if it returns more than 8000 characters, it will truncate that. To prevent that, you need to cast to nvarchar

This question invites you to share your thoughts on writing reporting queries that deals with more than one databases....

At PASS, Microsoft announced that SQL 11 (codenamed Denali) will support columnar storage. This announcement is incredible news for SQL developers wanting a simple solution to enabling rapid data analysis on their existing infra...