Viewing 15 posts - 211 through 225 (of 621 total)
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 22, 2010 at 9:07 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 19, 2010 at 11:32 am
lmu92 (1/13/2010)
I'm still trying to figure out why it works, but it works.
Let's see what I can do...
Using your example, 46(base10) can be written as 101110(base2). Agreed?
Let's start...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 13, 2010 at 8:08 pm
lmu92 (1/13/2010)
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 13, 2010 at 2:11 pm
lmu92 (1/13/2010)
CREATE FUNCTION tvf_binarySplit(@a int)
returns TABLE
as
RETURN
SELECT (@a & power(2,n)) val
FROM
(SELECT 1 AS n UNION...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 13, 2010 at 1:28 pm
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,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 13, 2010 at 12:20 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 30, 2009 at 1:55 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 30, 2009 at 1:45 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 30, 2009 at 10:36 am
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)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 30, 2009 at 9:12 am
tm3 (12/29/2009)
Hopefully others requiring cummulative totals will...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 30, 2009 at 8:04 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 30, 2009 at 7:37 am
Jonathan Turlington (12/29/2009)
An alternative to what I...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 30, 2009 at 7:13 am
Bru Medishetty (12/29/2009)
I tried and found few errors. Firstly, the tables do not have Identity Columns so...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 29, 2009 at 2:07 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 29, 2009 at 10:25 am
Viewing 15 posts - 211 through 225 (of 621 total)