Hi, Thanks for the reply. I came up with the same idea last night. Hope this works in my real work szenario, because I have a high data volume. Cheers! Stephan

Hi guys, I am trying to figure out how to solve this simple select statement, but somehow I am unable to get it all together. I simplified my problem which is like this. I have a unlimited number of persons and teams. Each person can be a member of one or more teams. I would like to figure out which person is a member of all teams. To make it easier for you to follow here is a SQL snippet to create sample tables and data

create table #person
(
PersonId varchar(2),
Firstname nvarchar(50)
)

create table #member
(
PersonId varchar(2),
TeamId varchar(2)
)

create table #team
(
TeamId varchar(2),
TeamName nvarchar(50)
)

insert into #person values ('P1', 'Wayne');
insert into #person values ('P2', 'Rick');
insert into #person values ('P3', 'Bob');

insert into #team values ('T1', 'Team 1');
insert into #team values ('T2', 'Team 2');
insert into #team values ('T3', 'Team 3');

insert into #member values ('P1', 'T1');
insert into #member values ('P2', 'T1');
insert into #member values ('P2', 'T2');
insert into #member values ('P2', 'T3');
insert into #member values ('P3', 'T3');

drop table #member
drop table #person
drop table #team

The only person in all teams is Rick. Thanks for any kind of help on this matter. Cheers! Byteloser P.S: By the way I am using SQL Server 2005

This was just an example, but yes I subtracted the standard holidays as well. Stephan

Hi Adam, This is a taff topic. I read an article a couple months ago and this guy explained how you can determine an hourly rate. First of all you have to come up with the number how much money you want to make annually. Then you have to figure out how many hours you want to work to make this kind of money. This sounds easier then it is, because you have to consider the hours your are not working productive (e. g. for marketing, accounting, ...) or you are out of work. You can roughly estimate this working hours by calculating the maximum hours per year, subtract your days of vacations you want to have and take something between 60% and 70% from this number. So for example You want to make $100,000 A year has 1,960 hours you could possibly work. You want 10 days of vacations means 1,960 - 80 = 1,880 1,880 - 40% = 1,128 = $88 / hour or 1,880 - 30% = 1,316 = $76 / hour This is just an example and the 1960 hours are not real numbers, but this is pretty much what I did to come up with my hourly rate (which is by the way a lot less then the numbers in this example). I usually give discounts for longer term projects. I came up with something I call a risk factor. As longer I am working on a project as higher the chances to get my annualy income. When I get hired for 12 months I am really competetive with my rates. Hope this helps. Cheers! Stephan

I have short hair because it is so much easier to handle. No brushing or blow-drying is necessary.

Hi Sebastian, This solved my problem - thank you very much. I granted ASP.NET access to the ImageMagick program folder. In addition I had to add ImageMagick to COM+ because after I granted the access I got the error "convert: 410: missing an image file". THANKS A LOT! Cheers! Stephan

I am using ImageMagick in combination with GhostScript to convert PDF files into JPG. Everything works fine on XP or Windows 2000 Systems, but when I uploaded my app to a Virtual Private Server which runs a Windows Server 2003 I get the following error: Retrieving the COM class factory for component with CLSID {5630BE5A-3F5F-4BCA-A511-AD6A6386CAC1} failed due to the following error: 80070005. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {5630BE5A-3F5F-4BCA-A511-AD6A6386CAC1} failed due to the following error: 80070005. ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via , the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user. To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access. Any ideas how I could fix that problem? I googled but couldn't find a solution that works for me :( Thanks Stephan

I moved from Germany to Canada for two years ago. I am self-employed so I have worked most weekends and holidays for the last two years plus a lot of overtime. This year was the first year I took 8 days off for summer vacations. Shouldn't have done that because when I came back I had so much overtime to catch up again. Is it all worth it? Hmmm ... Yes, because I love what I am doing, but I won't do it for a much longer time. Maybe 12 more months and then things should change otherwise I will try to find a job where I get paid vacations. Cheers! Stephan

