Not sure we'll be able to help you by close of business but I have a concern. I know substring is the core function and left/right are just wrappers,...

It does J, thanks. It shows that even though you got huge outliers just like above, the ratios stayed...

Calibear (4/29/2013)

---

Evil, for us old timies that still work on sql 2005 most of the time, the Year() might not have been the first thing that came to mind. ...

ChrisM@Work (4/30/2013)

---

Test 1, Test 2 and Test 3 are slight variations of the base code, since the performance difference isn't particularly significant I'll not post unless someone requests.

Notice how much...

Appreciate the time Mark. Would you be willing to rerun with the harness in the fourth post? After Mr. Magoo brought...

Because of Mr. Magoo's confusion as to my use case, I want to present an idea of the use case. It's not the one in question but that's a...

mister.magoo (4/29/2013)

---

Evil Kraig F (4/29/2013)

---

No table variables here, just a plain simple variable to accept the values from the select and dump them - look again :w00t: (sometimes referred to...

mister.magoo (4/29/2013)

---

You will see I have moved the CASE N%4 ... statement into the test data generator, and swapped the syscolumns cross joins for VALUES cross joins as it is...

Grant Fritchey (4/29/2013)

---

True. If you don't need those joins, you're better off writing the query without them. But, if we are getting down to the point where people have properly...

Slightly confused, does this not work?

SELECT

YEAR( Enter_Date) AS yr,

MIN( C_Key) AS MinKey,

MAX( C_Key) AS MaxKey

FROM

Sometable

GROUP BY

Year( Enter_Date)

Hey guys, asking for a bit of guru inpsection over on this thread I just created:

http://www.sqlservercentral.com/Forums/Topic1447802-392-1.aspx

Basically it's a test harness to try to figure out the most optimal approach to...

I'd like to mention here that typically when encrypting like this you store the data one place, the keys in another.

In general I'd have the N-Tier control the encrypt/decrypt, and...

john.p.lantz (4/26/2013)

---

I will look the suggestions. But let me explain our situation a little more. All updates are done to the tables - not the views. So...

SQLKnowItAll (4/26/2013)

---

Thanks for the replies. We will test both, of course. I was against the idea at first because of my feelings on changing a perfectly good set-based...

Jared, something else you might think of using is an in-database broker queue, which allows you to queue up asynchronous updates like this and have a built in wrapper for...