i t

I'm about to attach my underlay to my 3/4" Advantech. I am unsure about the staples I need to use, or can use. I have an electric staple gun that can shoot 1/2" long 3/8" wide staples. Are these acceptable? Also, on the seams I see a few different recommended gaps sizes. The most common one I see is 1/4" from the wall, 1/8" for the inner seams. Other gap measurement recommendations are 1/8" from the wall and 1/32" in the inner seams. Any advice would be great. By all means I am not an experienced carpenter - I'm just without a lot of money and need my floor down. I'm building a cabin and I barely have enough money to do it myself. I just want to make sure to put it down proper so I don't have to come back in a year and rip it out or reattach it.

I've tried chiseling it for an hour and I feel like it's not going to get it off. I'm no pro chiseler mind you, but I'm curious of how to get this thing off. I'd like to save the lid so that I can later use the septic tank if it's good. I've considered using a little torch I have(those little blue ones) or maybe some paint thinner. I just don't want to blow my self sky high. Although this thing hasn't been used in probably 15-20 years and I'm not sure the last time it was looked at.

I can't understand why they can't hire someone that actually thinks logically and doesn't keep repeating a script. I let them know that I've followed steps a, b, and c...then they tell me to follow steps a, b, and c - over and over. Is there anyone there that can think outside the box? The lady said she wasn't reading from a script, but I can't imagine someone being that stupid. I've once even said hi, my name is .... and then they ask me my name.

Exactly what I asked. Here are two examples. My book says nothing about the queries with dots.

var gradeaverages = db.Grades

.Where(r => r.StudentID == r.StudentID)

.GroupBy(g => g.StudentID, r => r.Grades)

.Select(g => new

{

StudentID = g.Key,

Rating = g.Average()

});

var data = gradeaverages.ToList();

dataGridView1.DataSource = data;

var ordersandcustomers =

from s in db.Students

join g in db.Grades on s.StudentID equals g.StudentID

orderby s.First_Name

select new

{

g.StudentID,

s.First_Name,

s.Last_Name,

g.Grades

};

var data = ordersandcustomers.ToList();

dataGridView1.DataSource = data;

secondly, how can I combine these two queries? I'm having major issues with this.

I had a query that worked nicely with a SQL adapter, but I'm needing it to not be that way, I need to use linq or entities(I'm using the entity framework). I have a contactname from customers, that i need to split and be able to search by last name. my sql query which i thought was wonderful:

("select o.OrderID, c.CompanyName, left(c.ContactName, CHARINDEX(' ', c.ContactName)) as Firstname,substring(c.ContactName, CHARINDEX(' ', c.ContactName)+1, len(c.ContactName)-(CHARINDEX(' ', c.ContactName)-1)) as Lastname, o.OrderDate, o.ShippedDate FROM Customers c JOIN Orders o ON c.CustomerID =o.CustomerID WHERE o.OrderID = @filter ORDER BY c.CompanyName ASC", connection);

Can't be used...I need to do this differently. Any tips? All I'm wanting is to change the contactname into two columns and be able to search by last name.

I have a bit of a problem trying to query a substring. I'm needing to split a ContactName(which I've done) and query the last name part of it. I would like to be able to query it if a person only enters part of the last name (say the user enters an S - it would receive all last names starting with S, OR maybe enter it as Smi - and the query would return Smith and Smithers) is that possible? I currently have a non working query for my last name and this is what I have so far. This is in C#, but I'm using a sqldataadapter.

SqlDataAdapter("select o.OrderID, c.CompanyName, left(c.ContactName, CHARINDEX(' ', c.ContactName)) as Firstname,substring(c.ContactName, CHARINDEX(' ', c.ContactName)+1, len(c.ContactName)-(CHARINDEX(' ', c.ContactName)-1)) as Lastname, o.OrderDate, o.ShippedDate FROM Customers c JOIN Orders o ON c.CustomerID =o.CustomerID WHERE SUBSTRING(c.ContactName,2,10) = @lastNameFilter ORDER BY c.CompanyName ASC", connection);

Hello, I'm trying to sum rows in my database by the ItemID. Is this possible(surely it must be). I think I might be close, but it's not working the way I expected. Basically I want to be able to insert a number for the ID, then the result returns a sum of that said row(which is actually a discount price).

This is what I have so far.

CREATE PROC fnDiscountPrice

(@DiscountPrice decimal OUTPUT,

@ItemID int)

AS

BEGIN

SELECT ItemID, SUM(ItemPrice-DiscountAmount)

FROM OrderItems

GROUP BY ItemID

END

Any help would be great!

I'm having an issue joining two queries(or unioning them) or maybe just making it one big query. I have:

SELECT c.CustomerID, EmailAddress, LastName, FirstName, Line1 AS BillLine1,

Line2 AS BillLine2, City AS BillCity, State AS BillState, ZipCode AS BillZip

