GSquared (9/20/2012)

He once explained to me that he acts this way online, because it follows a method of teaching his...

GSquared,

Thanks a lot!

Thanks for taking time to describe situation. I'm surely newbie and will look at Celko's answers to make my own opinion. But now, at least I do...

I'm not a Celko agent =)

Just try to understand =)

Lynn Pettis (9/20/2012)

I simply refuse to provide him any financial gain from any book I may purchase. His total lack of professionalism that he has demonstrated on this (and...

Please, answering to me, take in to consideration I'm a newbie in this forum (do not have personal attitude to anyone). But not a newbie in sql server.

Nope. Not going to taint you with my personal opinions regard Mr. Celko. Too bad he is a co-author with Itzik on a book as I like Itzik's...

Lynn Pettis (9/20/2012)

SomewhereSomehow (9/20/2012)

CELKO (9/20/2012)

don't think you'll scare him. Maybe offend, but not scare. He comes across as one of those borderline sociopathy cases that have very thin skin,...

CELKO (9/20/2012)

don't think you'll scare him. Maybe offend, but not scare. He comes across as one of those borderline sociopathy cases that have very thin skin, but assume everyone...

Offtopic:

Just noticed for myself, that there is a struggle between Eugene Elutin and CELKO, not only in this topic. So my question is what is the point? Yes CELKO is...

If I undestood correctly from desired results, what do you want, is grouping by month?

If so, it might be smth like this:

declare @t table (EID int, AbsenceType varchar(10), AbsenceStartDate datetime, AbsenceEndDate datetime);

insert...

Hi, Paul! Actually, I agree with GilaMonster and you, that there is no so big trouble, if it actually writes to the page in memory or not, but due to...

My five cents to the topic.

I made a simple experiment, created a table like 'create table t1(a int)', inserted one row and updated it with the same value, and with...

Good point!

You may use dynamic query and xp_cmdshell, smth like this:

--be sure you have permissions from DBA, and configured server:

/*

exec sp_configure 'show advanced options', 1

reconfigure with override

exec sp_configure 'xp_cmdshell', 1

reconfigure with...

If your function returns more than 8000, then change its returning type to varchar(max) too.