Search Results

Search found 28443 results on 1138 pages for 'partition table'.

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

Page 167/1138 | < Previous Page | 163 164 165 166 167 168 169 170 171 172 173 174  | Next Page >

  • Erro while join table in SQL

    - by Color Shadow
    I have two tables that have relationship with UserName field. Based on UserName column, I want to get ID from CarReserve table. Here is my SQL statement: SELECT CarReserve.ID FROM CarReserve INNER JOIN aspnet_Users ON CarReserve.UserName = aspnet_Users.UserName WHERE UserName = @UserName Unfortunately, I am getting this warning: Ambiguous column name "UserName" Can anyone here tell me what is wrong with my statement?

    Read the article

  • Selecting two specific mysql table rows in a single query

    - by Scotta
    Lets say I have a table with 20 entries. They are sorted by date (date is a column name _) in descending order. How would I go about selecting ONLY the newest entry and the 15th oldest entry? I am getting all 15 results by doing the following query SELECT * FROM mytable m WHERE col1 = "zzz" ORDER BY date DESC LIMIT 15;

    Read the article

  • How to find missing alpha values in sets of data within same table in SQL

    - by Jeff
    I have a table of many values where one column has the WO Number, and another column has the Resource ID. I need to be able to find all the WO numbers that do not have a resource value of "RW". Here is an example of the typical information. I need to be able to know that work order 5678 does not have an "RW" Resource ID. WO Number - Resource ID 1234 - IN 1234 - WE 1234 - AS 1234 - RW 5678 - PR 5678 - WE 5678 - IN 5678 - AS

    Read the article

  • SQL updating a column in a table

    - by tecnodude
    Hi, I have the following table in an access database id VisitNo Weight 1 1 100 1 2 95 1 3 96 1 4 94 1 5 93 Now row 2 and 4 are deleted. So i have... id VisitNo Weight 1 1 100 1 3 96 1 5 93 However what i need is... id VisitNo Weight 1 1 100 1 2 96 1 3 93 What is the SQL query i need to accomplish the above? thanks

    Read the article

  • Getting maximum value from table using LINQ

    - by Tena
    I have a table in my database. I want to get the maximum value of a column named NumOfView. I used this code: var advert=(from ad in storedb.Ads where ad.AdScope == "1" select ad.NumOfView).Max(); It works but when there are two or more same maximum values it doesn't work and this message appears: Sequence contains more than one element What should I do now? Your answers will be very helpfull. Thanks

    Read the article

  • Large Data Table with first column fixed

    - by bhavya_w
    I have structure as shown in the fiddle http://jsfiddle.net/5LN7U/. <section class="container"> <section class="field"> <ul> <li> Question 1 </li> <li> question 2 </li> <li> question 3 </li> <li> question 4 </li> <li> question 5 </li> <li> question 6 </li> <li> question 7 </li> </ul> </section> <section class="datawrap"> <section class="datawrapinner"> <ul> <li><b>Answer 1 :</b></li> <li><b>Answer 2 :</b></li> <li><b>Answer 3 :</b></li> <li><b>Answer 4 :</b></li> <li><b>Answer 5 :</b></li> <li><b>Answer 6 :</b></li> <li><b>Answer 7 :</b></li> </ul> </section> </section> </section> Basically its a table structure made using divs. The first column contains a long list of questions and the second column contains answers/multiple answers which can be quite big ( there has to be horizontal scrolling in the second column.) The problem i am facing is when i scroll downwards the second column which has the horizontal scroll bar is also scrolling downward. I want horizontal scrollbar to be fixed there. as in it should be always fixed there no matter how much i scroll vertically. Much Like Google Spreadsheets: where the first column stays fixed and there's horizontal scrolling on rest of the columns with over vertical scrolling for whole of the data. I cannot used position fixed in the second column. P.S : please no lectures on using div's for making a table structure. I have my own reasons. and its kinda urgent. Thanks in advance.

    Read the article

  • why do I need virtual table?

    - by lego69
    I was looking for some information about virtual table, but can't find something easy to understand, can somebody give me good example(not from Wiki, please), with explanations, or link, thanks in advance

    Read the article

  • SQL Server : copy data from one table to another

    - by Gladdy
    I want to update Table2 names with names from Table1 with matching Ids I have around 100 rows in each table. Here is my sample tables. Table1 ID Name Table2 ID Name Sample data Table1 ID |Name -------- 1 |abc 2 |bcd Table2 ID |Name -------- 1 |xyz 2 |OOS Expected result Table2 ID |Name -------- 1 |abc 2 |bcd How can I do this?

    Read the article

  • How to add unused space to another partition in gparted?

    - by user1490211
    In my hard drive windows takes up 100 gb, then backtrack takes up 100 gb. When I make backtrack's partition smaller i get 100 gb for windows, 50 gb for backtrack, and 50 gb of unused space (in that exact order). How do I reallocate that 50 gb of space to windows so that instead it is 150 gb for windows, then 50 gb for backtrack? I'm using gparted and i can't move the unused space or add it to windows' partition.

    Read the article

  • Reliable way to find correct installed Windows OS in a Partition?

    - by MA1
    Hi All Is there a reliable and correct way to find if VISTA/W7 is installed in a partition? Please note, Searching for folder names is not reliable as one can manually create such paths in a partition and these can also be changed during the installation. So, are there any paths which can not be changed during and after installation or any other reliable way? Regards,

    Read the article

  • In Linux how do I mount a OS-X partition * by name * that is on the same host?

    - by philcolbourn
    I once used gnome-mount like this gnome-mount -o ro -d /dev/sda2 or gnome-mount -o ro -p "Macintosh HD" But, alas, gnome-mount seems to be no more. RIP. I can do this gvfs-mount -d /dev/sda2 (which generates a whole lot of errors but does mount the partition in the /media directory.) This is a related question: http://superuser.com/questions/131918/gnome-mount-alternative-in-ubuntu-10-04-or-how-to-mount-partition-with-normal-use But how do you do it by name?

    Read the article

  • How do I restore a partition without losing the data?

    - by sama
    I lost the D-partition in My Computer I opened My Computer, but couldn't find it and I don't know where it is or how to return it. I went to Disk Management and found it available as free space. So I tried to make it NTFS, but I had to format the drive and I don't want to, since it will erase my data. Does anyone know how I can restore my partition without losing my data?

    Read the article

  • Can I back-up to partition to restore my computer to factory settings?

    - by leaf68
    I have a VAIO model VPC-F11JFX/B. I want to restore it to factory settings (instead of formatting it so I can keep the programs it comes with like VAIO Care). I have like 20 GB of data so I can't copy it into my flash drive and it would take up like 7 of my CD's so I can't do that either. So can I make a new partition (called D) and move the files to D from C. Because I don't know if restoring to factory settings is going to wipe the entire drive or just the partition.

    Read the article

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

< Previous Page | 163 164 165 166 167 168 169 170 171 172 173 174  | Next Page >