Computing desk | ||
---|---|---|
< November 20 | << Oct | November | Dec >> | November 22 > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
I am using AVG 2012, but it won't remove it completely, what can I do? What program can I get to remove it? I don't have any money, so it would have to be free. Luciferwildcat ( talk) 00:22, 21 November 2011 (UTC)
Lucifer, that is just a website trying to get you to click a button. ¦ Reisio ( talk) 07:26, 21 November 2011 (UTC)
If I have firefox, how can I check for updates? And is spybot and microsoft security essentials free? And where can I download them? — Preceding unsigned comment added by Luciferwildcat ( talk • contribs) 09:12, 21 November 2011 (UTC)
Malwarebytes and SUPERAntiSpyware are also worth using if the previous tools don't get rid of it. Alternatively, you could install ubuntu and probably not need any AV software SmartSE ( talk) 12:28, 21 November 2011 (UTC)
My Wifi connection gets lost every 1 minute (and reconnects within seconds). I don't know exactly where the problem is. How can I reinstall everything related to the wifi? (in Ubuntu). Quest09 ( talk) 15:15, 21 November 2011 (UTC)
Where should I start to get A+ certified? I have a degree in computer science so many of the topics will be easy for me. Magog the Ogre ( talk) 16:55, 21 November 2011 (UTC)
I have a database with a structure like this:
Table1UID Identity Date Value 00001 ABC 01.01.2011 43 00002 DEF 02.01.2011 28 00003 GHI 05.01.2011 37 00004 ABC 05.01.2011 49 00005 JKL 08.01.2011 28 00006 GHI 09.01.2011 40 00007 ABC 12.01.2011 42 00008 MNO 23.01.2011 31
The Table1UID is unique, while the "Identity" field is non-unique. I want to make a selection that collects all (or at least several, see below) occurrences of the same "Identity" in the same row of the selection.
Identity Table1UID1 Date1 Value1 Table1UID2 Date2 Value2 Table1UID3 Date3 Value3 ABC 00001 01.01.2011 43 00004 05.01.2011 49 00007 12.01.2011 42 DEF 00002 02.01.2011 28 NA NA NA NA NA NA GHI 00003 05.01.2011 37 00006 09.01.2011 40 NA NA NA JKL 00005 08.01.2011 28 NA NA NA NA NA NA MNO 00008 23.01.2011 31 NA NA NA NA NA NA
I suppose I may have to put a limit to how many items I want to combine; say I want to collect the values corresponding to the first, the last, and the "middle" Table1UID (whichever way "middle" is easiest implemented). Is it possible to do this with SQL SELECT, and if so, how? I'm using Microsoft Access (ancient version), but could switch to MySQL if that makes it easier. Thanks, - NorwegianBlue talk 19:41, 21 November 2011 (UTC)
DECLARE @Table1 TABLE(Table1UID INT, [Identity] VARCHAR(100), [Date] DATE, Value INT); INSERT @Table1 VALUES (1, 'ABC', '2011/01/01', 43), (2, 'DEF', '2011/01/02', 28), (3, 'GHI', '2011/01/05', 37), (4, 'ABC', '2011/01/05', 49), (5, 'JKL', '2011/01/08', 28), (6, 'GHI', '2011/01/09', 40), (7, 'ABC', '2011/01/12', 42), (8, 'MNO', '2011/01/23', 31); WITH CTE1 AS ( SELECT col = ROW_NUMBER() OVER(PARTITION BY [Identity] ORDER BY Table1UID), * FROM @Table1 ) SELECT C1.[Identity], Table1UID1 = C1.Table1UID, Date1 = C1.[Date] , Value1 = C1.Value, Table1UID2 = C2.Table1UID, Date2 = C2.[Date] , Value2 = C2.Value, Table1UID3 = C3.Table1UID, Date3 = C3.[Date] , Value3 = C3.Value FROM CTE1 C1 LEFT JOIN CTE1 C2 ON C2.[Identity] = C1.[Identity] AND C2.col = 2 LEFT JOIN CTE1 C3 ON C3.[Identity] = C1.[Identity] AND C3.col = 3 WHERE C1.col = 1 ORDER BY C1.[Identity];
Identity | Table1UID1 | Date1 | Value1 | Table1UID2 | Date2 | !Value2 | Table1UID3 | Date3 | Value3 |
---|---|---|---|---|---|---|---|---|---|
ABC | 1 | 2011-01-01 | 43 | 4 | 2011-01-05 | 49 | 7 | 2011-01-12 | 42 |
DEF | 2 | 2011-01-02 | 28 | NULL | NULL | NULL | NULL | NULL | NULL |
GHI | 3 | 2011-01-05 | 37 | 6 | 2011-01-09 | 40 | NULL | NULL | NULL |
JKL | 5 | 2011-01-08 | 28 | NULL | NULL | NULL | NULL | NULL | NULL |
MNO | 8 | 2011-01-23 | 31 | NULL | NULL | NULL | NULL | NULL | NULL |
I need to do a one-time conversion of a 7-second animated gif to flv. I have Photoshop and Roxio, but they don't seem to do it. I downloaded two free programs, but neither would do it without paying. (Well one wouldn't do anything and the other put words over it and the image was slanted 45 degrees.)
Is there an easy, no-cost way to do this for one time for a small GIF? Bubba73 You talkin' to me? 22:30, 21 November 2011 (UTC)
The file is for a student art contest. The student made a 7-second GIF animaton that won at the county level. Now it is to go to the state level, but the state requires flv. The student doesn't know how to make it an flv. My wife is coordinating it at the local level and sending the local winners on to the state competition. She asked me to convert it from GIF to FLV. I've spent about an hour and a half, I can't do it, so I have to give up. Bubba73 You talkin' to me? 04:11, 22 November 2011 (UTC)
FLV sent. ¦ Reisio ( talk) 06:33, 22 November 2011 (UTC)
You guys should check out VLC sometime. ¦ Reisio ( talk) 18:29, 22 November 2011 (UTC)
Computing desk | ||
---|---|---|
< November 20 | << Oct | November | Dec >> | November 22 > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
I am using AVG 2012, but it won't remove it completely, what can I do? What program can I get to remove it? I don't have any money, so it would have to be free. Luciferwildcat ( talk) 00:22, 21 November 2011 (UTC)
Lucifer, that is just a website trying to get you to click a button. ¦ Reisio ( talk) 07:26, 21 November 2011 (UTC)
If I have firefox, how can I check for updates? And is spybot and microsoft security essentials free? And where can I download them? — Preceding unsigned comment added by Luciferwildcat ( talk • contribs) 09:12, 21 November 2011 (UTC)
Malwarebytes and SUPERAntiSpyware are also worth using if the previous tools don't get rid of it. Alternatively, you could install ubuntu and probably not need any AV software SmartSE ( talk) 12:28, 21 November 2011 (UTC)
My Wifi connection gets lost every 1 minute (and reconnects within seconds). I don't know exactly where the problem is. How can I reinstall everything related to the wifi? (in Ubuntu). Quest09 ( talk) 15:15, 21 November 2011 (UTC)
Where should I start to get A+ certified? I have a degree in computer science so many of the topics will be easy for me. Magog the Ogre ( talk) 16:55, 21 November 2011 (UTC)
I have a database with a structure like this:
Table1UID Identity Date Value 00001 ABC 01.01.2011 43 00002 DEF 02.01.2011 28 00003 GHI 05.01.2011 37 00004 ABC 05.01.2011 49 00005 JKL 08.01.2011 28 00006 GHI 09.01.2011 40 00007 ABC 12.01.2011 42 00008 MNO 23.01.2011 31
The Table1UID is unique, while the "Identity" field is non-unique. I want to make a selection that collects all (or at least several, see below) occurrences of the same "Identity" in the same row of the selection.
Identity Table1UID1 Date1 Value1 Table1UID2 Date2 Value2 Table1UID3 Date3 Value3 ABC 00001 01.01.2011 43 00004 05.01.2011 49 00007 12.01.2011 42 DEF 00002 02.01.2011 28 NA NA NA NA NA NA GHI 00003 05.01.2011 37 00006 09.01.2011 40 NA NA NA JKL 00005 08.01.2011 28 NA NA NA NA NA NA MNO 00008 23.01.2011 31 NA NA NA NA NA NA
I suppose I may have to put a limit to how many items I want to combine; say I want to collect the values corresponding to the first, the last, and the "middle" Table1UID (whichever way "middle" is easiest implemented). Is it possible to do this with SQL SELECT, and if so, how? I'm using Microsoft Access (ancient version), but could switch to MySQL if that makes it easier. Thanks, - NorwegianBlue talk 19:41, 21 November 2011 (UTC)
DECLARE @Table1 TABLE(Table1UID INT, [Identity] VARCHAR(100), [Date] DATE, Value INT); INSERT @Table1 VALUES (1, 'ABC', '2011/01/01', 43), (2, 'DEF', '2011/01/02', 28), (3, 'GHI', '2011/01/05', 37), (4, 'ABC', '2011/01/05', 49), (5, 'JKL', '2011/01/08', 28), (6, 'GHI', '2011/01/09', 40), (7, 'ABC', '2011/01/12', 42), (8, 'MNO', '2011/01/23', 31); WITH CTE1 AS ( SELECT col = ROW_NUMBER() OVER(PARTITION BY [Identity] ORDER BY Table1UID), * FROM @Table1 ) SELECT C1.[Identity], Table1UID1 = C1.Table1UID, Date1 = C1.[Date] , Value1 = C1.Value, Table1UID2 = C2.Table1UID, Date2 = C2.[Date] , Value2 = C2.Value, Table1UID3 = C3.Table1UID, Date3 = C3.[Date] , Value3 = C3.Value FROM CTE1 C1 LEFT JOIN CTE1 C2 ON C2.[Identity] = C1.[Identity] AND C2.col = 2 LEFT JOIN CTE1 C3 ON C3.[Identity] = C1.[Identity] AND C3.col = 3 WHERE C1.col = 1 ORDER BY C1.[Identity];
Identity | Table1UID1 | Date1 | Value1 | Table1UID2 | Date2 | !Value2 | Table1UID3 | Date3 | Value3 |
---|---|---|---|---|---|---|---|---|---|
ABC | 1 | 2011-01-01 | 43 | 4 | 2011-01-05 | 49 | 7 | 2011-01-12 | 42 |
DEF | 2 | 2011-01-02 | 28 | NULL | NULL | NULL | NULL | NULL | NULL |
GHI | 3 | 2011-01-05 | 37 | 6 | 2011-01-09 | 40 | NULL | NULL | NULL |
JKL | 5 | 2011-01-08 | 28 | NULL | NULL | NULL | NULL | NULL | NULL |
MNO | 8 | 2011-01-23 | 31 | NULL | NULL | NULL | NULL | NULL | NULL |
I need to do a one-time conversion of a 7-second animated gif to flv. I have Photoshop and Roxio, but they don't seem to do it. I downloaded two free programs, but neither would do it without paying. (Well one wouldn't do anything and the other put words over it and the image was slanted 45 degrees.)
Is there an easy, no-cost way to do this for one time for a small GIF? Bubba73 You talkin' to me? 22:30, 21 November 2011 (UTC)
The file is for a student art contest. The student made a 7-second GIF animaton that won at the county level. Now it is to go to the state level, but the state requires flv. The student doesn't know how to make it an flv. My wife is coordinating it at the local level and sending the local winners on to the state competition. She asked me to convert it from GIF to FLV. I've spent about an hour and a half, I can't do it, so I have to give up. Bubba73 You talkin' to me? 04:11, 22 November 2011 (UTC)
FLV sent. ¦ Reisio ( talk) 06:33, 22 November 2011 (UTC)
You guys should check out VLC sometime. ¦ Reisio ( talk) 18:29, 22 November 2011 (UTC)