Viewing 15 posts - 91 through 105 (of 621 total)
Welsh Corgi (9/26/2012)
You create an accde previously known as an mde to secure the Access Database so that no one can make changes.
Then you create an other mdb for the...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 27, 2012 at 5:03 am
Swath, I don't have access to a server right now, but if you search for PIVOT there are countless examples here, and also on google.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 22, 2012 at 5:48 am
Eugene Elutin (9/21/2012)
BTW, COBOL is still in use across wide range of industries which offer sometimes very lucrative positions and contracts...
Yes, the main application at my company is a series...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 21, 2012 at 6:23 am
aaron.reese (9/13/2012)
yeah, don't use the wizards, learn to programme - it will be quicker in the long run and the next developer will thank you for it.
...and then you will...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 13, 2012 at 2:12 pm
Well, I guess it's safe to say the OP is long gone. Given that he/she posted the problem twice, it must have been pressing. I wonder how it...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 13, 2012 at 2:04 pm
mrwillcostello (9/13/2012)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 13, 2012 at 2:00 pm
Welsh Corgi (9/13/2012)
It has been a while since your last post.So how is your project going?
It's probably overwhelming. I got introduced to SQL Server with an Access project a...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 13, 2012 at 11:32 am
Jeff Moden (9/12/2012)
Greg Snidow (9/11/2012)
The 'id' column in every table was a bit annoying to work with.
It's even more annoying when you need it and it's not there. 😉
Don't overlook...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 12, 2012 at 9:28 am
Ok, I had some free time so I messed with this some more. This one eliminates one of the joins to the pivot table to get the current status....
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 11, 2012 at 3:21 pm
Also...have...to...(fighting it)...agree...with...Celko. The 'id' column in every table was a bit annoying to work with. If you have any ability to provide some input with respect to...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 11, 2012 at 1:07 pm
a4apple (9/11/2012)
Hi, I need to get status names as columns and their respective dates as rows. I know its pivoting, but asking you guys for more insight.Thanks
I think you need...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 11, 2012 at 1:02 pm
ScottPletcher (9/10/2012)
SELECT a, b, c, d, e FROM dbo.table1
is more efficient than:
SELECT a, null, null, null, null FROM dbo.table1 UNION...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 10, 2012 at 8:21 pm
Jeff Moden (9/10/2012)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 10, 2012 at 8:13 pm
ScottPletcher (9/10/2012)
Greg Snidow (9/10/2012)
ScottPletcher (9/10/2012)
The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.
Yep, as I said, I put that...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 10, 2012 at 4:50 pm
ScottPletcher (9/10/2012)
The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.
Yep, as I said, I put that out there for...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 10, 2012 at 4:14 pm
Viewing 15 posts - 91 through 105 (of 621 total)