FROM Customers c JOIN Addresses ON c.BillingAddressID = Addresses.AddressID

SELECT b.CustomerID, EmailAddress, LastName, FirstName, Line1 AS ShipLine1, Line2 AS ShipLine2, City AS ShipCity, State AS ShipState, ZipCode AS ShipZip

FROM Customers b JOIN Addresses c ON b.ShippingAddressID = c.AddressID;

However, when I use union, it removes the columns from the second select statement that I need(shiplin1, shipline2, shipcity, shipstate, and shipzip). How can I maintain these columns while adding them to the first query??

I've cleared all of my browser history/cookies etc and reinstalled silver light, but it won't work on one of my computers. Any suggestions?

I'm new to Java and honestly what I see when I look at this are methods. I'm not even 100% what to write...I've commented what I think I know to be right, the methods at the top. How would I comment the lines toward the bottom? What am I doing in Java class again? C# is my buddy.

int value;

//constructor

MyInteger(int newValue) { value = newValue; }

// get method that returns value

public int getValue() { return value; }

//returns true if even

public static boolean isEven(int num) { return (num%2 == 0); }

//returns true if odd

public static boolean isOdd(int num) { return !isEven(num); }

//returns true if a prime

public static boolean isPrime(int num) {

for (int f=2; f<num/2; f++) if (num%f==0) return false;

return true;

}

public static boolean isEven(MyInteger n) { return n.isEven(); }

public static boolean isOdd(MyInteger n) { return n.isOdd(); }

public static boolean isPrime(MyInteger n) { return n.isPrime(); }

public boolean isEven() { return isEven(value); }

public boolean isOdd() { return isOdd(value); }

public boolean isPrime() { return isPrime(value); }

public boolean equals(int n) { return (value == n); }

public boolean equals(MyInteger n) { return equals(n.getValue()); }

public static int parseInt(String s) { return Integer.parseInt(s); }

public static int parseInt(char[] s) { return parseInt(new String(s)); }

}

I'm looking to add some interactivity to my videos on my website and need a tool to make non-YouTube videos or similar have interactivity. I don't necessarily want online software that makes me host my files with them either, it costs too much for what I'd be doing. I'd like to be able to create click-able or roller over hotspots that pops up a description of item...the more interactivity the better. Any help or point in the right direction is much appreciated. I haven't done much in video editing so I don't know where to start...Google has sent me to plenty of laughable applications costing well over my limit. My purpose is to make video quizzes that are interactive. I'd prefer software that actually changes the video completely and doesn't require hosting if that makes sense...anyway I'm open to any suggestions even if it's not exactly what I'm looking for.

Okay, so I'm having a bit of trouble finding the answer to this. If for example I have a table that has:

ProductName and DiscountPercent, how do I show the items that do not have duplicates? I don't want to remove duplicates and show those AT ALL. Say If I have a guitar, keyboard, etc etc, and I had discount percents of 1, 2, 15, 30, 1, 2, 15...how could I show the unique value of only 30 with its matching product?

I'm in an area where there aren't any local colleges, and frankly I can't relocate. I'm looking for an online University where I can earn a bachelors in software engineering. What are some schools that aren't over $300 / credit hour and are actually worth going to? Any help is greatly appreciated.

I'm moving from Missouri to Oregon. I will be driving through Oklahoma, Texas, New Mexico, Colorado, Utah, Idaho, and finally to Oregon. I don't have any permits or anything, can I carry a hand gun with me?

I'm looking to figure out how to obtain highspeed internet, it's impossible to get them to get me highspeed where I'm at(i don't want satellite and centurylink sucks in my location). I have the option however, to get a highspeed connection about 5 miles away, through oak trees....is this possible using 900 mhz or 2.4ghz? What would you recommend? I'm in southwest missouri, it's a little hilly, but not really, mostly just trees in the way.

If not, show me an actual academic resource showing me this measurement of pain.

Just curious if you have any solutions that work. I don't need a company's website, I know of plenty that offer hardware etc. I'm looking more or less for some guidelines and general hardware prices. I will use two dsl lines.

I've considered trying to run two dsl lines through a server to accomplish this, but am I wrong for thinking this?

I live in the middle of nowhere, I'm at the max internet speed. I need a solution, I found Mushroom Networks, and I think they can do what I want. I want to essentially double my download speed. How much does this usually cost(other than the doubled internet cost)...I want to be able to play games faster and upload files faster. Do I require the monthly service that is an additional cost from them? Are there cheaper solutions? Also, please don't start telling me it isn't possible to bond a connection on my side, they have gotten it where you CAN. I just need to know how, how much, and best solution for 2 DSL's. I am not currently a business, but I will eventually open a business as well. Mostly it's for gaming. I've already checked out quite a few sites about it, and there are plenty of ignorant people that keep saying it is impossible, but I know better, as does my networking teacher.

How do I cast my fireball?