My two cents in the form of some quick questions:

1) is the budget big enough or do you have to compromise?

2) do you have the resources for...

Luis Cazares (9/4/2014)

---

batgirl (9/4/2014)

---

Lynn Pettis (9/4/2014)

---

Yes, I actually threw one of Mr. Celko's own arguments back at him in a post talking about dates.

I liked the COBOL reference since he...

Solomon Rutzky (9/4/2014)

---

Sean Lange (9/4/2014)

---

Solomon Rutzky (9/4/2014)

---

Eirikur, I completely agree with the statements of "just think how much is going to fail down the line if suddenly NULLs become empty...

Solomon Rutzky (9/4/2014)

---

Jeff Moden (9/3/2014)

---

I guess I'd have to disagree. Nulls mean "Unknown" and it is definitely known that there are no values on either side of the space...

Quick thought, CURDATE() returns the current date in either string or numerical format, the formats being as string 'YYYY-MM-DD' or in numerical if one adds 0 to the function (select...

Quick questions,

1. What Version and Edition of SQL Server are you on (SELECT @@VERSION) ?

2. Do you have a XSD (XML Schema Definition) for the XML date?

Here is a...

Quick thought, use a HEX editor to check for the BOM, Byte Order Mark, at the beginning of the output file. If the correct UTF-8 mark is there then the...

An alternative is to use the ROW_NUMBER function to filter the output

😎

USE tempdb;

GO

;WITH BASE_DATA(Ticket,[User],[Priority]) AS

(SELECT...

Well now you know as you've just made one:-D

😎

gbritton1 (9/3/2014)

---

I'm using the splitter (just downloaded the zip file) and noticed something odd. Dunno if its just me, but check this out:

select * from dbo.[DelimitedSplit8K](' ', ' ')...

Jeff Moden (9/3/2014)

---

Eirikur Eiriksson (8/25/2014)

---

Jeff Moden (8/25/2014)

---

BWAAA-HAAA!!! Me too!

Switching from one delimiter to another is a form of...

polkadot (9/3/2014)

---

thinking about this further, I don't see evidence from my reading, that two different servers can't both point to the same third machine using the same linked server name.

Additionally,...

That of course...

SQLRNNR (9/3/2014)

---

Eirikur Eiriksson (9/3/2014)

---

Alvin Ramard (9/3/2014)

---

Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question...

Spot on! The subject is a...