You learn more if you try to do it yourself. Which you have done 😎

Would a simple IF...ELSE (Transact-SQL) statement not achieve this?

Note that you can't interact with variables inside D-SQL. So you would need to do any handling and declarations with them inside,...

SQL Server 2016 actually installs with Microsoft's recommendation anyway.

This isn't a feature in 2012, and although I've not experimented as much with 2016, I don't recall hearing that it has become an option. The msdn page makes no...

Going to fix a few bits first.

Firstly, to the above poster, the OP stated that they were using NULL's, not blank strings. I am also unsure why you have chosen...

This one interested me, so I had a Google. A user had an interesting solution on asp.net: https://forums.asp.net/t/1995435.aspx?How+to+convert+Number+to+word+using+Sql+Query+with+standard+US+as+UK+Fromat.

CREATE FUNCTION fnIntegerToWords(@Number as BIGINT)

RETURNS VARCHAR(1024)

AS

/*

Taken froma post...

And what about:

Have you checked your logs for your SSRS service?

When are you getting these errors? When...

How are you telling your package to not proceed the data flow task? I assume you're not using a task result of failure, so what are you doing instead? Does...

Firstly a brief explanation of how AND and OR statements work. I noticed that you have a mixture of AND and OR without any brackets, which is likely causing some...

Sorry I'm not contributing but that is Beautiful, Phil 😀

Your previous post implied to me that there should be nothing at the end. Are you saying that there is a page break and then you have more data (not...

Duplicate post. See topic: http://www.sqlservercentral.com/Forums/Topic1845577-150-1.aspx#bm1845612.

This sounds more like the setting of the object has the Page Break at end option check, or that there is white space after your final object on your report...

You won't be able to do this with default values, however, would be simple to do with a stored procedure (or you could simply change your insert statement to do...