I am linking tables from an existing ODBC data source and running queries from them. In one of the queries I'm trying to get a list of accounts that have had activity in the last year. The problem is if an account has had multiple activity dates it is showing twice or more and I only want to see it once. There is an account number field that I want to restrict to only have the account show once but I don't know how.
Any help would be appreciated.
21 2238
I am linking tables from an existing ODBC data source and running queries from them. In one of the queries I'm trying to get a list of accounts that have had activity in the last year. The problem is if an account has had multiple activity dates it is showing twice or more and I only want to see it once. There is an account number field that I want to restrict to only have the account show once but I don't know how.
Any help would be appreciated.
Please post the SQL of the query you are currently using.
Please post the SQL of the query you are currently using.
I'm still new to this, I think this is what you are wanting, let me know if it is not.
SELECT DISTINCT PBR_PbrAcct1.Actnum, PBR_PbrAcctDemMain1.Patnum, PBR_PbrAcctDemMain1.Name, PBR_PbrAcctPtAddrEtc1.Addr1, PBR_PbrAcctPtAddrEtc1.Addr2, PBR_PbrAcctPtAddrEtc1.City, PBR_PbrAcctPtAddrEtc1.State, PBR_PbrAcctPtAddrEtc1.Zip, PBR_PbrAcctPtAddrEtc1.HomePhone, PBR_PbrAcctPtAddrEtc1.OtherPhone, PBR_PbrAcctTxnsFinancial1.TxnLocation
FROM (((((PBR_PbrActTxnsSerDateX1 INNER JOIN PBR_PbrAcct1 ON PBR_PbrActTxnsSerDateX1.Account = PBR_PbrAcct1.Account) INNER JOIN PBR_PbrAcctDemMain1 ON PBR_PbrAcct1.Account = PBR_PbrAcctDemMain1.Account) INNER JOIN PBR_PbrAcctPtAddrEtc1 ON PBR_PbrAcctDemMain1.Account = PBR_PbrAcctPtAddrEtc1.Account) INNER JOIN PBR_PbrAcctTxnsFinancial1 ON PBR_PbrAcctPtAddrEtc1.Account = PBR_PbrAcctTxnsFinancial1.Account) INNER JOIN PBR_PbrDoctorDict1 ON PBR_PbrAcctTxnsFinancial1.TxnDoctor = PBR_PbrDoctorDict1.Mnemonic) INNER JOIN PBR_PbrProcDict1 ON PBR_PbrAcctTxnsFinancial1.TxnProcedure = PBR_PbrProcDict1.Mnemonic
WHERE (((PBR_PbrDoctorDict1.DbLvlB)=[Practice]) AND ((PBR_PbrProcDict1.Type)="CHG") AND ((PBR_PbrActTxnsSerDateX1.TxnSerDate)>=[from Date] And (PBR_PbrActTxnsSerDateX1.TxnSerDate)<=[Thru Date]));
Which of these columns has data that's different within the same Account.
BR_PbrAcct1.Actnum,
PBR_PbrAcctDemMain1.Patnum,
PBR_PbrAcctDemMain1.Name,
PBR_PbrAcctPtAddrEtc1.Addr1,
PBR_PbrAcctPtAddrEtc1.Addr2,
PBR_PbrAcctPtAddrEtc1.City,
PBR_PbrAcctPtAddrEtc1.State,
PBR_PbrAcctPtAddrEtc1.Zip,
PBR_PbrAcctPtAddrEtc1.HomePhone,
PBR_PbrAcctPtAddrEtc1.OtherPhone,
PBR_PbrAcctTxnsFinancial1.TxnLocation
Which of these columns has data that's different within the same Account.
BR_PbrAcct1.Actnum,
PBR_PbrAcctDemMain1.Patnum,
PBR_PbrAcctDemMain1.Name,
PBR_PbrAcctPtAddrEtc1.Addr1,
PBR_PbrAcctPtAddrEtc1.Addr2,
PBR_PbrAcctPtAddrEtc1.City,
PBR_PbrAcctPtAddrEtc1.State,
PBR_PbrAcctPtAddrEtc1.Zip,
PBR_PbrAcctPtAddrEtc1.HomePhone,
PBR_PbrAcctPtAddrEtc1.OtherPhone,
PBR_PbrAcctTxnsFinancial1.TxnLocation
BR_PbrAcct1.Actnum the account number
BR_PbrAcct1.Actnum the account number
You have different Actnum within one account?
If so which field identifies the account?
You have different Actnum within one account?
If so which field identifies the account?
No, I'm sorry I misread what you asked. The only one that might be different is PBR_PbrAcctTxnsFinancial1.TxnLocation. They could go to multiple locations, but they may not. They could very well have multiple TxnProcedure on the same TxnSerDate at the same TxnLocation.
No, I'm sorry I misread what you asked. The only one that might be different is PBR_PbrAcctTxnsFinancial1.TxnLocation. They could go to multiple locations, but they may not. They could very well have multiple TxnProcedure on the same TxnSerDate at the same TxnLocation.
That's why the distinct isn't working. To retrieve distinct records all of the values returned must be distinct.
If that field cannot me omitted let me know and I'll help redesign the query as an aggregate/group by query rather than a distinct.
That's why the distinct isn't working. To retrieve distinct records all of the values returned must be distinct.
If that field cannot me omitted let me know and I'll help redesign the query as an aggregate/group by query rather than a distinct.
Unfortunately it can not be removed, I have to have production totals for location.
Unfortunately it can not be removed, I have to have production totals for location.
But for which location. How do you identify which record is to be returned?
e.g. The most recent or by some other method.
But for which location. How do you identify which record is to be returned?
e.g. The most recent or by some other method.
I spoke with the customer and they have agreed to remove location for now (we'll end up doing that as a seperate report). Even when I remove the location the distinct row isn't working. I'm still receiveing a row per TXNProcedure. Is there something else I need to look at?
Thank you so much for your help!
I spoke with the customer and they have agreed to remove location for now (we'll end up doing that as a seperate report). Even when I remove the location the distinct row isn't working. I'm still receiveing a row per TXNProcedure. Is there something else I need to look at?
Thank you so much for your help!
You need to decide which TXNProcedure value you wish to return.
You need to decide which TXNProcedure value you wish to return.
Even if I'm not having it return the TXN Procedure? I'm using that as selection criteria so it only analyzes charge activity and not payments but I'm not actually pulling it on the view. If that is the case then it looks like I need to find another route.
Even if I'm not having it return the TXN Procedure? I'm using that as selection criteria so it only analyzes charge activity and not payments but I'm not actually pulling it on the view. If that is the case then it looks like I need to find another route.
Post the query as you are using it at the moment. If you are not returning it then no you shouldn't be getting a record for each value.
Post the query as you are using it at the moment. If you are not returning it then no you shouldn't be getting a record for each value.
SELECT DISTINCT PBR_PbrAcct1.Actnum, PBR_PbrAcctDemMain1.Patnum, PBR_PbrAcctDemMain1.Name, PBR_PbrAcctPtAddrEtc1.Addr1, PBR_PbrAcctPtAddrEtc1.Addr2, PBR_PbrAcctPtAddrEtc1.City, PBR_PbrAcctPtAddrEtc1.State, PBR_PbrAcctPtAddrEtc1.Zip, PBR_PbrAcctPtAddrEtc1.HomePhone, PBR_PbrAcctPtAddrEtc1.OtherPhone
FROM (((((PBR_PbrActTxnsSerDateX1 INNER JOIN PBR_PbrAcct1 ON PBR_PbrActTxnsSerDateX1.Account = PBR_PbrAcct1.Account) INNER JOIN PBR_PbrAcctDemMain1 ON PBR_PbrAcct1.Account = PBR_PbrAcctDemMain1.Account) INNER JOIN PBR_PbrAcctPtAddrEtc1 ON PBR_PbrAcctDemMain1.Account = PBR_PbrAcctPtAddrEtc1.Account) INNER JOIN PBR_PbrAcctTxnsFinancial1 ON PBR_PbrAcctPtAddrEtc1.Account = PBR_PbrAcctTxnsFinancial1.Account) INNER JOIN PBR_PbrDoctorDict1 ON PBR_PbrAcctTxnsFinancial1.TxnDoctor = PBR_PbrDoctorDict1.Mnemonic) INNER JOIN PBR_PbrProcDict1 ON PBR_PbrAcctTxnsFinancial1.TxnProcedure = PBR_PbrProcDict1.Mnemonic
WHERE (((PBR_PbrDoctorDict1.DbLvlB)=[Practice]) AND ((PBR_PbrProcDict1.Type)="CHG") AND ((PBR_PbrActTxnsSerDateX1.TxnSerDate)>=[from Date] And (PBR_PbrActTxnsSerDateX1.TxnSerDate)<=[Thru Date]));
Try this instead and see if it works any better. -
SELECT PBR_PbrAcct1.Actnum, PBR_PbrAcctDemMain1.Patnum,
-
PBR_PbrAcctDemMain1.Name, PBR_PbrAcctPtAddrEtc1.Addr1,
-
PBR_PbrAcctPtAddrEtc1.Addr2, PBR_PbrAcctPtAddrEtc1.City,
-
PBR_PbrAcctPtAddrEtc1.State, PBR_PbrAcctPtAddrEtc1.Zip,
-
PBR_PbrAcctPtAddrEtc1.HomePhone, PBR_PbrAcctPtAddrEtc1.OtherPhone
-
FROM (((((PBR_PbrActTxnsSerDateX1 INNER JOIN PBR_PbrAcct1
-
ON PBR_PbrActTxnsSerDateX1.Account = PBR_PbrAcct1.Account)
-
INNER JOIN PBR_PbrAcctDemMain1
-
ON PBR_PbrAcct1.Account = PBR_PbrAcctDemMain1.Account)
-
INNER JOIN PBR_PbrAcctPtAddrEtc1
-
ON PBR_PbrAcctDemMain1.Account = PBR_PbrAcctPtAddrEtc1.Account)
-
INNER JOIN PBR_PbrAcctTxnsFinancial1
-
ON PBR_PbrAcctPtAddrEtc1.Account = PBR_PbrAcctTxnsFinancial1.Account)
-
INNER JOIN PBR_PbrDoctorDict1
-
ON PBR_PbrAcctTxnsFinancial1.TxnDoctor = PBR_PbrDoctorDict1.Mnemonic)
-
INNER JOIN PBR_PbrProcDict1
-
ON PBR_PbrAcctTxnsFinancial1.TxnProcedure = PBR_PbrProcDict1.Mnemonic
-
WHERE (((PBR_PbrDoctorDict1.DbLvlB)=[Practice])
-
AND ((PBR_PbrProcDict1.Type)="CHG")
-
AND ((PBR_PbrActTxnsSerDateX1.TxnSerDate)>=[from Date]
-
And (PBR_PbrActTxnsSerDateX1.TxnSerDate)<=[Thru Date]))
-
GROUP BY SELECT PBR_PbrAcct1.Actnum,
-
PBR_PbrAcctDemMain1.Patnum, PBR_PbrAcctDemMain1.Name,
-
PBR_PbrAcctPtAddrEtc1.Addr1, PBR_PbrAcctPtAddrEtc1.Addr2,
-
PBR_PbrAcctPtAddrEtc1.City, PBR_PbrAcctPtAddrEtc1.State,
-
PBR_PbrAcctPtAddrEtc1.Zip, PBR_PbrAcctPtAddrEtc1.HomePhone,
-
PBR_PbrAcctPtAddrEtc1.OtherPhone;
-
Try this instead and see if it works any better. -
SELECT PBR_PbrAcct1.Actnum, PBR_PbrAcctDemMain1.Patnum,
-
PBR_PbrAcctDemMain1.Name, PBR_PbrAcctPtAddrEtc1.Addr1,
-
PBR_PbrAcctPtAddrEtc1.Addr2, PBR_PbrAcctPtAddrEtc1.City,
-
PBR_PbrAcctPtAddrEtc1.State, PBR_PbrAcctPtAddrEtc1.Zip,
-
PBR_PbrAcctPtAddrEtc1.HomePhone, PBR_PbrAcctPtAddrEtc1.OtherPhone
-
FROM (((((PBR_PbrActTxnsSerDateX1 INNER JOIN PBR_PbrAcct1
-
ON PBR_PbrActTxnsSerDateX1.Account = PBR_PbrAcct1.Account)
-
INNER JOIN PBR_PbrAcctDemMain1
-
ON PBR_PbrAcct1.Account = PBR_PbrAcctDemMain1.Account)
-
INNER JOIN PBR_PbrAcctPtAddrEtc1
-
ON PBR_PbrAcctDemMain1.Account = PBR_PbrAcctPtAddrEtc1.Account)
-
INNER JOIN PBR_PbrAcctTxnsFinancial1
-
ON PBR_PbrAcctPtAddrEtc1.Account = PBR_PbrAcctTxnsFinancial1.Account)
-
INNER JOIN PBR_PbrDoctorDict1
-
ON PBR_PbrAcctTxnsFinancial1.TxnDoctor = PBR_PbrDoctorDict1.Mnemonic)
-
INNER JOIN PBR_PbrProcDict1
-
ON PBR_PbrAcctTxnsFinancial1.TxnProcedure = PBR_PbrProcDict1.Mnemonic
-
WHERE (((PBR_PbrDoctorDict1.DbLvlB)=[Practice])
-
AND ((PBR_PbrProcDict1.Type)="CHG")
-
AND ((PBR_PbrActTxnsSerDateX1.TxnSerDate)>=[from Date]
-
And (PBR_PbrActTxnsSerDateX1.TxnSerDate)<=[Thru Date]))
-
GROUP BY SELECT PBR_PbrAcct1.Actnum,
-
PBR_PbrAcctDemMain1.Patnum, PBR_PbrAcctDemMain1.Name,
-
PBR_PbrAcctPtAddrEtc1.Addr1, PBR_PbrAcctPtAddrEtc1.Addr2,
-
PBR_PbrAcctPtAddrEtc1.City, PBR_PbrAcctPtAddrEtc1.State,
-
PBR_PbrAcctPtAddrEtc1.Zip, PBR_PbrAcctPtAddrEtc1.HomePhone,
-
PBR_PbrAcctPtAddrEtc1.OtherPhone;
-
That returns a syntax error. in query expression 'SELECT PBR_PbrAcct1.Actnum'
There may have been a bracket error, try this ... -
SELECT PBR_PbrAcct1.Actnum, PBR_PbrAcctDemMain1.Patnum,
-
PBR_PbrAcctDemMain1.Name, PBR_PbrAcctPtAddrEtc1.Addr1,
-
PBR_PbrAcctPtAddrEtc1.Addr2, PBR_PbrAcctPtAddrEtc1.City,
-
PBR_PbrAcctPtAddrEtc1.State, PBR_PbrAcctPtAddrEtc1.Zip,
-
PBR_PbrAcctPtAddrEtc1.HomePhone, PBR_PbrAcctPtAddrEtc1.OtherPhone
-
FROM ((((((PBR_PbrActTxnsSerDateX1 INNER JOIN PBR_PbrAcct1
-
ON PBR_PbrActTxnsSerDateX1.Account = PBR_PbrAcct1.Account)
-
INNER JOIN PBR_PbrAcctDemMain1
-
ON PBR_PbrAcct1.Account = PBR_PbrAcctDemMain1.Account)
-
INNER JOIN PBR_PbrAcctPtAddrEtc1
-
ON PBR_PbrAcctDemMain1.Account = PBR_PbrAcctPtAddrEtc1.Account)
-
INNER JOIN PBR_PbrAcctTxnsFinancial1
-
ON PBR_PbrAcctPtAddrEtc1.Account = PBR_PbrAcctTxnsFinancial1.Account)
-
INNER JOIN PBR_PbrDoctorDict1
-
ON PBR_PbrAcctTxnsFinancial1.TxnDoctor = PBR_PbrDoctorDict1.Mnemonic)
-
INNER JOIN PBR_PbrProcDict1
-
ON PBR_PbrAcctTxnsFinancial1.TxnProcedure = PBR_PbrProcDict1.Mnemonic)
-
WHERE PBR_PbrDoctorDict1.DbLvlB=[Practice]
-
AND PBR_PbrProcDict1.Type="CHG"
-
AND PBR_PbrActTxnsSerDateX1.TxnSerDate>=[from Date]
-
And PBR_PbrActTxnsSerDateX1.TxnSerDate<=[Thru Date]
-
GROUP BY SELECT PBR_PbrAcct1.Actnum,
-
PBR_PbrAcctDemMain1.Patnum, PBR_PbrAcctDemMain1.Name,
-
PBR_PbrAcctPtAddrEtc1.Addr1, PBR_PbrAcctPtAddrEtc1.Addr2,
-
PBR_PbrAcctPtAddrEtc1.City, PBR_PbrAcctPtAddrEtc1.State,
-
PBR_PbrAcctPtAddrEtc1.Zip, PBR_PbrAcctPtAddrEtc1.HomePhone,
-
PBR_PbrAcctPtAddrEtc1.OtherPhone;
-
There may have been a bracket error, try this ... -
SELECT PBR_PbrAcct1.Actnum, PBR_PbrAcctDemMain1.Patnum,
-
PBR_PbrAcctDemMain1.Name, PBR_PbrAcctPtAddrEtc1.Addr1,
-
PBR_PbrAcctPtAddrEtc1.Addr2, PBR_PbrAcctPtAddrEtc1.City,
-
PBR_PbrAcctPtAddrEtc1.State, PBR_PbrAcctPtAddrEtc1.Zip,
-
PBR_PbrAcctPtAddrEtc1.HomePhone, PBR_PbrAcctPtAddrEtc1.OtherPhone
-
FROM ((((((PBR_PbrActTxnsSerDateX1 INNER JOIN PBR_PbrAcct1
-
ON PBR_PbrActTxnsSerDateX1.Account = PBR_PbrAcct1.Account)
-
INNER JOIN PBR_PbrAcctDemMain1
-
ON PBR_PbrAcct1.Account = PBR_PbrAcctDemMain1.Account)
-
INNER JOIN PBR_PbrAcctPtAddrEtc1
-
ON PBR_PbrAcctDemMain1.Account = PBR_PbrAcctPtAddrEtc1.Account)
-
INNER JOIN PBR_PbrAcctTxnsFinancial1
-
ON PBR_PbrAcctPtAddrEtc1.Account = PBR_PbrAcctTxnsFinancial1.Account)
-
INNER JOIN PBR_PbrDoctorDict1
-
ON PBR_PbrAcctTxnsFinancial1.TxnDoctor = PBR_PbrDoctorDict1.Mnemonic)
-
INNER JOIN PBR_PbrProcDict1
-
ON PBR_PbrAcctTxnsFinancial1.TxnProcedure = PBR_PbrProcDict1.Mnemonic)
-
WHERE PBR_PbrDoctorDict1.DbLvlB=[Practice]
-
AND PBR_PbrProcDict1.Type="CHG"
-
AND PBR_PbrActTxnsSerDateX1.TxnSerDate>=[from Date]
-
And PBR_PbrActTxnsSerDateX1.TxnSerDate<=[Thru Date]
-
GROUP BY SELECT PBR_PbrAcct1.Actnum,
-
PBR_PbrAcctDemMain1.Patnum, PBR_PbrAcctDemMain1.Name,
-
PBR_PbrAcctPtAddrEtc1.Addr1, PBR_PbrAcctPtAddrEtc1.Addr2,
-
PBR_PbrAcctPtAddrEtc1.City, PBR_PbrAcctPtAddrEtc1.State,
-
PBR_PbrAcctPtAddrEtc1.Zip, PBR_PbrAcctPtAddrEtc1.HomePhone,
-
PBR_PbrAcctPtAddrEtc1.OtherPhone;
-
This is still giving me the same error.
Run this and see what happens ... -
SELECT PBR_PbrAcct1.*
-
FROM ((((((PBR_PbrActTxnsSerDateX1 INNER JOIN PBR_PbrAcct1
-
ON PBR_PbrActTxnsSerDateX1.Account = PBR_PbrAcct1.Account)
-
INNER JOIN PBR_PbrAcctDemMain1
-
ON PBR_PbrAcct1.Account = PBR_PbrAcctDemMain1.Account)
-
INNER JOIN PBR_PbrAcctPtAddrEtc1
-
ON PBR_PbrAcctDemMain1.Account = PBR_PbrAcctPtAddrEtc1.Account)
-
INNER JOIN PBR_PbrAcctTxnsFinancial1
-
ON PBR_PbrAcctPtAddrEtc1.Account = PBR_PbrAcctTxnsFinancial1.Account)
-
INNER JOIN PBR_PbrDoctorDict1
-
ON PBR_PbrAcctTxnsFinancial1.TxnDoctor = PBR_PbrDoctorDict1.Mnemonic)
-
INNER JOIN PBR_PbrProcDict1
-
ON PBR_PbrAcctTxnsFinancial1.TxnProcedure = PBR_PbrProcDict1.Mnemonic)
-
What happens when you run this?
Mary
Run this and see what happens ... -
SELECT PBR_PbrAcct1.*
-
FROM ((((((PBR_PbrActTxnsSerDateX1 INNER JOIN PBR_PbrAcct1
-
ON PBR_PbrActTxnsSerDateX1.Account = PBR_PbrAcct1.Account)
-
INNER JOIN PBR_PbrAcctDemMain1
-
ON PBR_PbrAcct1.Account = PBR_PbrAcctDemMain1.Account)
-
INNER JOIN PBR_PbrAcctPtAddrEtc1
-
ON PBR_PbrAcctDemMain1.Account = PBR_PbrAcctPtAddrEtc1.Account)
-
INNER JOIN PBR_PbrAcctTxnsFinancial1
-
ON PBR_PbrAcctPtAddrEtc1.Account = PBR_PbrAcctTxnsFinancial1.Account)
-
INNER JOIN PBR_PbrDoctorDict1
-
ON PBR_PbrAcctTxnsFinancial1.TxnDoctor = PBR_PbrDoctorDict1.Mnemonic)
-
INNER JOIN PBR_PbrProcDict1
-
ON PBR_PbrAcctTxnsFinancial1.TxnProcedure = PBR_PbrProcDict1.Mnemonic)
-
What happens when you run this?
Mary
Sorry, my ODBC had a server issue and I have been unable to try this. Should be fixed by the end of this week and I will give this a try. Thanks.
Sorry, my ODBC had a server issue and I have been unable to try this. Should be fixed by the end of this week and I will give this a try. Thanks.
No problem. Just post a reply when you're ready.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Tom Cunningham |
last post by:
OK, say you're trying to find all the non-exact duplicates in a table, and especially
do it with a single query, so that the check can be part of a user interface.
Then naturally you're going...
|
by: TimG |
last post by:
I have a column that has 75 values, 50 are unique/25 are duplicates. I
need to be able to bring back a list of the duplicates, listing all
rows even if more than two have the same value. I need to...
|
by: Tom Mitchell |
last post by:
All:
I'm stumped on a query. How do I find duplicates in a table where one
of the duplicates has values is a certain field and the other doesn't.
For example, I have the following table:
...
|
by: M.Stanley |
last post by:
Hi,
I have a problem..I'm doing a specific query where I'm joining fields
from a table with appednded data (there are duplicate records, except
for the date/time), and another query. I want the...
|
by: MHenry |
last post by:
Hi,
I have a table with duplicate records.
Some of the duplicates need to be eliminated from the table and some
need not.
A duplicate record does not need to be eliminated if the one record...
|
by: tyrfboard |
last post by:
I've been searching for awhile now on how to remove duplicates from a
table within an Access db and have found plenty of articles on finding
or deleting duplicates. All I want to do is remove them...
|
by: ARC |
last post by:
Hello all,
So I'm knee deep in this import utility program, and am coming up with all
sorts of "gotcha's!".
1st off. On a "Find Duplicates Query", does anyone have a good solution for...
|
by: bcquadrant |
last post by:
Hi there
I am trying to make an update query that will update information in all occurances of duplicate records based on the First record for that duplicate set.
There are about 30,000 records...
|
by: eclypz |
last post by:
I have this query qryOriginal that has this camps.
qryOriginal
IDNumb;
Phone;
CallerPhone;
DateContactIN;
DateContactOut;
Service;
answer
what I need is to delete from this table all...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |