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.

😎

Steve Jones - SSC Editor (9/22/2014)

---

There was no chance to get the log...

Handful of posts missing, did you break the log chain;-)

😎

There are some other topics missing, some points also went missing, all happened more or less at the same time.

😎

Not certain what is causing the problem, nothing in the code should limit the length apart from the maximum 2Gb limit of the varchar(max). Consider the following example

😎

GO

SET NOCOUNT ON;

/*...

Thank you Gail for this nice piece!

It in fact highlights a constant battle, challenging pinhole view, missing metrics, personal opinions etc., things which far to often, but wrongly, drive optimization...

serg-52 (9/22/2014)

---

abhas (9/18/2014)

---

Yes Erirukar,

There are more rows for CanNum as below: and in such case its failing. I want to compare only latest two.

I can Add one more column into...