wolfkillj (1/22/2013)

---

When I was doing a lot of SSRS development, I wasted so much time closing BIDS and reopening it because often that was the only way to see changes...

What you possible could do is create an abstraction layer in SQL Server. You can create a view for every table, which just selects all the data from the DB2...

Nice easy question, thanks.

What's the question?

What do you mean with "word document style"?

Hugo Kornelis (1/21/2013)

---

EOMONTH is one of them, IIF is a very clear example, and I think there were a few more, but I don't have the time to hunt them...

Since SQL Server 2012 apparently 😉

Other functions "stolen" from other languages: choose, iif, format and concat

Jeff Moden (1/20/2013)

---

I'm just curious mostly because I don't use SSIS for anything...

Have you used DQS in an actual production environment? If so, do you have an specific examples...

Here's a nice comprehensive article:

Concatenating Row Values in Transact-SQL[/url]

It might be easier to change the datatypes in the destination table.

You can also use the data conversion component. It's still manual, but at least you have a checkbox to...

You need to use the IIF function.

Expression Examples (Report Builder and SSRS)

Your question is a bit broad.

I'd suggest you start reading a book, such as SQL Server 2012 Query Performance Tuning.

I'm also pretty sure if you enter "sql server query tuning"...

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread can be found here: http://www.sqlservercentral.com/Forums/Topic1409425-392-1.aspx

Easy one, thanks 🙂

I selected the answers one could expect, because it would be pretty sad if they messed up a brand new function 😀

Always hard to answer a question with no documented behaviour without running it 😉