WHERE RIGHT(column, 1) = '%'

Hi Waykna

There's no ORDER BY clause in the query - so FIRST and LAST will be indiscriminate. In any case, looking at the code, I'm pretty sure that this can...

Thanks Jeff :blush:

Hi Phil

Have you tried server linking with your spreadsheets? You can SELECT, UPDATE and INSERT almost as if it were a native table. There are limitations, but there's always...

Jack Corbett (1/2/2009)

---

I also have to agree with Grant, but in my experience you will rarely be joining enough tables where the order will be important. Also, in my...

dhaval.samaranayeke (1/2/2009)

---

Hi Mr. Chris Morris,

I guess you are taking my sentence all wrong. I am trying to remove gaps within a column which has incremental values and not that of...

jamie.loy (1/2/2009)

---

Wow, that was a quick reply Chris! 🙂

Ok, I am an idiot...I never would have caught that! You are the bomb Chris. Now I will need...

Luke L (1/2/2009)

---

Nice.

Almost everyone who isn't a member of the MS marketing team will continue to complain about Vista (with the sole exception in the whole world probably still being...

jamie.loy (1/2/2009)

---

Nevermind, I don't know why SQL 2000 didnt care about "SELECT DISTINCT" but 2005 does

set objrs = objdb.execute("select DISTINCT * from...

Could be either! It's far from...

Or...

larsosman56 (1/2/2009)

---

Sorry ChrisM. I really didn't give you much to work with. Table 1 has Parent data, and a UDF returns subordinates to the ParentID passed to it. The UDF...

How? Aren't identity columns usually set up with uniqueness?

Why? The sole purpose of an identity column is to...

Hi Preet

Discussion is always good. Taking your points one by one:

i) with Adi's solution, will the DATEPART not be evaluated in any case ? You cannot assume SQL will short...

Hi Phil

For future reference, you will find this exercise a heck of a lot easier if you work with normalised data...

[font="Courier New"]SELECT d.ProductId, d.OrderId, d.ElementNum, x.ElementName, d.CostValue

FROM (SELECT ProductId, OrderId,  

        CAST(number+((BKT-1)*8)...