General

Finding Info for Direct TV Deals and Plans

I really want to switch to Direct Television because from everything that I know about it, it seems like it would be a lot better of an option than what I have at the moment. It is sad that I have been paying too much for my cable for so long and did not really realize how much better the other options were. I did not a bit of searching and found http://www.directstartv.org/ which is a site that I guess has listings of services and the prices of Direct TV.

I am pretty eager to check it out, and I really want to read about all of the different packages closely, so that I can really understand what is going on with them, and what they will include. I don’t think that they are going to be so nice as to tell me what the actual channels are that are included in each package. Although that would certainly be some good information to have.

But it should help me out with a lot of the decision process, and so I am going to get started with this soon. I already told my kids that we were going to get more channels by switching to satellite television, and they were both very excited about it. Too excited really, and they kind of thought it was going to happen instantly, or that I had already made arrangement for the satellite to be installed. When that is not in fact the case, and so now looking back on it, I should have used better judgment and waited until I actually knew when we were going to get it to tell them about it. Or maybe i could have just surprised them with the news as well. That would have worked pretty good, I think so myself.

eteng electronics made a real revolution in the industry of copper foil tape for slug barrier

How We Saved Money on an Electricity Plan That Had Free Electricity in the Evenings

My wife told me, “We need to talk.” Just what a guy wants to hear. She said we would talk over dinner. She told me that by text. I was afraid to ask what it was about! I did not think I did anything. Well, not on purpose anyway. Over barbecued chipped ham, cole slaw and potato chips she said we needed to talk about how much our electric bill was costing. She said it has been going up and up, and it is the priciest utility we are paying. I checked out TXU electricity rate plans with her online later in the evening. We found several at a lower per kilowatt hour rate.

We found one that had a minimum usage rate that met what we use every month. (more…)

Thinking About Dumping My Cable Tv

Cable TV guideThinking about dumping my cable tv, but I am not sure what would be the best thing to do instead. Of course I watch a lot of live sports and that is the thing that really keeps people from cutting the cable on Time Warner and Comcast and those other pirates. Everything else you can get off the internet of you can get you a Digital Video Recorder like the Direct TV Genie and record it, then you play it back and skip through the ads. Obviously that sort of defeats the whole purpose of most tv programs. (more…)

SQL ON

The SQL ON clause is used to create JOIN queries  when information are located in different tables, i.e. allows to join related data tables by specifying a condition that involves a key field that identifies both tables, the key field contains data that is found in the first table and  in the second table, and therefore both tables are related by this key field. Is optional you have these fields defined as a FOREIGN KEY between two tables, what is essential is that there are two fields that have the data to identify the records from both tables.

Following is the general syntax to use the SQL ON clause for  two tables, using the JOIN query:

SELECT fieldNamess FROM table_1 AS one

     JOIN table_2 AS two

     ON one.field = two.field

 

When the type of JOIN (INNER, LEFT, RIGHT) is not specified the default JOIN is INNER JOIN, which returns a record when it meets the condition of the JOIN specified in the operator ON.

In the following example we are using the AdventureWorks database, to get the name of the territory for the customers. The required information is contained in the tables, Sales.Customer and Sales.SalesTerritory, the field that will serve as a JOIN condition is TerritoryID, which will be used in the SQL ON operator. This field will allow us to relate data from both tables. In the table definition, Sales.Customer has a FOREIGN KEY with theSales.SalesTerritory table.

In the result query we will get the ID and customer type as well as the account number  from the Sales.Customer table and the name of the territory from the Sales.SalesTerritory table. The JOIN syntax is as follows:

SELECT  C.CustomerID , C.CustomerType ,C.AccountNumber ,T.Name    FROM Sales .SalesTerritory AS T

INNER JOIN Sales .Customer AS C

ON T.TerritoryID = C.TerritoryID

As we see the INNER JOIN operator is used to mention the second table where we will find the additional information, later in the JOIN condition we use the  SQL ON operator, placing the field that will allow us to join the information from the two tables. In the image we can see the output of the query:

{ 0 comments }

Go to Top