Partition

disk

How to Get Volume Handle of EFI System Partition in a GPT Drive

22 Jun 2018 by gssajith87

How to get volume handle of EFI system reserved partition in the GPT disk ? When i use FindFirstVolume, it returns the volume handle of my boot partition instead of the EFI system Reserved Partitoin.

Sql Query for Co-related Subgroups.

17 Jan 2015 by Wendelius

Haven't actually tested this but perhaps something like this:select start.unixtimestamp, stop.unixtimestampfrom table1 start, table1 stopwhere start.speed = 0and stop.vehicleid = start.vehicleidand stop.unixtimestamp > start.unixtimestampand stop.speed ...

show previous quarter avg sale with current quarter avg sale

1 Sep 2015 by Maciej Los

Try this:SELECT (SELECT AVG(Sales) FROM product WHERE year = @prevYear AND @QTR=@prevQtr) AS PrevQtr, (SELECT AVG(Sales) FROM product WHERE year = @currYear AND @QTR=@currQtr) AS CurrQtrReplace @prevYear, @prevQtr, @currYear and @currYear with corresponding values.Another...

Listing all disk partitions

18 Jun 2013 by Gabi Cea

First of all, sorry for my english.I've been writing a code for listing all the partitions of a disk and I've found a problem. The Win32_DiskDrive property "Partitions" of WMI show me that one test disk have 5 partitions, but I only can list four of them (the last two partitions appear as...

.NET

disk

How to get Shadow Storage Space for Windows Volume

29 Jul 2013 by gssajith87

Hi,How can we do Query Shadow Storage space allocated for particular Windows Partition using a program?I know it is possible to query the information using vssadmin command line tool and by clicking shadowcopy tab in Windows volume property page. Is there any Win32 API that returns...

Partition Size read from MBR is greater than actual volume size by 4096 bytes

3 Jan 2014 by gssajith87

Partition Size obtained by Parsing the MBR is always 4096 Bytes Greater than the value that is seen in Volume Property in the disk-management. Is there any specific reason for this ? Reading through MBR dint help ! Thanks,Sajith

Windows

NTFS

Partition Size read from MBR is greater than actual volume size by 4096 bytes

3 Jan 2014 by Member 10394104

What type of master boot record are you using? E.G. NEWLDR MBR As for the partition entry how are you calculating the size of the partition? You could calculate the address with the beginning and end address by using the start end address for the sectors. Does the (number of sectors) * (sector...

Windows

NTFS

How do I make two partitions in usb flash drive using C++ ?

28 Nov 2014 by renukakurella

How do I make two partitions in USB flash drive using C++ or C#. These partitions can be viewed in a tool when I use this code like in Bootice. And I want make the primary partition as bootable.

C++

USB

How do I make two partitions in usb flash drive using C++ ?

29 Nov 2014 by Garth J Lancaster

As per Richard's comment - no trivial taskyou could start with something like this http://www.ranish.com/part/[^] and 'spawn' it off in its own process through the command line interface, but there's a 'disconnect' if you get errors that you'd have to be able to handle - that product also...

C++

USB

Sql Query for Co-related Subgroups.

17 Jan 2015 by Mohd Arshad Malik

I've vehicle tracking data, I want to create Vehicle stoppage report. Help me to write sql query for that. Actual Data and resultant data are like Table1 and Table2 respectively.TABLE 1VehicleId UnixTimeStamp Speed1 17-01-2015 12:00:05 121 ...

Create swap after ubuntu 14.04 installation

4 Feb 2015 by RupeshMote

I have installed 64-bit ubuntu 14.04 LTS, few days before. I have dual booting Ubuntu 14.04 LTS and Windows 8.1.I have 1TB hard disk. I have created partition of : 1) 250 GB for Windows C drive 2) 250 GB for Ubuntu 3) 500 GB as a D drive I...

Ubuntu

Create swap after ubuntu 14.04 installation

4 Feb 2015 by E.F. Nijboer

Install GParted in Ubuntu. A very powerfull and reliable tool that can handle practically all disk/partition formats and can resize without data loss. Easy to use interface (just like partition magic). Good luck!

Ubuntu

show previous quarter avg sale with current quarter avg sale

3 Sep 2015 by Jörgen Andersson

You have two problems that needs to be solved here.Your table definition sucks.You have three different temporal types that doesn't sort properly.You have gaps in the sequence.So lets fix them.first we need to fix the temporal types SELECT region ,Product ...

show previous quarter avg sale with current quarter avg sale

