Hello all, Lets say I have a solution (A) or a project (A) which is working properly and its framework is 2.0. And I have a seperate empty project(B) which is I set its framework to 3.5. When I add my working project(A) to that blank solution what will be my working project's solution? Is it going to be updated to 3.5 automatically from 2.0 to 3.5? If not, changing project (B)'s(-where project (A) is already been added to project (B) ) framework manually from the solution's property window to 4.0 also changes project (A)'s framework as well(will .Net automatically change that project framework)? Thanks in advance

Yeah it is user accessible and easy. I think I will do what you have suggested because it is way cheaper to do it by myself. Thank you very much.

Thank you very much that helped a lot :)

Hello all, I am customizing a new laptop that I am going to purchase. It allows me several different options. The 2 options that I am planning on adding are *16 GB PC3-10600 DDR3 SDRAM 1333MHz SODIMM Memory (4 DIMM) *12 GB PC3-10600 DDR3 (2 DIMM) If I go with 16 GB it is $130 less expensive than the 12 GB. But I can not figure out the difference? Can someone help me out what is the difference between the two and is it worth paying extra $130? Thanks in advance.

Hello Chris, In your first line

select sum(created_count), sum(received_count), sum(closed_count), sum(voided_count) from (

I am having errors in this line for the column names which you placed inside the brackets. For; created_count, received_count, closed_count, voided_count. The error is; invalid column name. In my sql statement I am only looking to the column name rmaNum.

I wrote a query that gets the counts of which has different statuses. The query goes like

SELECT COUNT(rec.rmaNum) as Created
FROM RMARecords rec
LEFT JOIN RMAUsers ucr on ucr.id = rec.userCreated
WHERE rec.rmaStatus = 0
UNION
SELECT COUNT(rec.rmaNum) as Received
FROM RMARecords rec
LEFT JOIN RMAUsers ure on ure.id = rec.userCreated
WHERE (rec.rmaStatus = 1 OR rec.rmaStatus = 2)
UNION
SELECT COUNT(rec.rmaNum) as Closed
FROM RMARecords rec
LEFT JOIN RMAUsers ucl on ucl.id = rec.userCreated
WHERE rec.rmaStatus = 3
UNION
SELECT COUNT(rec.rmaNum) as Voided
FROM RMARecords rec
LEFT JOIN RMAUsers ucl on ucl.id = rec.userCreated
WHERE rec.rmaStatus = 4

The output of this query is; Created ------- 0 1 3 6 I think because of the union the result set comes like this. What I want as output is different Created Received Closed Voided --------/----------/-------/-------- --0-----/-----1----/--3--/----6--- How can I get as a result set like the upper result? Thanks in advance.

I dont know how the heck I found this web site but it got me to my childhood!! Seriously I used to spend hours playing games like that back in 90's.. Link: Atari 2600 Games[^]

There you go. The previous one is here : Bored-Superheros[^]

I have found the solution. The solution is SELECT c.Name, co.Name FROM City C JOIN Country co ON c.ID = ('s' || co.CID)

Yes I have tried but it is not accepting it. When i try it I am getting thois error:

Dynamic SQL Error
expression evaluation not supported
Strings cannot be added or subtracted in dialect 3

Hello all, I dont know it might be an easy thing but i didnt work it around. I have two tables and want to join them. Normally my join statement is as follows:

SELECT c.Name, co.Name
FROM City C
JOIN Country co ON c.ID = co.CID

but this time the columns in the columns in the tables that has relation is similar but with one difference. C.ID = '123' co.CID = 'c123' so how can i join this;

SELECT c.Name, co.Name
FROM City C
JOIN Country co ON c.ID = 'c' + co.CID

something like that :) is it possible? or i need to accomplish what i am trying in two different statements? Thank you very much for your help