Hi,
I want to get a DTE object for an arbitrary solution file and not just the one currently loaded in Visual Studio. Is this possible?
Best regards,
Christian
chribben
Last Activity: Nov 19 '08, 08:29 PM
Joined: Feb 10 '08
Location:
-
How to get DTE for arbitrary solution?
-
Got an answer from msdn: http://forums.microsoft.com/msdn/Sho...iteID=1&mode=1... -
I tried that as well, same result - only 64 kb is printed....Leave a comment:
-
Copying data in SQL Management Studio
Hi,
I want to copy the data from a cell in the result view of SQL Management Studio after running a query. So I right click the cell and select Copy and then paste it into a text file. But the pasted data is only 64 kb while SQL Management Studio states that it is 90 kb (using the datalength function). How can this be and what should I do to get all the data from the cell?
Best regards,
Christian -
Yes, that is correct.
/Chris...Leave a comment:
-
Counting rows part II
Hi,
I have the following query:
1. SELECT products.name, COUNT(reviews.r eview)
2. FROM (select distinct name from products) products
3. FULL JOIN reviews ON products.name = reviews.product name
4. GROUP BY products.name
which lists product names and the number of reviews for each product. I need to include one more column from the products table in the table resulting from the above query. This... -
Using FULL JOIN, worked like a charm! Thanks a lot!
/Chris...Leave a comment:
-
Because then the products that have zero reviews won't be listed and I need to include them as well.
/Chris...Leave a comment:
-
Doesn't work either, see post above.
/Chris...Leave a comment:
-
Doesn't matter if I use DISTINCT since I'm grouping by product name.
If I have product table like this:
Name
=======
ProductA
ProductA
ProductA
ProductB
ProductC
...and a review table like this:
Prod_name Review
======== =====
ProductA bla bla
ProductA bla bla
ProductB bla bla
The joined table will be:
Product...Leave a comment:
-
Yes, each entry has a guid like so:
GUID Name
==== ====
0x01 ProductA
0x02 ProductB
0x03 ProductA
0x04 ProductC
/Chris...Leave a comment:
-
Counting rows
Hello!
I have two tables; one containing product names and one with reviews of the products. What I'd like to do is present a table with the product names and number of reviews. The thing is that there can be more than one entry of a certain product in the products table. When I write something like:
SELECT products.name, COUNT(reviews.r eview)
FROM products
JOIN reviews ON products.name = reviews.product name
... -
Great! Thanks a lot.Leave a comment:
-
Subtracting grouped counts
Hello!
I have two COUNT-queries that I which to subtract. The first query is like:
SELECT winner, COUNT(winner)
FROM my_table
GROUP BY winner
The second is like:
SELECT contributor, COUNT(contribut or)
FROM my_table
GROUP BY contributor
The first query returns two columns with values (John, Jane);(2,3) and the second returns (John,Jane,Jack );(1,1,3). Now I want...
No activity results to display
Leave a comment: