quote:

---

Originally posted by chadmat

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=179717

---

quote:

---

Originally posted by TG

This isn't directed at anyone in particular but I am amazed at how many people seem to have absolutely no problem solving common sense.
For instance:
- syntax errors with dynamic sql and have never thought to print the command.
- multi statement process that fails "somewhere" and never thinks of a way to track what succeeded and what didn't.
- etc...

Has there always been developers can't think for themselves or is this a modern phenomenon caused by smart-phones and google?

Be One with the Optimizer
TG

---

quote:

---

Originally posted by nigelrivett

>> Working through a solution step by step, to make sure each part of the process works before moving onto the next one

Nice in theory but inflexible and unlikely to succeed in anything but the simplest cases. Means if you are waiting for something for one step you sit around doing nothing rather than working on things further down the line. Also later steps might affect what needs to be done in earlier steps so often all need to be dealt with in parallel.
I would say you should teach people to concentrate on high risk areas first but always consider the whole system.

---

quote:

---

Originally posted by DonAtWork

wow. move the goalposts much?

Tool: Dates before 1900? IMPOSSIBLE!
signed, MS SQL MVP MCP MSCSZQX12 98 !!!!

Reasonable person: List all US presidents and dates in office.

Tool: FINE then anything before 1753 is silly too! SO THERE!
signed, MS SQL MVP MCP MSCSZQX12 98 !!!!


How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

---

quote:

---

Originally posted by robvolk

Just out of curiosity, what about date and datetime2?

Wonder if he knows why 1753 was the original cutoff.

---

select
	a.DT,
	LastDayofMonth =
	dateadd(mm,datediff(mm,convert(date,'00011231'),a.DT),convert(date,'00011231')),
	LastSundayofMonth = 
	dateadd(dd,(datediff(dd,convert(date,'00010107'),
	dateadd(mm,datediff(mm,convert(date,'00011231'),a.DT),convert(date,'00011231'))
	)/7)*7,convert(date,'00010107'))
from
	( -- Test data
	select DT = convert(date,'00010101') union all
	select DT = convert(date,'99991231') union all
	select DT = convert(date,getdate()) union all
	select DT = convert(date,dateadd(mm,-2,getdate())) union all
	select DT = convert(date,dateadd(mm,-1,getdate())) union all
	select DT = convert(date,dateadd(mm,1,getdate())) union all
	select DT = convert(date,dateadd(mm,2,getdate())) union all
	select DT = convert(date,dateadd(mm,3,getdate())) union all
	select DT = convert(date,dateadd(mm,4,getdate())) union all
	select DT = convert(date,dateadd(mm,5,getdate())) union all
	select DT = convert(date,dateadd(mm,6,getdate())) union all
	select DT = convert(date,dateadd(mm,7,getdate())) union all
	select DT = convert(date,dateadd(mm,8,getdate())) union all
	select DT = convert(date,dateadd(mm,9,getdate())) union all
	select DT = convert(date,dateadd(mm,10,getdate())) union all
	select DT = convert(date,dateadd(mm,11,getdate()))
	) a
order by
	a.DT

DT         LastDayofMonth LastSundayofMonth
---------- -------------- -----------------
0001-01-01 0001-01-31     0001-01-28
2012-12-13 2012-12-31     2012-12-30
2013-01-13 2013-01-31     2013-01-27
2013-02-13 2013-02-28     2013-02-24
2013-03-13 2013-03-31     2013-03-31
2013-04-13 2013-04-30     2013-04-28
2013-05-13 2013-05-31     2013-05-26
2013-06-13 2013-06-30     2013-06-30
2013-07-13 2013-07-31     2013-07-28
2013-08-13 2013-08-31     2013-08-25
2013-09-13 2013-09-30     2013-09-29
2013-10-13 2013-10-31     2013-10-27
2013-11-13 2013-11-30     2013-11-24
2013-12-13 2013-12-31     2013-12-29
2014-01-13 2014-01-31     2014-01-26
9999-12-31 9999-12-31     9999-12-26

