simple steps:

After importing the both Tables! Create new query in SQL mode:

SELECT * FROM TABLE1

UNION ALL

SELECT * FROM TEBLE2

Save it as Union_all

then

Start new query also in SQL Mode then...

OK! Make third MS Access file then import the both tables from both DB. After that go to querys and open new query in SQL mode then write:

SELECT * FROM...

Yes...You can open the MS Access 2003 DB in MS Access 2007 or you can create the DB in MS Access 2007 then save it as MS Access 2003!

You have...

Your Primary Keys are Autonumber in both DB or other datatype!?

The function above is very stable for converting from Hex to BigInt and I suggest to use the function, just the n_parker should know how to use it - also...

Are you sure that the substring function retrieves correct what do you want also the left function!

%_SOFTWARE_% - is this the column of the table or just the value as...

Lynn Pettis (1/7/2009)

---

anam (1/7/2009)

---

Can't find any explanation behind it. Can anybody please explain me why the results of two select statements are same. I wasn't expecting same results from both...

anam (1/7/2009)

---

Can't find any explanation behind it. Can anybody please explain me why the results of two select statements are same. I wasn't expecting same results from both of these...

OR

Try something like this:

SELECT DATE

SUM(CASE WHEN LUN = 'LUN1' THEN VALUE ELSE 0 END) AS LUN1,

SUM(CASE WHEN LUN = 'LUN2' THEN VALUE ELSE 0 END) AS LUN2,

.

. ( OTHER...

After you create the funstion you will see your results for the example that you give above:

declare @sw1 VARCHAR(2)

set @sw1 = left('16.04.01',2)

declare @sw2 VARCHAR(2)

set @sw2 = substring('16.04.01',4,2)

declare @sw3 VARCHAR(4)

set...

n_parker (1/7/2009)

---

The value I'm expecting with the cast statement should be '5636' (converting 1604 from hex to dec)

But it keeps inserting '1604' into the table. I can't get it...

Hmmm... your code here works just fine...or maybe I'm not understand you request here!

Anyway try with NVARCHAR data type in your table to store the version number in yourtable then...

No it doesn't work, because I'm using here CROSS Apply which is not supported both versions of SQL (7...

And already this is the wrong section...please read the board carefully before posting!

patilharshalv (11/17/2008)

---

HI

SQL2005 is started but SQL Server Analysis Services is giving this error

Message: The service cannot be started: Errors related to feature availability and configuration: SQL Server Analysis...