6 Sep 2015 by Member 11898509

with qtrs(qtr) as (select level from dual connect by level

How to Use Multiple Columns in Partition By And Ensure No Duplicate Row is Returned

7 Oct 2015 by Member 11999641

hi Members,I have used multiple columns in Partition By statement in SQL but duplicate rows are returned back. I only want distinct rows being returned back.This is what I have coded in Partition By:row_nums AS (SELECT DATE, STATUS, TITLE, ROW_NUMBER() OVER (PARTITION BY DATE,...

SQL-Server-2008R2

How to Use Multiple Columns in Partition By And Ensure No Duplicate Row is Returned

7 Oct 2015 by Ankur_Garg

Seems the data should display as expected. Try to identify it by selecting the following query:Select distinct DATE, STATUS, TITLE From TABLEIn the above case, the query should return 2 records for that row. If this isn't the case, please post the table values for both the rows and the...

SQL-Server-2008R2

How to Use Multiple Columns in Partition By And Ensure No Duplicate Row is Returned

7 Oct 2015 by waynetan123

;WTIH row_nums AS ( SELECT DATE, STATUS, TITLE, ROW_NUMBER() OVER (PARTITION BY DATE, STATUS, TITLE ORDER BY NUM ASC) AS Row_Num FROM ( SELECT your required columns, COUNT(duplicated_rows_columnsname) FROM *** GROUP BY...

SQL-Server-2008R2

How do I convert datatime to numeric

15 Jul 2016 by Vignesh Mani

Hi friend,First datetime convert to string then convert to numeric. It is possible

How to Get Volume Handle of EFI System Partition in a GPT Drive

22 Jun 2018 by hasan bozkurt

Perhaps it is too late But this info can help someone; You may try to find BootIndicator partition by sending IOCTL code such as PARTITION_INFORMATION_EX.

Need assistance with SQL query with error message subquery returns more than 1 row

21 Jun 2020 by MarissaReloaded

I have two tables, and I would like to update the running balance of expenses by retrieving the allocation(budget) based on matching voteid I'm using phpmyadmin mysql * Apache/2.4.43 (Win64) OpenSSL/1.1.1g PHP/7.4.6 * Database client version:...

MariaDB

Need assistance with SQL query with error message subquery returns more than 1 row

20 Jun 2020 by Herman<T>.Instance

The part of the query SET @csum = (SELECT allocation FROM vote INNER JOIN expenditure ON vote.voteid = expenditure.voteid GROUP BY vote.voteid); will return mpre than 1 rows. You have to refine that...

MariaDB

Need assistance with SQL query with error message subquery returns more than 1 row

21 Jun 2020 by Jörgen Andersson

You are thinking procedurally. With SQL it's best to think in sets. And you should also consider keeping the data normalized, so the need to update the balance is a bad idea, that should be queried when needed. Database normalization -...

MariaDB

Having a hard time displaying my code

7 Oct 2022 by Member 15790844

I am currently working on a program that tests the speed and efficiency of four different sorting methods. Every sorting function will have a loop count and a swap count. I created a class in one file and implemented the member function in...

Having a hard time displaying my code

7 Oct 2022 by FreedMalloc

I have a few observations for your code. As commented above I don't know what "not always displayed" means. You don't mention the program aborting abnormally which I would think would be quite obvious. Other than that I see no reason the...

Having a hard time displaying my code

7 Oct 2022 by merano99

This will probably be a never-ending story. while (intArray[up]

show previous quarter avg sale with current quarter avg sale

3 Sep 2015 by Member 11898509

I have a table one in which there are various attribute like region product,year,qtr,month,sale. I have to calculate the avg_qtr sale of each product having same region and show their previous avg_qtr sale.I have read about lag but here it is not possible to use as it is not fixed after how many...

Sql Query for Co-related Subgroups.

17 Jan 2015 by Mohd Arshad Malik

I tried this...declare @t as table (vehicleid INT, unixtimestamp DATETIME, speed int)INSERT INTO @t VALUES(1, '2015-01-17 12:00:05', 12)INSERT INTO @t VALUES(1, '2015-01-17 12:00:06', 0)INSERT INTO @t VALUES(1, '2015-01-17 12:00:07', 0)INSERT INTO @t VALUES(1, '2015-01-17...

Double checking my answer for solving a partition by statement

8 Nov 2021 by Arvin Donner

I am working on a partitioning problem. I am looking to partition an entire table using three different ranges: ColumnA > 0.0 ColumnA

expressions