64 bit might be but I cannot attest to that at all. Have you tried using ODBC setup to see if you can see the Oracle Driver?

I would use Max on the date for the child table and then join to master, however if I need to understand how to determine precendence of the items to...

Unfortunately I am not at work where I can take a look. Send me a private message and I will check my setup tomorrow and see if I can find...

1 - 10/01/2007 - 100.00 - Paym

1 - 10/01/2007 - 100.00 -Int

You state

1 - 10/01/2007 - 100.00 - Paym

is the output, what determines which Paym or Int is the one...

What options did you use. I had to use customer and pick the ole drviers for windows from the oracle client setup.

This is strictly from home.

Some of the motherboards in the last 4 years actually can be polled to determine power consumption. As well, every box I build has only the...

Sorry found a typo this is the corrected version 😀

SELECT

dbo.BINTODEC(SUBSTRING(dbo.HEXTOBIN(0x0A0401E4),28,5)) a,

dbo.BINTODEC(SUBSTRING(dbo.HEXTOBIN(0x0A0401E4),15,13)) b,

dbo.BINTODEC(SUBSTRING(dbo.HEXTOBIN(0x0A0401E4),10,5)) c,

dbo.BINTODEC(SUBSTRING(dbo.HEXTOBIN(0x0A0401E4),5,5)) d

OK combine my HEXTOBIN with Matts BINTODEC functions and you get this as long as you are working with fixed start and stop positions.

SELECT

dbo.BINTODEC(SUBSTRING(dbo.HEXTOBIN(0x0A0401E4),29,4)) a,

dbo.BINTODEC(SUBSTRING(dbo.HEXTOBIN(0x0A0401E4),16,13)) b,

dbo.BINTODEC(SUBSTRING(dbo.HEXTOBIN(0x0A0401E4),11,5)) c,

dbo.BINTODEC(SUBSTRING(dbo.HEXTOBIN(0x0A0401E4),5,5)) d

And if...

I think the first step we have to address here is converting to BITS (one-byte patterns for each HEX value) so I have this

CREATE FUNCTION HEXTOBIN (@valIn varbinary(100))

RETURNS VARCHAR(8000)

AS

BEGIN

DECLARE @valInPos...

Sounds like the time I had to try to translate some mainframe data.

Now

from right to left - first 5 bits equal a, next 13 bits equal b, next 5 bits...

I have to say I have worked with Oracle, 7 and up, SQL Server 6.5 and up, DB2, Sybase SQL Server, MySQL, and a few other lesser ones. All do...

I am trying to figure out then how you make your conversion to binary (from HEX) and determine your starting position. Can you explain your logic a bit more and...

HEX is the same as varbinary, in SQL you can load the value like so and convert to int.

declare @x as varbinary(100)

set @x = 0x00280000

select cast(@x as int)

-- demonstartes you...

SET NOCOUNT ON

DECLARE @A TABLE (A1 int, A2 char(1), A3 int, A4 varchar(10))

DECLARE @b-2 TABLE (B1 int, B2 char(1), B3 varchar(10))

DECLARE @C TABLE (C1 int, C2 varchar(10))

INSERT @A (A1, A2,...

I personnally do not suggestion using query hints (especially within stored objects like SPs and Views) unless you document why you do it and don't forget to let everyone know...