Did you use variable length columns such as varchar and varbinary?

Why don't you post the table DDL so we can have a look?

Phil Parkin (9/29/2014)

---

Koen Verbeeck (9/29/2014)

---

The YEAR function (and MONTH and DAY) only work on date data types, not on strings.

You'll get these errors when your input column is a string...

The YEAR function (and MONTH and DAY) only work on date data types, not on strings.

You'll get these errors when your input column is a string data type.

ronan.healy (9/29/2014)

---

Phil Parkin (9/29/2014)

---

ronan.healy (9/29/2014)

---

i have a date coming in like this

21/03/2018

I keep getting an error. do I have to convert it I tried the following code to try and...

What is the error?

To what data type are you converting?

What is the locale used in the package?

As a SQL developer, you should know how to develop TSQL of course.

I can recommend the books written by Itzik Ben-Gan.

Microsoft SQL Server 2012 T-SQL Fundamentals

If you have more specific...

Really appreciate the amazing effort the PASS BoD has done this weekend to set the issues straight.

LowMemoryLimit: a dedicated amount of RAM for the SSAS instance.

TotalMemoryLimit: when this is reached, SSAS will take measure to cut down on RAM usage. But SSAS can still go over...

You can find some answers here:

http://dba.stackexchange.com/questions/27940/page-compression-in-sql-server-effect-on-running-queries

If you have Enterprise edition, you can do an online rebuild. There might still be some locking though.

If you don't have Enterprise edition, the table...

To enable compression on a table or index, it needs to be rebuild.

This can be done with ALTER TABLE or ALTER INDEX.

More info:

Enable Compression on a Table or Index

Steve Jones - SSC Editor (9/26/2014)

---

With regards to crussell, lots of people will leave a "nice question" or a "thanks" on those items. I don't think there's anything wrong, though...

Hopefully you didn't change them right away, because there was no SSL or...

If you want a leading zero, you'll need to store it as a string, not as an int.

By the way, a much easier expression is this:

SET @currMonthNum = RIGHT('0' +...

I know for ETL you have Talend and Pentaho. Haven't really worked with those tools yet.

No, that is "union all".

Union removes distinct rows.