Aim for t' main sail, and go for t' treaaye map, then it be easy

😎

Hany Helmy (9/23/2014)

---

I read the first 2 options, then decided to google it as I have no idea, no previous experience on this, found nothing useful, then went back, read...

Me aim was set on that glorious day, sadly yet anothar broadside missed.

😎

TomThomson (9/24/2014)

---

Given the 6th option, it is extremely obvious what the correct answer is - so thanks for the effortless points.

However I was a little suspiciious about the no transformation...

Try this out for a size. Note, the statement you have doesn't do any formatting, in literal terms it means "convert into smalldatetime from a source that has 101 format.

😎

USE...

Thanks again Eirukur for your efforts and time! Highly appreciated! This part of the code is posing me some problems:

;WITH GuestStay ([ID number],DateOfArrival,DateOfDeparture)

AS (SELECT * FROM (VALUES

...

Here is the same code with the changed name and some explanatory comments. I noticed I had left the month sequence in the other code without using it, no need...

jcrawf02 (9/23/2014)

---

any folks have any favorites other than w3schools.org or stackoverflow for getting newbies started on web design? This is someone who has zero experience, so I made the previous...

Try this for a size

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA ([ID number],DateOfArrival,DateOfDeparture)

AS (SELECT * FROM (VALUES

(2031,'2014-03-20','2014-03-26')

,(1056,'2014-04-29','2014-05-03')

,(3245,'2014-06-19','2014-06-20')...

Simple and maybe not perfect approach is like Luis mentioned, using try_parse. The drawback is that some unwanted values may parse but then again, that might be fine.

😎

;WITH TableA(Col1)

AS (SELECT...

Sorry, made the assumption that you could comment out the unwanted output.

😎

More for fun, here is an alternative "solution", set to return six digits and the decimal separator.

😎

USE tempdb;

GO

SET NOCOUNT ON

/* Generate a set of numbers from 1 to

...

mickyT (9/22/2014)

---

I've had a quick look at this and I suspect while it could be done in T-SQL (painfully and slowly :-D), a CLR function built around your C++ would...

Haven't done Weiszfeld's algorithm in TSQL, would love giving it a go as it is a good example of iterative approach which potentially could be converted into a set based...

Thank you Don for this good question.

😎