blandry (5/3/2012)

---

Lynn,

I read the link below your signature with Jeff's recommendations - thats not going to work. First, we are not talking about 1 table - I would have...

Hugo Kornelis (5/3/2012)

---

What bothers me (about the documentation referenced, not about this question) is the relative order of ON and JOIN - how can the ON be processed without first...

cderosier 16389 (3/22/2012)

---

I have installed the 32 bit providers. I get an error when trying to install the 64 bit. It tells me that I have to uninstall the 32...

Near as I can tell PADL seems to be right justifying an nvarchar column.

Essentially it adds a number of characters to the left side of the field and then stick...

sknox (5/1/2012)

---

The problem comes in when you specify some values but leave others at default, as in this scenario, or when you haven't used a feature for a while, and...

The Dixie Flatline (3/15/2012)

---

Don't forget about weekends or holidays. You may want to make reference to a calendar table that defines holidays or weekends, so that you're...

That's pretty cool.... if you write an article about it... try to cover linked servers to this stuff to... Not 100% sure you can do that.... since each file is...

Toreador (5/1/2012)

---

Does anyone have any suggestions for possible uses for sequences? Once upon a time I'd have used them for populating primary keys instead of using identities (ie the way...

marlon.seton (5/1/2012)

---

I think this question indicates that using default values with a new item like CREATE SEQUENCE isn't a great idea. I, for one, will be defining everything (AS,...

Jeff Moden (4/28/2012)

---

I was being generous. I actually prefer 100% stored procedures even if they might take a little longer to develop especially after being burned by the NVARCHAR...

The same question applies. If the quantity determines the number of INSERTs you could cross join to a tally table and insert the values from the first table a...

Is this what you're looking for?

Most of this I stole from Jeff's 0 based splitter...

DECLARE @pstring VARCHAR(8000) = '23,24,25,26'

DECLARE @pdelimiter VARCHAR(1)=','

;WITH E1(N) AS (

...

Thanks for the question, I learned something.... was confused because I hit the same google link that others above did and figured Triple DES was the trick.

Jeff Moden (4/26/2012)

---

It certainly takes a little longer to write but if you want really fast database code, then write database code in the database. If you want to...

Ultimately to sort data, the best solution is still to return it unsorted to the client, and let the client sort it rather than force the database to sort it...