| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
|
02-15-12, 12:11
|
|
Window Washer
|
|
Join Date: Nov 2002
Location: Jersey
Posts: 10,303
|
|
|
|
Great minds think alike...it's 5:00 somewhere
|
|
02-15-12, 13:40
|
|
SQL Server Street Fighter
|
|
Join Date: Nov 2004
Location: Down The Rabbit Hole
Posts: 7,979
|
|
Happy hour is friday and it looks like I am going to have that little young lady from the fifth floor in my face the whole time again. If she won't leave me alone again, I do not care what you guys says about girlz in the workplace, I am taking her back to the cave.
__________________
software development is where smart people go to waste their lives
|
|
02-15-12, 14:07
|
|
Window Washer
|
|
Join Date: Nov 2002
Location: Jersey
Posts: 10,303
|
|
|
|
02-16-12, 10:44
|
|
vaguely human
|
|
Join Date: Jun 2007
Location: London
Posts: 2,519
|
|
Hey guys, any idea where I'd post regards a Sage 200 system? I'm supposed to be helping a friends company with some reports but can't find too much info on the damn thing (what type of server? table structure? pricing tables? is there a reporting interface etc).
Is everyone well? Things very very, slow over here in the UK (for me anyway).
|
|
02-16-12, 11:18
|
|
Resident Curmudgeon
|
|
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
|
|
Sage 200 is a CRM system that works with MAS 90. If that's what you're looking at, the database engine is Microsoft SQL, and I think it is SQL 2005 Standard Edition but I'm not certain of that.
-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
|
|
02-16-12, 11:45
|
|
vaguely human
|
|
Join Date: Jun 2007
Location: London
Posts: 2,519
|
|
So all I need is just the login details to the database and I'm away? Is the table structure simple to work? do you know if there's a ER diagram on the web anywhere? Is there a way to add new reports into the system smoothly or would I just code up a new program to access it. I'll admit it's not my type of work but hey-ho.
How are things going by the way? Is everyone well? Any changes? Have Poots or George resurfaced?
|
|
02-16-12, 11:52
|
|
Window Washer
|
|
Join Date: Nov 2002
Location: Jersey
Posts: 10,303
|
|
work????
In the corral???
You, sir, will be shot
:d
|
|
02-16-12, 12:08
|
|
SQL Server Street Fighter
|
|
Join Date: Nov 2004
Location: Down The Rabbit Hole
Posts: 7,979
|
|
bitching about work is still allowed, right? the department lost 3 managers in 2 weeks. I have already made my disinterest clear. crazytown is about to turn into insanity city.
__________________
software development is where smart people go to waste their lives
|
|
02-16-12, 12:19
|
|
Window Washer
|
|
Join Date: Nov 2002
Location: Jersey
Posts: 10,303
|
|
LinSanity
And I don't even Like Basketball (NBA)
Now there this is a kid who's not a thug...that might change
|
|
02-16-12, 12:37
|
|
Resident Curmudgeon
|
|
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
|
|
Quote:
Originally Posted by mike_bike_kite
So all I need is just the login details to the database and I'm away? Is the table structure simple to work? do you know if there's a ER diagram on the web anywhere? Is there a way to add new reports into the system smoothly or would I just code up a new program to access it. I'll admit it's not my type of work but hey-ho.
|
Once upon a while ago I conjoured up a helpfile for the Sage 200 structure using SQL Spec. I don't think that I still have that file, and if I do it is on a DVD somewhere. If you don't know SQL Spec, you REALLY need to take an hour or two to play with it because the data dictionary help files it can build are worth Jezemine's weight in gold!
Quote:
Originally Posted by mike_bike_kite
How are things going by the way? Is everyone well? Any changes? Have Poots or George resurfaced?
|
I'm still busier than the proverbial "one armed paper hanger, in a wind storm" between clients, family, etc.
George surfaces occasionally. He's apparently a busy, busy boy these days having a grand time with all of the loves in his life (one of which is almost entirely rebuilt now).
Poots doesn't love us anymore. I don't even get perverse emails from him these days!
-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
|
|
02-16-12, 12:46
|
|
Resident Curmudgeon
|
|
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
|
|
Quote:
Originally Posted by Brett Kaiser
You, sir, will be shot
|
Very cool! Shot out of what???
-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
|
|
02-16-12, 13:05
|
|
Window Washer
|
|
Join Date: Nov 2002
Location: Jersey
Posts: 10,303
|
|
Tequila..what else...
Although a snifter of McCallahan 25 year old wouldn't be too bad
|
|
02-16-12, 14:36
|
|
SQL Server Street Fighter
|
|
Join Date: Nov 2004
Location: Down The Rabbit Hole
Posts: 7,979
|
|
Quote:
Originally Posted by Brett Kaiser
Tequila..what else...
Although a snifter of McCallahan 25 year old wouldn't be too bad
|
yep. I have been denying myself single malts lately, but the little sister got me a bottle of the 15 year old glen livet french oak reserve for my birthday. I keep trying to say I am going to save for it company, but I have had one each night this week....
__________________
software development is where smart people go to waste their lives
|
|
02-16-12, 14:51
|
|
Purveyor of Discontent
|
|
Join Date: Mar 2003
Location: The Bottom of The Barrel
Posts: 6,075
|
|
Quote:
Originally Posted by Thrasymachus
yep. I have been denying myself single malts lately, but the little sister got me a bottle of the 15 year old glen livet french oak reserve for my birthday. I keep trying to say I am going to save for it company, but I have had one each night this week....
|
Glen livet is my usual go-to. Not familiar with the 15 year french oak reserve... Sounds like it's worth seeking out.
|
|
02-16-12, 16:22
|
|
SQL Server Street Fighter
|
|
Join Date: Nov 2004
Location: Down The Rabbit Hole
Posts: 7,979
|
|
It's pretty good. It is just a little more expensive than the standard 12 year old. I want to say it might be a tad smoother and sweeter. The only thing my brother in law ever gift eachother is liqour. Each christmas and birthday like clockwork.
George hit me up on fakebook the other month. I think the Flump is lost to us all and with them probably Healdem. No more transatlantic alliance.
__________________
software development is where smart people go to waste their lives
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
Olde Corral