select
	a.DT,
	LastDayofMonth = 
	dateadd(mm,datediff(mm,convert(datetime2,'00011231'),a.DT),convert(datetime2,'00011231')),
	LastSundayofMonth = 
	dateadd(dd,(datediff(dd,convert(datetime2,'00010107'),
	dateadd(mm,datediff(mm,convert(datetime2,'00011231'),a.DT),convert(datetime2,'00011231'))
	)/7)*7,convert(datetime2,'00010107'))
from
	( -- Test data
	select DT = convert(datetime2,'00010101') union all
	select DT = convert(datetime2,'99991231') union all
	select DT = convert(datetime2,getdate()) union all
	select DT = convert(datetime2,dateadd(mm,-2,getdate())) union all
	select DT = convert(datetime2,dateadd(mm,-1,getdate())) union all
	select DT = convert(datetime2,dateadd(mm,1,getdate())) union all
	select DT = convert(datetime2,dateadd(mm,2,getdate())) union all
	select DT = convert(datetime2,dateadd(mm,3,getdate())) union all
	select DT = convert(datetime2,dateadd(mm,4,getdate())) union all
	select DT = convert(datetime2,dateadd(mm,5,getdate())) union all
	select DT = convert(datetime2,dateadd(mm,6,getdate())) union all
	select DT = convert(datetime2,dateadd(mm,7,getdate())) union all
	select DT = convert(datetime2,dateadd(mm,8,getdate())) union all
	select DT = convert(datetime2,dateadd(mm,9,getdate())) union all
	select DT = convert(datetime2,dateadd(mm,10,getdate())) union all
	select DT = convert(datetime2,dateadd(mm,11,getdate()))
	) a
order by
	a.DT

DT                     LastDayofMonth         LastSundayofMonth
---------------------- ---------------------- ----------------------
0001-01-01 00:00:00.00 0001-01-31 00:00:00.00 0001-01-28 00:00:00.00
2012-12-13 23:15:29.31 2012-12-31 00:00:00.00 2012-12-30 00:00:00.00
2013-01-13 23:15:29.31 2013-01-31 00:00:00.00 2013-01-27 00:00:00.00
2013-02-13 23:15:29.31 2013-02-28 00:00:00.00 2013-02-24 00:00:00.00
2013-03-13 23:15:29.31 2013-03-31 00:00:00.00 2013-03-31 00:00:00.00
2013-04-13 23:15:29.31 2013-04-30 00:00:00.00 2013-04-28 00:00:00.00
2013-05-13 23:15:29.31 2013-05-31 00:00:00.00 2013-05-26 00:00:00.00
2013-06-13 23:15:29.31 2013-06-30 00:00:00.00 2013-06-30 00:00:00.00
2013-07-13 23:15:29.31 2013-07-31 00:00:00.00 2013-07-28 00:00:00.00
2013-08-13 23:15:29.31 2013-08-31 00:00:00.00 2013-08-25 00:00:00.00
2013-09-13 23:15:29.31 2013-09-30 00:00:00.00 2013-09-29 00:00:00.00
2013-10-13 23:15:29.31 2013-10-31 00:00:00.00 2013-10-27 00:00:00.00
2013-11-13 23:15:29.31 2013-11-30 00:00:00.00 2013-11-24 00:00:00.00
2013-12-13 23:15:29.31 2013-12-31 00:00:00.00 2013-12-29 00:00:00.00
2014-01-13 23:15:29.31 2014-01-31 00:00:00.00 2014-01-26 00:00:00.00
9999-12-31 00:00:00.00 9999-12-31 00:00:00.00 9999-12-26 00:00:00.00

quote:

---

Originally posted by James K

Along the same lines: my wife is a fan of Jane Austen (1775-1817). I recently set up a database for her to track all kinds of information relating to the period, in her quest to write a "Pride and Prejudice" variation. For those who are not as devoted to Jane Austen as my wife is, "Pride and Prejudice" is Jane Austen's most famous work, and several variations of that book have been written by a number of authors. All the dates of course are in the late 18th and early 19th century.

And speaking of wives and special women in our lives, "Happy Valentine's day to all!!"

---

quote:

---

She could update Pride and Prejudice into the modern age or near future as a cyberpunk novel and avoid all those dates before 1900 that no one should ever use.

---