Hi,
I am trying to add a staggered running total and average to a query
returning quarterly CPI data. I need to add 4 quarterly data points
together to calculate a moving 12-month sum (YrCPI), and then to
complicate things, calculate a moving average of the 12-month figure
(AvgYrCPI).
Given the sample data:
CREATE TABLE [dbo].[QtrInflation] (
[Qtr] [smalldatetime] NOT NULL ,
[CPI] [decimal](8, 4) NOT NULL
) ON [PRIMARY]
GO
INSERT INTO QtrInflation (Qtr, CPI)
SELECT '1960-03-01', 0.7500 UNION
SELECT '1960-06-01', 1.4800 UNION
SELECT '1960-09-01', 1.4600 UNION
SELECT '1960-12-01', 0.7200 UNION
SELECT '1961-03-01', 0.7100 UNION
SELECT '1961-06-01', 0.7100 UNION
SELECT '1961-09-01',-0.7000 UNION
SELECT '1961-12-01', 0.0000 UNION
SELECT '1962-03-01', 0.0000 UNION
SELECT '1962-06-01', 0.0000 UNION
SELECT '1962-09-01', 0.0000 UNION
SELECT '1962-12-01', 0.0000 UNION
SELECT '1963-03-01', 0.0000 UNION
SELECT '1963-06-01', 0.0000 UNION
SELECT '1963-09-01', 0.7100 UNION
SELECT '1963-12-01', 0.0000 UNION
SELECT '1964-03-01', 0.7000 UNION
SELECT '1964-06-01', 0.7000 UNION
SELECT '1964-09-01', 1.3900 UNION
SELECT '1964-12-01', 0.6800 UNION
SELECT '1965-03-01', 0.6800 UNION
SELECT '1965-06-01', 1.3500 UNION
SELECT '1965-09-01', 0.6700 UNION
SELECT '1965-12-01', 1.3200
I am trying to return the following results:
Qtr CPI YrCPI AvgYrCPI
-------- ----- ----- --------
1-Jun-60 1.48
1-Sep-60 1.46
1-Dec-60 0.72
1-Mar-61 0.71 4.37
1-Jun-61 0.71 3.60
1-Sep-61 -0.70 1.44
1-Dec-61 0.00 0.72 2.53
1-Mar-62 0.00 0.01 1.44
1-Jun-62 0.00 -0.70 0.37
1-Sep-62 0.00 0.00 0.01
1-Dec-62 0.00 0.00 -0.17
1-Mar-63 0.00 0.00 -0.18
1-Jun-63 0.00 0.00 0.00
1-Sep-63 0.71 0.71 0.18
1-Dec-63 0.00 0.71 0.36
1-Mar-64 0.70 1.41 0.71
1-Jun-64 0.70 2.11 1.24
1-Sep-64 1.39 2.79 1.76
1-Dec-64 0.68 3.47 2.45
1-Mar-65 0.68 3.45 2.96
1-Jun-65 1.35 4.10 3.45
1-Sep-65 0.67 3.38 3.60
1-Dec-65 1.32 4.02 3.74
Note, 4 data points are required to calculate a moving sum of CPI
(YrCPI) and 4 calculate YrCPI figures are required calculate the
annual average of YrCPI (AvgYrCPI), giving a staggered effect to the
first 7 results
This sad effort is about as far as I've got:
SELECT I.Qtr, I.CPI, SUM(S.CPI) AS YrCPI
FROM QtrInflation I
JOIN (
SELECT TOP 4 Qtr, CPI
FROM QtrInflation
) S
ON S.Qtr <= I.Qtr
GROUP BY I.Qtr, I.CPI
ORDER BY I.Qtr ASC
Can anyone suggest how do achieve this result without having to resort
to cursors?
Thanks,
Stephen 5 5317
Hi
This will do it (I think!) but there may be a neater way!
SELECT S.Qtr, S.CPI, D.YrCPI, E.AvgCPI
FROM QtrInflation S LEFT JOIN
( SELECT Q.Qtr, SUM(A.CPI) AS YrCPI
FROM QtrInflation Q LEFT JOIN ( SELECT Qtr, SUM(CPI) AS CPI
FROM QtrInflation
GROUP BY Qtr) A ON Q.Qtr >= A.Qtr AND DATEADD(YEAR,-1,Q.Qtr) < A.Qtr
GROUP BY Q.Qtr
HAVING COUNT(A.Qtr) = 4 ) D ON S.Qtr = D.Qtr
LEFT JOIN
( SELECT R.Qtr, SUM(B.CPI)/4 AS AvgCPI
FROM QtrInflation R LEFT JOIN ( SELECT Q.Qtr, SUM(A.CPI) AS CPI
FROM QtrInflation Q LEFT JOIN ( SELECT Qtr, SUM(CPI) AS CPI
FROM QtrInflation
GROUP BY Qtr) A ON Q.Qtr >= A.Qtr AND DATEADD(YEAR,-1,Q.Qtr) < A.Qtr
GROUP BY Q.Qtr
HAVING COUNT(A.Qtr) = 4 ) B ON R.Qtr >= B.Qtr AND DATEADD(YEAR,-1,R.Qtr)
< B.Qtr
GROUP BY R.Qtr
HAVING COUNT(B.Qtr) = 4 ) E ON S.Qtr = E.Qtr
ORDER BY S.Qtr
John
"Stephen Miller" <js******@hotma il.com> wrote in message
news:cd******** *************** ***@posting.goo gle.com... Hi,
I am trying to add a staggered running total and average to a query returning quarterly CPI data. I need to add 4 quarterly data points together to calculate a moving 12-month sum (YrCPI), and then to complicate things, calculate a moving average of the 12-month figure (AvgYrCPI).
Given the sample data:
CREATE TABLE [dbo].[QtrInflation] ( [Qtr] [smalldatetime] NOT NULL , [CPI] [decimal](8, 4) NOT NULL ) ON [PRIMARY] GO
INSERT INTO QtrInflation (Qtr, CPI) SELECT '1960-03-01', 0.7500 UNION SELECT '1960-06-01', 1.4800 UNION SELECT '1960-09-01', 1.4600 UNION SELECT '1960-12-01', 0.7200 UNION SELECT '1961-03-01', 0.7100 UNION SELECT '1961-06-01', 0.7100 UNION SELECT '1961-09-01',-0.7000 UNION SELECT '1961-12-01', 0.0000 UNION SELECT '1962-03-01', 0.0000 UNION SELECT '1962-06-01', 0.0000 UNION SELECT '1962-09-01', 0.0000 UNION SELECT '1962-12-01', 0.0000 UNION SELECT '1963-03-01', 0.0000 UNION SELECT '1963-06-01', 0.0000 UNION SELECT '1963-09-01', 0.7100 UNION SELECT '1963-12-01', 0.0000 UNION SELECT '1964-03-01', 0.7000 UNION SELECT '1964-06-01', 0.7000 UNION SELECT '1964-09-01', 1.3900 UNION SELECT '1964-12-01', 0.6800 UNION SELECT '1965-03-01', 0.6800 UNION SELECT '1965-06-01', 1.3500 UNION SELECT '1965-09-01', 0.6700 UNION SELECT '1965-12-01', 1.3200
I am trying to return the following results:
Qtr CPI YrCPI AvgYrCPI -------- ----- ----- -------- 1-Jun-60 1.48 1-Sep-60 1.46 1-Dec-60 0.72 1-Mar-61 0.71 4.37 1-Jun-61 0.71 3.60 1-Sep-61 -0.70 1.44 1-Dec-61 0.00 0.72 2.53 1-Mar-62 0.00 0.01 1.44 1-Jun-62 0.00 -0.70 0.37 1-Sep-62 0.00 0.00 0.01 1-Dec-62 0.00 0.00 -0.17 1-Mar-63 0.00 0.00 -0.18 1-Jun-63 0.00 0.00 0.00 1-Sep-63 0.71 0.71 0.18 1-Dec-63 0.00 0.71 0.36 1-Mar-64 0.70 1.41 0.71 1-Jun-64 0.70 2.11 1.24 1-Sep-64 1.39 2.79 1.76 1-Dec-64 0.68 3.47 2.45 1-Mar-65 0.68 3.45 2.96 1-Jun-65 1.35 4.10 3.45 1-Sep-65 0.67 3.38 3.60 1-Dec-65 1.32 4.02 3.74
Note, 4 data points are required to calculate a moving sum of CPI (YrCPI) and 4 calculate YrCPI figures are required calculate the annual average of YrCPI (AvgYrCPI), giving a staggered effect to the first 7 results
This sad effort is about as far as I've got:
SELECT I.Qtr, I.CPI, SUM(S.CPI) AS YrCPI FROM QtrInflation I JOIN ( SELECT TOP 4 Qtr, CPI FROM QtrInflation ) S ON S.Qtr <= I.Qtr GROUP BY I.Qtr, I.CPI ORDER BY I.Qtr ASC
Can anyone suggest how do achieve this result without having to resort to cursors?
Thanks,
Stephen
Stephen,
Here is another approach that I think will work
for you:
-- alternate solution
create table Weights (
offset int,
weight decimal(3,2),
weightA decimal(3,2),
weightB decimal(3,2)
)
go
insert into Weights
select 6, 0, 0, 0.25 union all
select 5, 0, 0, 0.5 union all
select 4, 0, 0, 0.75 union all
select 3, 0, 1, 1.00 union all
select 2, 0, 1, 0.75 union all
select 1, 0, 1, 0.5 union all
select 0, 1, 1, 0.25
go
select
dateadd(month,3 *Offset,Q1.Qtr) Qtr,
sum(Weight*Q1.C PI) CPI,
case when sum(WeightA) = 4 then sum(WeightA*Q1. CPI) else NULL end as YrCPI,
case when sum(WeightB) = 4 then sum(WeightB*Q1. CPI) else NULL end as MACPI
from QtrInflation Q1, Weights
group by dateadd(month,3 *Offset,Q1.Qtr)
having sum(Weight) = 1
order by dateadd(month,3 *Offset,Q1.Qtr)
-- Steve Kass
-- Drew University
-- Ref: 17F9A22A-8DDA-4812-A8CD-B68062BADFA1
Stephen Miller wrote: Hi,
I am trying to add a staggered running total and average to a query returning quarterly CPI data. I need to add 4 quarterly data points together to calculate a moving 12-month sum (YrCPI), and then to complicate things, calculate a moving average of the 12-month figure (AvgYrCPI).
Given the sample data:
CREATE TABLE [dbo].[QtrInflation] ( [Qtr] [smalldatetime] NOT NULL , [CPI] [decimal](8, 4) NOT NULL ) ON [PRIMARY] GO
INSERT INTO QtrInflation (Qtr, CPI) SELECT '1960-03-01', 0.7500 UNION SELECT '1960-06-01', 1.4800 UNION SELECT '1960-09-01', 1.4600 UNION SELECT '1960-12-01', 0.7200 UNION SELECT '1961-03-01', 0.7100 UNION SELECT '1961-06-01', 0.7100 UNION SELECT '1961-09-01',-0.7000 UNION SELECT '1961-12-01', 0.0000 UNION SELECT '1962-03-01', 0.0000 UNION SELECT '1962-06-01', 0.0000 UNION SELECT '1962-09-01', 0.0000 UNION SELECT '1962-12-01', 0.0000 UNION SELECT '1963-03-01', 0.0000 UNION SELECT '1963-06-01', 0.0000 UNION SELECT '1963-09-01', 0.7100 UNION SELECT '1963-12-01', 0.0000 UNION SELECT '1964-03-01', 0.7000 UNION SELECT '1964-06-01', 0.7000 UNION SELECT '1964-09-01', 1.3900 UNION SELECT '1964-12-01', 0.6800 UNION SELECT '1965-03-01', 0.6800 UNION SELECT '1965-06-01', 1.3500 UNION SELECT '1965-09-01', 0.6700 UNION SELECT '1965-12-01', 1.3200
I am trying to return the following results:
Qtr CPI YrCPI AvgYrCPI -------- ----- ----- -------- 1-Jun-60 1.48 1-Sep-60 1.46 1-Dec-60 0.72 1-Mar-61 0.71 4.37 1-Jun-61 0.71 3.60 1-Sep-61 -0.70 1.44 1-Dec-61 0.00 0.72 2.53 1-Mar-62 0.00 0.01 1.44 1-Jun-62 0.00 -0.70 0.37 1-Sep-62 0.00 0.00 0.01 1-Dec-62 0.00 0.00 -0.17 1-Mar-63 0.00 0.00 -0.18 1-Jun-63 0.00 0.00 0.00 1-Sep-63 0.71 0.71 0.18 1-Dec-63 0.00 0.71 0.36 1-Mar-64 0.70 1.41 0.71 1-Jun-64 0.70 2.11 1.24 1-Sep-64 1.39 2.79 1.76 1-Dec-64 0.68 3.47 2.45 1-Mar-65 0.68 3.45 2.96 1-Jun-65 1.35 4.10 3.45 1-Sep-65 0.67 3.38 3.60 1-Dec-65 1.32 4.02 3.74
Note, 4 data points are required to calculate a moving sum of CPI (YrCPI) and 4 calculate YrCPI figures are required calculate the annual average of YrCPI (AvgYrCPI), giving a staggered effect to the first 7 results
This sad effort is about as far as I've got:
SELECT I.Qtr, I.CPI, SUM(S.CPI) AS YrCPI FROM QtrInflation I JOIN ( SELECT TOP 4 Qtr, CPI FROM QtrInflation ) S ON S.Qtr <= I.Qtr GROUP BY I.Qtr, I.CPI ORDER BY I.Qtr ASC
Can anyone suggest how do achieve this result without having to resort to cursors?
Thanks,
Stephen
John & Steve
Thank you for two very interesting (and very different) responses. You
guys are gurus! Both return the results I'm looking for and now I'm
stuck picking which one's best ;)
Thanks again,
Stephen
"John Bell" <jb************ @hotmail.com> wrote in message news:<3f******* *************** *@news.easynet. co.uk>... Hi
This will do it (I think!) but there may be a neater way!
SELECT S.Qtr, S.CPI, D.YrCPI, E.AvgCPI FROM QtrInflation S LEFT JOIN ( SELECT Q.Qtr, SUM(A.CPI) AS YrCPI FROM QtrInflation Q LEFT JOIN ( SELECT Qtr, SUM(CPI) AS CPI FROM QtrInflation GROUP BY Qtr) A ON Q.Qtr >= A.Qtr AND DATEADD(YEAR,-1,Q.Qtr) < A.Qtr GROUP BY Q.Qtr HAVING COUNT(A.Qtr) = 4 ) D ON S.Qtr = D.Qtr LEFT JOIN ( SELECT R.Qtr, SUM(B.CPI)/4 AS AvgCPI FROM QtrInflation R LEFT JOIN ( SELECT Q.Qtr, SUM(A.CPI) AS CPI FROM QtrInflation Q LEFT JOIN ( SELECT Qtr, SUM(CPI) AS CPI FROM QtrInflation GROUP BY Qtr) A ON Q.Qtr >= A.Qtr AND DATEADD(YEAR,-1,Q.Qtr) < A.Qtr GROUP BY Q.Qtr HAVING COUNT(A.Qtr) = 4 ) B ON R.Qtr >= B.Qtr AND DATEADD(YEAR,-1,R.Qtr) < B.Qtr GROUP BY R.Qtr HAVING COUNT(B.Qtr) = 4 ) E ON S.Qtr = E.Qtr ORDER BY S.Qtr
John "Stephen Miller" <js******@hotma il.com> wrote in message news:cd******** *************** ***@posting.goo gle.com... Hi,
I am trying to add a staggered running total and average to a query returning quarterly CPI data. I need to add 4 quarterly data points together to calculate a moving 12-month sum (YrCPI), and then to complicate things, calculate a moving average of the 12-month figure (AvgYrCPI).
Given the sample data:
CREATE TABLE [dbo].[QtrInflation] ( [Qtr] [smalldatetime] NOT NULL , [CPI] [decimal](8, 4) NOT NULL ) ON [PRIMARY] GO
INSERT INTO QtrInflation (Qtr, CPI) SELECT '1960-03-01', 0.7500 UNION SELECT '1960-06-01', 1.4800 UNION SELECT '1960-09-01', 1.4600 UNION SELECT '1960-12-01', 0.7200 UNION SELECT '1961-03-01', 0.7100 UNION SELECT '1961-06-01', 0.7100 UNION SELECT '1961-09-01',-0.7000 UNION SELECT '1961-12-01', 0.0000 UNION SELECT '1962-03-01', 0.0000 UNION SELECT '1962-06-01', 0.0000 UNION SELECT '1962-09-01', 0.0000 UNION SELECT '1962-12-01', 0.0000 UNION SELECT '1963-03-01', 0.0000 UNION SELECT '1963-06-01', 0.0000 UNION SELECT '1963-09-01', 0.7100 UNION SELECT '1963-12-01', 0.0000 UNION SELECT '1964-03-01', 0.7000 UNION SELECT '1964-06-01', 0.7000 UNION SELECT '1964-09-01', 1.3900 UNION SELECT '1964-12-01', 0.6800 UNION SELECT '1965-03-01', 0.6800 UNION SELECT '1965-06-01', 1.3500 UNION SELECT '1965-09-01', 0.6700 UNION SELECT '1965-12-01', 1.3200
I am trying to return the following results:
Qtr CPI YrCPI AvgYrCPI -------- ----- ----- -------- 1-Jun-60 1.48 1-Sep-60 1.46 1-Dec-60 0.72 1-Mar-61 0.71 4.37 1-Jun-61 0.71 3.60 1-Sep-61 -0.70 1.44 1-Dec-61 0.00 0.72 2.53 1-Mar-62 0.00 0.01 1.44 1-Jun-62 0.00 -0.70 0.37 1-Sep-62 0.00 0.00 0.01 1-Dec-62 0.00 0.00 -0.17 1-Mar-63 0.00 0.00 -0.18 1-Jun-63 0.00 0.00 0.00 1-Sep-63 0.71 0.71 0.18 1-Dec-63 0.00 0.71 0.36 1-Mar-64 0.70 1.41 0.71 1-Jun-64 0.70 2.11 1.24 1-Sep-64 1.39 2.79 1.76 1-Dec-64 0.68 3.47 2.45 1-Mar-65 0.68 3.45 2.96 1-Jun-65 1.35 4.10 3.45 1-Sep-65 0.67 3.38 3.60 1-Dec-65 1.32 4.02 3.74
Note, 4 data points are required to calculate a moving sum of CPI (YrCPI) and 4 calculate YrCPI figures are required calculate the annual average of YrCPI (AvgYrCPI), giving a staggered effect to the first 7 results
This sad effort is about as far as I've got:
SELECT I.Qtr, I.CPI, SUM(S.CPI) AS YrCPI FROM QtrInflation I JOIN ( SELECT TOP 4 Qtr, CPI FROM QtrInflation ) S ON S.Qtr <= I.Qtr GROUP BY I.Qtr, I.CPI ORDER BY I.Qtr ASC
Can anyone suggest how do achieve this result without having to resort to cursors?
Thanks,
Stephen
Hi Stephen
I would expect Steve's solution to work alot better than mine under
large loads!
John
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
>> I am trying to add a staggered running total and average to a query
returning quarterly CPI data. I need to add 4 quarterly data points
together to calculate a moving 12-month sum (YrCPI), and then to
complicate things, calculate a moving average of the 12-month figure
(AvgYrCPI). <<
I hope you mean to have a key on this table and some contraints
CREATE TABLE QtrInflation
(qtr SMALLDATETIME NOT NULL PRIMARY KEY
CHECK (MONTH(qtr) IN (03, 06, 09, 12)
AND (DAY(qtr) = 01)),
cpi DECIMAL(8,4) NOT NULL
CHECK(cpi >= 0.0000));
CREATE TABLE QtrReportRanges
(start_date SMALLDATETIME NOT NULL
CHECK (MONTH(qtr) IN (03, 06, 09, 12)
AND (DAY(qtr) = 01)),
end_date SMALLDATETIME NOT NULL
CHECK (MONTH(qtr) IN (03, 06, 09, 12)
AND (DAY(qtr) = 01)),
CHECK (start_date < end_date),
PRIMARY KEY (start_date < end_date));
INSERT INTO QtrReportRanges VALUES ('1960-03-01', '1960-12-01');
INSERT INTO QtrReportRanges VALUES ('1960-06-01', '1961-03-01');
etc,
now you can get the report easily.
SELECT R.start_date, R.end_date, SUM(cpi) AS yr_cpi, AVG(cpi) AS
avg_yr_cpi
FROM QtrInflation AS I, QtrReportRanges AS R
WHERE I.qtr BETWEEN R.start_date AND R.end_date
GROUP BY R.start_date, R.end_date; This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: nickdu |
last post by:
I'm trying to isolate "applications" into their own application domain within
a single process. I've quoted applications because it's a logical
representation of an application. Basically it consists of a bunch of
components supplied by some application group. I got this to work, somewhat.
The problem is that the application performs roughly (and this has not been
measured, but a guess based on the rendering of the application GUI) 10x...
|
by: Alex |
last post by:
Acc 97
Hi, I am in need of some help here....
I have a query which is based upon time, where i need to plot the
hours
a job has been working.. therefore, oN & off in a union query.
problem...
|
by: CSDunn |
last post by:
Hello,
I have 14 fields on a report that hold integer values. The field names
use the following naming convention: T1Number, T2Number ....T14Number.
I need to get a 'sub total' of all fields as follows:
=Sum() ... =Sum()
Then I need to get an average of all fields as follows:
|
by: Peter Bailey |
last post by:
I have a query that creates a graph of bookings from the course start date
looking back 20 weeks based on a running sum.
I also have a query that counts the number of bookings before that 20 week
date for that particular course start date.
What they want is to start the 20 week running sum from the previous total.
for ex
|
by: Gandalf186 |
last post by:
I need to create a query that produces running totals for every group within my table for example i wish to see: -
Group A
1
5
9
15
Group B
| |
by: mochatrpl |
last post by:
I am looking for a way to make a query / report display the running
average for total dollars.
I have already set up a query to provide totals dollars per day from
which a report graphly shows the dollars per week. How do I then take
the dollars and get a running average for the year?
- Randy
|
by: Mark |
last post by:
Hi, I'm new to python and looking for a better idiom to use for the
manner I have been organising my python scripts. I've googled all over
the place about this but found absolutely nothing.
I'm a linux/unix command line guy quite experienced in shell scripts
etc. I have a heap of command line utility scripts which I run directly.
What is the best way to create python command line scripts but exploit
the (loadonly) speed-up benefit of...
|
by: Richard Hollenbeck |
last post by:
I hope this isn't too confusing.
The following query runs pretty fast by itself, but when I want to use it in
a report (pasted below the query), it takes at least fifteen seconds to run!
Then I want to analyze the query in Excel and I have to do some manual
tweaking. I'd like to run this same query as a summary for the whole class
without having to manually do it in Excel, rather in an Access report, but
that gets even more complicated....
|
by: Bill Cunningham |
last post by:
I have a row of values like such, placed in a text file by fprintf.
10.50
10.25
10.00
10.75
11.00
What I want to do to the above colum is add a new column right beside it
which is a total of these values and then average them in another column.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |