Since this forum is for Access and all... Here is an alternate approach that might work. I'm not sure about later versions of Access, but it works for...

Alright, I think I'm on to something. If I open the larger of the two files, the one that was saved to the server folder directly from the save...

lmu92 (1/13/2010)

---

Let's see what I can do...

Using your example, 46(base10) can be written as 101110(base2). Agreed?

Let's start...

lmu92 (1/13/2010)

---

You're very welcome, Greg!

The FOR XML PATH clause is available since 2K5.

I tried to explain how it works here . Not sure if it helps to understand though...

Regarding...

lmu92 (1/13/2010)

---

I would use a function to get the "binary pattern". Something like the following:

CREATE FUNCTION tvf_binarySplit(@a int)

returns TABLE

as

RETURN

SELECT (@a & power(2,n)) val

FROM

(SELECT 1 AS n UNION...

I should note that the post only included inserting 4 options, where the max value of all of them would only be 30, not the 62 used as an example,...

You might find this one easier to look at.

SELECT

cld.*

FROM viewCaseLogDetail cld INNER JOIN

(

SELECT

CaseID

FROM #MyTable

GROUP BY CaseID

HAVING SUM(CASE WHEN CloseDate IS NULL...

I was wondering how long it would take you to realize you still had issues. You indicated you liked the last solution better because you could pull in extra...

cclancy, you could try something like this...

IF OBJECT_ID('TempDB..#projects','u') IS NOT NULL

DROP TABLE #projects

CREATE TABLE #projects

(

ID INT IDENTITY(1,1),

Proj INT,

Color CHAR(10)

)

INSERT INTO #projects

SELECT 100,'Blue' UNION ALL

SELECT 100,'Red' UNION ALL

SELECT 101,'Green' UNION...

You can try something like this...

DECLARE @phonecode VARCHAR(100)

SELECT @phonecode = '54' + CHAR(160)

SELECT LEN(@phonecode)

SELECT @phonecode = REPLACE(@phonecode,CHAR(160),'')

SELECT LEN(@phonecode)

tm3 (12/29/2009)

---

Jeff, much appreciated if you can help me achieve the desire result of a cummulative total by month for the networth table I require.

Hopefully others requiring cummulative totals will...

Jonathan, to elaborate on my last post, here is what I'm talking about...

SELECT

fi_id = MAX(fi.fi_id),

fi.fi_pathname,

fi.fi_username,

fi.fi_permission,

fi.fi_num_locks,

Start = MAX(CASE...

Jonathan Turlington (12/29/2009)

---

Ok maybe I should go about this a different way, because I guess I am not clearly explaining what I need to get done.

An alternative to what I...

Bru Medishetty (12/29/2009)

---

It looks like you have not tested to run the query you posted.

I tried and found few errors. Firstly, the tables do not have Identity Columns so...

Also, your procedure has a BEGIN, and no END. Try putting the END just after the ORDER BY in @SQL2. You may still have errors, but when I...