Firstly, Using 8K limited functions will of course truncate larger values, does your production data exceed that limit? Secondly, please comply to Chris's request on DDL, sample and output.

😎

Quick question, do you have the option of...

Quick question, how accurate does this have to be? The reason for asking is that one can do a good approximation using the spatial data type methods and functions, happy...

Quick suggestion, gracefully power down the system, reboot using a good recovery distro such as backtrack, gparted etc., DON'T mount the drives but use dd_rescue to image the drive or...

Quick thought, I've found that using the import/export...

stefan.mulder (9/24/2014)

---

Great stuff!

but as to Jeff's notes on collation: we do need a function that can handle compound delimiters, e.g. [|;] or [","] as in David Data's case of...

A Lorry be a wagon that can carry lots o' gold and precious

😎

You will have no joy thar, they be already walkin' t' plank

You must take it t' t' witchcraft Island, thar be an old beauty thar which has t' power...

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

...