Something I notice a lot of people forget is to get the last day of the month you just need to find the first day of next month and subtract...

Can you provide a sample output of what you want this to look like?

SELECT LEN(CAST(meta_value AS NVARCHAR)) FROM heu_postmeta

I ran into an issue the other day where a field like meta_value was not a varchar/nvarchar/etc, and all I had to do was cast...

Sounds to me like the latest version of SSDT isn't installed.

Do you mean like this:

SELECT

s_element.sendeplatz,

RTRIM (ISNULL(jingle.SzTitle, '')) + ' ' +

ISNULL (auths.szname, '') + ' ' +

ISNULL (comps.szname, '') + ' ' +

ISNULL (performs.szname, '') + ' ' +

ISNULL (arrangs.szname,...

Just run through the install again and it will ask you for a new key, just punch in the Enterprise key. My Local IT thought it would be helpful...

sum as in addition

t1:

animal Type

============

dog Pet

cat Pet

cow ...

I used it to build aggregate functions that should be in SQL in opinion.

Example: the ability to "Sum" a char/varchar/etc field.