Edited that query, so if you're looking at it like "Is that guy nuts?", yeah, so was I. Not sure how I got that all messed up =).

INSERT INTO SHOP.shop.dbo.tblPricebook (item, [desc], uom, manid, price, pricegroup, pricegroup_desc, pricegroup_order)

SELECT PBI.item, PBI.[desc], PBI.uom, PBI.manid, PBI.price, PBI.pricegroup, PBI.pricegroup_desc, PBI.pricegroup_order

FROM vwValidPriceBookItems PBI

LEFT JOIN SHOP.shop.dbo.tblPricebook P ON PBI.item = P.item AND...

This is actually the easy part. The harder part will come when you need to convert between the currencies. There are a lot of issues using currency types...

Easiest thing in the world!

Let's say your other table is:

TableSomething

A

B

C

CurrencyID

You'd do this:

SELECT

TS.A,

TS.B,

TS.C,

C.CurrencySign,

C.CurrencyName

FROM TableSomething TS

INNER JOIN tblCurrency C ON TS.CurrencyID = C.CurrencyID

What's the issue with tabs? I kinda hate spaces and normally replace them with tabs (for code formatting anyways). Do tabs cause some problem that I've never come...

karthikeyan (12/12/2008)

---

yes...i have tried your code...

the result is like as below

#1:

Jonny

kamatchi

karthik

kuhan

ravi

#2:

kuhan

ravi

but if i don't have index...or if we dont have ordered result set....what will happen? it leads to wrong result...

I think I saw something about that being deprecated out of SQL in an upcoming release. Can't find the link at the moment though.

If your currency table is set up like this:

tblCurrency

CurrencyID

CurrencySign

CurrencyName

(Don't shoot me for repeating the tablename in every field, or for using tbl in a table name, I'm doing it to...

You can, but doing something like WHERE MONTH(order_date) = 12 is cleaner and faster.

I keep forgetting about the new 2K5 functions. :blush:

Same concept, better implementation. Thanks for the feedback.

To verify, this is for a SQL 2K and not 2K5 database, correct?

Lowell (12/11/2008)

---

these are the once which are both alpha and have numbers: you can decide whether to delete or manually edit from this subset, i guess

select postalcode

from yourtable

--alphanumeric ANDALSO numeric

where...

This should be easily solved by using a running totals method. If you can *add* a column to the table and change the clustered index, you can do it...

Overachiever IMO. You even answer your own questions!

You know, I never really stopped to think about it, but you're right, it doesn't even make commenting out easier. I do think it makes it a little easier...