It's easy with some date math.

You can find common date routines in here to try to understand them:

http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

First we get the first day of current quarter:

SELECT DATEADD(QQ, DATEDIFF(QQ, 0, GETDATE()),0)

The...

That's like saying you shouldn't write "colour" and should write "color" just because someone said so.

Note that you might replace strings you don't want them to be replaced.

INSERT INTO @test-2(TEST_STRING)

VALUES

('I am a bad Gal')

,('I am a good Gal')

,('Oh my goodness! There''s no more goodwill')

,('He''s...

If you want one column for each benefit, check the following articles about Cross Tabs and Pivots:

Part 1[/url]

Part 2[/url]

CELKO (8/22/2014)

---

I use the encoding that is being used. The IDENTITY property (not a column!) is the count of insertion...

ChrisM@Work (8/22/2014)

---

Cathy DePaolo (8/22/2014)

---

I checked the execution plans of each, and they are the same. I am of the opinion that the subquery is not going to improve performance...

Something as simple as this:

create table test

(flsa_status varchar(30),

bu_dept varchar(30),

reg_temp varchar(5),

ftpt char(2),

value int)

insert into test values ('Exempt Salaried','Corp','Reg','FT',43);

insert into test values ('Exempt Salaried','Corp','Reg','PT',10);

insert into test values ('Exempt Salaried','Corp','Temp','FT',12);

insert into test values...

You're correct, but the principle is the same.

I know you were just having fun, so was I.

I can't relate to the Phineas and Ferb moment. Should I watch more episodes? 😀

Are you mocking my signature? :ermm:

I hope that it can create awareness. :hehe:

How did you test the preformance?

Koen Verbeeck (8/22/2014)

---

I changed my avatar recently.

I re-uploaded it and now...

Hey Eirikur,

You don't even need that function to get the exact same results.

SELECT

*

FROM @TEST T

WHERE T.TEST_STRING LIKE '%good%';

To test if a string is not empty or...

That's when a dynamic query comes handy. I don't have time right now, but this article should help you to get there based on the static sample I posted: http://www.sqlservercentral.com/articles/Crosstab/65048/

Something like this?

create table test

(flsa_status varchar(30),

bu_dept varchar(30),

reg_temp varchar(5),

ftpt char(2),

value int)

insert into test values ('Exempt Salaried','Corp','Reg','FT',43);

insert into test values ('Exempt Salaried','Corp','Reg','PT',10);

insert into test values ('Exempt Salaried','Corp','Temp','FT',12);

insert into test values ('Exempt Salaried','Corp','Temp','PT',2);

SELECT...