Maybe you want to try this link: http://balancer.streamfarm.net/tv1/cms/~kosmomusic_wm/kosmomusic/db/1880_video_7275.wmv.asx[^]

Sure. The artist is: Wally Warning The title is: No Monkey Stephan

I was just listening web radio and they played this song (seems to be a big one in Germany): http://www.youtube.com/watch?v=I9IlMO4fujs[^] I love it and it brings me in the right mood for summer :-D Have a nice weekend everybody. Stephan

Remember my early days as a programmer. I had to encrypt and decrypt the name of the licensee (which was stored in a file) for a back-office software used by financial institutes. The name was always printed on top of the financial reports which were handed to their clients. I used a short sentence as encryption base. However, to make a long story short. One licensee manipulated the license file manualy and when he printed a financial report there was written: "Everything has an end. Only a sausage has two" what was my sentence. Gosh I was embarrassed, because a) The sentence and b) I obviously didn't code it proper. However, this days it is kind of funny ;)

Thanks. The difference between borrow and loan is the same in German and that's what I meant with "the Germans usually use the wrong version". Nobody would say "May I loan some eggs?" They always say "May I borrow some eggs?" what is wrong. Arrgg... that's complicated :confused: ... I'll better buy my stuff :)

The germans (I am German by myself) have two or even more words like borrow and lend. However, most of us use the wrong one all the time because it would just sound weired to use the right one. I am curious and because I live in Canada now, I am wondering if my version of it is right: Borrow: For things you will consume or spend (like money, eggs, ...). So you just give back the same amount of the same thing. Lend: You give back exactly the same thing (e. g. the lawn mower, bike, ...). Thanks for clear this one up. Stephan

Sorry for maybe asking a dump question, but are you looking for a partnership? If you are talking about a partnership I think the ownership can't be 50/50, because when it comes to the point to make a decision and you can't get a compromise one of you has to decide. So one of you should own 51% of the company. Talking about money isn't that easy. The company has expenses, right? Are you going to split them the same way? Did you get payed for the work you are doing for this company? If you get paid and the owner has to pay for all the expenses, 50/50 won't be fair. If you don't get payed I guess you have to figure out how much your work is worth and how much he spends for all the other things and how much his work is worth. If it is equal, 50/50 is fair. When it comes to buying out one of the partner (let us call partner A the one who wants to buy the other out), I would suggest that partner B gets the right to give partner A the same amount to buy him out and partner A can't refuse. Arrgs, does this make sense? I will explain what I mean. Your company makes good money (let's say an annual revenue of $500,000) and your partner says "I will buy you out. I will give you $10,000" you should be able to say "No, but I will give you the $10,000 and buy you out" and he can't refuse the offer. This way you will make sure you won't get cheated (especially if he is the money guy). Hope this helps. Stephan

Hi guys, I had some trouble with a hosted SQL Server database because an import of my local backup always failed. During my research I found the following tool and thought I will share it with you - hope it isn't the wrong board :~ SQL Server Hosting Toolkit http://www.codeplex.com/sqlhost[^] The Database Publishing Wizard enables the deployment of SQL Server 2005 databases (both schema and data) into a shared hosting environment on either a SQL Server 2000 or 2005 server. The tool worked fine in my case. Cheers! Stephan

I would really appreciate such an article. Stephan

I did some research before I ordered it and so far couldn't find anything negative about this shop. I first thought it is fake as well (still hope it isn't). However, the setup went through without any problems and the product key was accepted.

Hi guys, Thought this might be interesting for some of you. I just got my VS Studio 2005 Prof. (Full Version) from RoyalDiscount for US $588.51 Shipping within the USA is free, shipping to Canada is US $30. Upps ... almost forgot the link http://www.royaldiscount.com/[^] Cheers! Stephan

code-frog wrote:

An office center? That's called an employer!

The office center wouldn't be an employer. It's just an office you rent with the addition of services you would get like somebody answers the phone e. g. during you are on vacation, a business trip, meeting, ... There would be only IT Pros in the center so you will get a chance to communicate with other IT pros, exchange ideas, ... The best case scenario is that those people help each other with projects they might can't solve by their own.