Comments by _Asif_ (Top 200 by date)

The updated solution, thanks anyway. I re-read the question and got what you meant. Thanks anyway

Yes in software terms everything is possible. My suggestions to you are
1. Your problem is not new instead it's an everyday problem for all online stores. It would be best if you studied how they have resolved this issue carefully.
2. Once you studied the other business models you may reach to an alternative solution compared to the one you suggested in your question.
3. If you still think that your suggested solution is best then you should write a document explaining the requirements end to end and float this document to any freelancer websites and you will start receiving Quotes.

Hopefully, the above approach should sort you out.

Thanks.

Please provide table structure along with sample data to investigate further. You should also provide sample output as well for validating the solution

Should not the output for mary be like
mary august 5 instead of mary may 5?

Output does not match with OPs desired Output

Below is the actual message (hiding customer details), the channel received from Middleware.
000187UNISON2|20|xxUserid|0210|20210605120248|06|CRM|4200000000001|115|20210605|0000001|000013|00000000000|00|1|Customer Name|00000000000001|0047|XXXXXXX|PKR||000000000000001|A|30|20|1|


As you can see the 5th Element is transaction date time. This received message goes through multiple stages, but the very first step the channel does
is to store this message in a table for Audit / Compliance purpose so that in case of investigation the channel precisely know what it has received from
Middleware. On later stages, we do parse the message and store it as per their data types.

There is another aspect that we should not understimate, and that is performance. Our Middleware processes 5K Transactions per second, and for that speed everything matters.

From the Question Perspective, what information are we getting.
1. This is a shopping cart kind of application
2. This application is already in production because OP got a "situation" where date is getting updated and that daily sales report is being generated for quite some time
3. The table name suggests it is some intermidiate table generated by backend process (Probably some DB Job) for daily reporting purpose
4. The report in question is not an automated report
5. This shopping cart application is developed by a novice software engineer.
6. It seems that a new requirement in terms of filter have been requested by Business team and this developer (OP) is working on this report filter.

From all above undestanding (for myself only) i have resolved his issue by providing him a solution for his immidiate problem.

P.S:
You all are free to downvote as many time as you want :) Thats not my concern. I am here to learn and to share the knowledge I have.

You are right, This is new to me. Logically it does not make sense.
+5

what do you think it should print?

+5

My vote of 1:
In significant number of cases, we as developer when join a company usually work in an environment where application is already in Production, used by thousands of users. In these legacy systems, developer usually inherits database design issues present in Production and for a number of reasons, correcting these design issues
requires deep product understanding, and most importantly impact analysis is required if there are third party APIs doing operations over these data.

Apart from that there are legit cases where dates do come as string and stored as string. For example in financial domain dates comes from host/middleware as string and stored as string in Audit Tables as per standard message format.

Ok,

I assume you can track how many search/booked calls each IIS is doing. You need to do an analysis on per hour basis in the following manner. This should give you ideas what gets wrong.

|----------------------------------------------------------|-----------------------------------------------------------|
|------- Past Event When everything works fine -------|-------- Present Event: When L2B gets reduced --------|
| IIS | Search | Search Exec | Book | Book Exec | IIS | Search | Search Exec | Book | Book Exec ---|
| NO | Count | Exec Time Avg | Count| Exec Time Avg| NO | Count | Exec Time Avg | Count| Exec Time Avg|
|----------------------------------------------------------|-----------------------------------------------------------|

Look to book seems a business term (not a technical term) that should vary as per your understanding that mobile UI is not that friendly compared to Desktop ( Web-based, I assume).
From the technical perspective, I like to know how many HTTP calls are landing on both IIS. my gut feeling is that round-robin is not working accurately and one IIS getting twice calls compared to other IIS.

Also check this https://support.citrix.com/article/CTX120542

as everyone mentioned "a5" is not double type.
"5" -> 5.00 because 5 as string can be converted into double as 5.00
But how "a" in "a5" will be converted into double?

Thanks

How difficult it would be to modify the query to use avg() function if you have understood the solution.

it would have been much easier for us to solve this issue if you have provided sample data along with the expected result.

you need to share your usersTbL table structure

Can you share your JSON data. Your question is not clear enough.

why not System.Threading.Thread.Sleep(5000);?

where is BookingEntity object? You need to show your complete code

+5

You need to check whether file is present at $MYSQLSERVER/home/mohitlakhwani/Desktop/Photos location

How about this?
DECLARE @TBL TABLE
(
RESERVATION_ID INT,
START_DATE DATETIME,
END_DATE DATETIME,
ROOM_ID INT
)

INSERT INTO @TBL
SELECT 1, '2016-01-01', '2016-01-03', 1
UNION ALL
SELECT 2, '2016-01-01', '2016-01-03', 2
UNION ALL
SELECT 3, '2016-01-02', '2016-01-02', 3
UNION ALL
SELECT 4, '2016-02-05', '2016-02-08', 1
UNION ALL
SELECT 5, '2016-02-25', '2016-03-01', 2
UNION ALL
SELECT 6, '2016-02-26', '2016-03-02', 1
UNION ALL
SELECT 7, '2016-03-01', '2016-03-03', 3
UNION ALL
SELECT 1, '2015-12-29', '2016-01-02', 4
UNION ALL
SELECT 1, '2015-01-01', '2016-01-04', 5

DECLARE @RNewSTartDate DATETIME = '2016-01-01'
DECLARE @RNewEndDate DATETIME = '2016-01-04'

select distinct ROOM_ID
from @TBL
where NOT @RNewSTartDate BETWEEN START_DATE AND END_DATE
AND NOT @RNewEndDate BETWEEN START_DATE AND END_DATE
AND NOT @RNewSTartDate >= START_DATE AND @RNewEndDate <= END_DATE

+5

On windows spaces between file names and folder names do create problems. For this particular problem, the application is not able to find the file and the most probable cause is space.

https://stackoverflow.com/questions/43510438/how-to-run-an-executable-that-contains-a-space-in-path-from-command-line-on-wind

hmmm, acknowledged!

I usually test code online when I get the time, otherwise use what is present in the question and add the knowledge I have :)

But thanks anyway.

true

+5

The error "Column Name or Number of Supplied values do not match table definition" is pretty straight forward. It simply means you have provided let's say 50 field names but you have provided 49 or 51 field values or provided field names do not match any fields in table. I don't think decimal/comma is an issue here because decimal/comma issue cause a different error.

Check your Insert SQL and see how many fields name and values have been passed.

Have you understood the Question completely?

Excellent!

Your code have garbages, forexample what is [="" void="" payroll="" ::display_info()]?

Well this is not self join and secondly why do you think the approach is wrong?

There are entire books, written on OOP, and you want us to explain it to you in a paragraph? Secondly, who has written the above code? Have you copy-pasted it from somewhere?

5+

By the way your pattern is not pyramid!

Memory are far more complex then what it seems. For a quick start you can try this:
var gcMemoryInfo = GC.GetGCMemoryInfo();
var installedMemory = gcMemoryInfo.TotalAvailableMemoryBytes;
// it will give the size of memory in MB
var physicalMemory = (double)installedMemory / 1048576.0;

For my laptop it is returing 16 GB, but you have to understand that this 16 GB is not available to your application.

I thought of writing a bit detail over memory but I found this great article that explain Memory in great detail.

https://www.codeproject.com/Articles/483475/Memory-Limits-in-a-NET-Process

Acknowledged! I will update as soon as I get time

what is abal++?

But why do you even need to transform it in Assembly in the first place?

Should not this be
$data['user_type'] => $data['$user_type'] and
$data['user_id_url'] => $data['$user_id_url'] ?

yes, put new Question so that every body can look and respond

Its not possible that 33900 rows cause SQL Server to go nuts. There must be some level of locks present that caused this issue. You need to Re Start SQL Server services and try executing the select query again

How many rows present in this table? And share the estimated execution Plan of the select query.

Share your SQL Server query

+5

You Win :)

My 2 Cents,
- why put a formula in cell B3 and not B2 (I guess you are assuming that there is a header line)
[Asif] You are absolutely right. CSV usually contains headers
- why is that formula referring to the previous row
[Asif] OP's "Blah Blah" is just an example, in real-world this constant text would definitely have meaning. Instead of hardcoding this text on each row, why not dedicate a row/column for this hard-coded text and reference it in all subsequent calls. Hence $A$1 is used. Secondly, if OP wants to change this constant text then he needs to change only once, the rest automatically gets updated.
- why use & " " & A2 when you can just add a space to the cell.
[Asif] Please refer to 2nd Point for The underlying reason
- Why use that extra row at all when you could have just used = "blah blah " & A2
[Asif] The reason for that extra row has been explained in the 2nd Point. Hard Coding is bad, bad, and bad
- Why copy to the entire column when you only need to go to row 100,000
[Asif] I meant the same, the entire column means from B3 till B100000
- Why paste into a new sheet when you can just paste over the existing one
[Asif] It's always good to have a rollback strategy. The second Sheet idea is to preserve the original data so that we can go back to the original data if something goes wrong.

DELETE CASCADE is the alternative way to delete child table tuples as well if parent tuple gets deleted although not recommended at all in almost all scenarios.

Check this link: https://www.sqlshack.com/delete-cascade-and-update-cascade-in-sql-server-foreign-key/

Thanks. If I remember correctly we could have upvoted the comments previously, now we can't?

Thanks for extending Solution 2 :) However, solution 2 should not take more than 2 minutes if one is fluent in Excel

I don't think type is an issue here, Check this link. https://stackoverflow.com/questions/53984800/how-to-encrypt-and-decrypt-integer-data-type-column-in-sql-server-using-symmetri

We have given you a direction to start. All you need to do now is to do some experiment.

have you tried setting admin credentials of the stated windows service -> Services -> My Service -> Properties -> Log On Tab?

Where have you been stuck> what error you are getting?

Your update seems wrong as you are setting id_per_before column but in query you are updating id_before column. The errors seems straight forward, which is foreign key violation.

A simple way to debug is to open SQL Profiler and try tracing this update and you will exactly know what update is executing.

OP can use the vulnerability part solution from OG's solution. My solution is usually direct and concise.

What is the final query you getting?

try executing the same query on MS Access query window. May be your date settings are different. it could be mm/dd/yy instead of dd/mm/yy

Table scanning is not the problem here, check the cost which is 0%. The problem is sorting which is 72% of the cost.

IFNULL would replace null with 0 for both left and right sides, which leads to 0 = 0, which is true hence null rows would get returned in the resultset.

Can you share a sample call to SetPrice? This would help us understand what value are you passing in Currency parameter?

thanks

You probably need to give full access rights to IIS_IUSRS User

MySQL version added

how dificult it would be to change it to mysql?

DECLARE @OrderType VARCHAR(MAX) = 'AE-Return'
IF @OrderType = 'Success'
Select Revenue - Cost From ERP_Source_Table
ELSE IF CHARINDEX ('Return',@OrderType) > 0
Select Revenue * -1 , Cost * -1 ,Sales_Man,Order_Date,Order_Type From ERP_Source_Table
ELSE
Select * from ERP_Source_Table

To be precise!

Why can't you try this?

https://stackoverflow.com/questions/13831472/using-a-variable-in-openrowset-query

You should try this
xcopy /s /i /y %~dp0\..\windows\Resources %~dp0\..\..\build\windows\x64\%value%\Resources

Show us the code you have tried, it seems you are asking us to do your homework :)

It seems that you have missed a single quotation here "RAISE_APPLICATION_ERROR (-20325, 'May not add a record with both payment and charge information.')"

hoping you have understood by yourself why its a syntax error. Anyway to fix it you need to look at following Tip

http://stackoverflow.com/questions/3735152/most-succinct-way-to-transform-a-csv-string-to-an-table-in-tsql


Your SP need to be altered to use above Tip, similar to something like this
select FId,DataTypeName from tbl_fieldname T
INNER JOIN dbo.Split(@dataval, ',') M ON T.DataTypeName = M.items

SPs need to be test separately, usually using SQL Server Management Studio. For example a test script could be like.

DECLARE @dataval VARCHAR(200)
SELECT @dataval = 'varchar';

EXEC datatype_Details @Dataval;

And check whether SP is working as per requirement. If not then fix the SP.

What exactly you mean when you say you can't find way to encrypt hosting information?

Share SP test script.

You need to share your SP code as well

Views are accessed as tables (they don't have specialize syntax) and correct syntax would be like
SELECT * FROM client_allergies_nondrug. That is :
.CommandText = "SELECT * FROM client_allergies_nondrug";

Why can't you have a single EXE to perform for all customers?

I am more interested in knowing what triggered the desire behavior

can you share your table structure and sample data?

This link suggest a workaround. https://social.msdn.microsoft.com/Forums/vstudio/en-US/7be543f0-b9d8-49e4-be4a-4c104ecfa139/length-property-of-fileinfo-class-returns-zero-size-when-the-file-coping?forum=netfxbcl

Can you share the results of below two queries
select TransactionID, ReplyID from TblTransactions where TransactionID in ('TN160200000011', 'TN160200000012', 'TN160200000013');
select VehicleID,ReplyID from TblConfirmedVehicleMap where VehicleID in (1, 2, 3);

seems like you are missing a join condition. Can you share the structure of TblTransactions and TblConfirmedVehicleMap

Try responding following queries :|
* This SQL Code is running fine on MS SQL Server?
* If yes then can you share DateBackBone(Date1, Date2) code here? you can view this code by executing below query in SQL Window
sp_helptext 'dbo.DateBackbone'

it's highly uncertain that people will understand your roman Urdu here at CP, try using google translate for Urdu To english translation and update your question using Improve Question link

DateBackbone is not part of MSSQL Server, its a user defined function. Share this UDF code of this function and what have you tried by the way?

"How should I get the result with out any logic" Can't understand what you meant here!

how you are connecting? Using SQL Server Management Studio -> Connect -> Database Engine -> Server Name -> IP Address?

can you share your bcp command which you are using to export

what is it so necessary to export in the .xls, .xlsx formats? .CSV is suffcient as it can be open in excel easily

so how can we turn this unfortunate event to fortune? :)

you have installed sql server 2012 on windows 2012 server and windows 7 workstation and after this you don't know how to connect to local database present on windows 7 work station and databases present on windows server 2012. is that right?

share, what have you done so far

Try readin this "http://stackoverflow.com/questions/9378313/display-new-mail-icon-in-windows-taskbar-using-vbscript", its almost identical of what you are doing and it works

there nothing seems to be wrong at line 1. can you show it here what your line 1 is

Try this: http://stackoverflow.com/questions/2023766/an-attempt-was-made-to-load-a-program-with-an-incorrect-format-even-when-the-p

you need to sanitize your input parameters

did you google?

if you have a fieled updatedOn which is more reliable then you can also order by UpdatedOn desc as well

You have a startdate column, why can't you try Order By c.StartDate desc?

what do you mean by "latest" one here?

can you share the results of these queries.
1. select distinct asset_number from SAMPLING
2. select distinct ASSET_NUMBER from scanitem

please share your employee xml schema

Quick response: "https://www.google.com.pk/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=email+id+validation+in+sql+server"

Can't read your mind! Wish, i could have a telepathic abilities :)

Your code seems Ok, are you correctly executing it?

Another approach might be to do the changes at database level, like creating a Stored Procedure in which you can use SELECT INTO clause that can create new table with new columns as well in 1 go

I have successfully executed a tweaked version of urs and its working fine.

Create table #temp1 (
invoicenumber int,
store varchar(255),
purchasedate datetime,
itemtype varchar(255),
totalprice money
)


Create table #temp2 (
invoicenumber int,
amount money
)

Insert INTO #temp1

SELECT 1,'a', getdate(), 'b', 100
UNION ALL
SELECT 2,'A', getdate(), 'b', 101


Insert INTO #temp2
Select invoicenumber, sum(totalprice)
From #temp1
Group by invoicenumber

select * from #temp2

It does not seem to have any problem, at which line you get this error

your given links are block, you need to share it in your question. Follow Improve Question link

where is that select query? Can't read your mind... right? :)

There are no shortcuts in learning, you have to do the hard way!

:D

what do you mean exactly when you say "but I don`t know which file i have to send and how can i send this code to the android."

Solutions are not meant for adding Comments, you can improve your solution 1 by selection mprove Solution link. Do delete this solution 2.

What is the result of this query "SELECT kpi.FK_Transporter ,kpi.`Month`, AVG(kpi.OnTimeDelivery) as avg_rate
FROM primarykpi as kpi,transporter as t
WHERE kpi.FK_Transporter=t.Id and YEAR(kpi.`Month`)=2016
GROUP BY FK_Transporter, MONTH(kpi.Month)"

you need to put your source code and xml here!

And what have you tried?

That is great! Now what formula you have regarding OpnStock and Item Purchase and Item sales?

Do you know the business behind OpeningStock/Purchases/Sales/ClosingStock?

Its not the right way to add comments, solution is meant for solution :) Please remove it and add the content in the question by clicking Improve Question button

+5

why you want to parse html at database level in the first place?

Try running it using administrative privileges.

how you executing it?

What is the actual error you are getting? You have not mentioned the problem you are getting while inserting?

Its pretty easy, check this http://stackoverflow.com/questions/8299069/using-xpath-to-parse-an-xml-document

This is the solution!

Why are you using XML in the first place if all you have to do is get the values of text boxes?

you now have a Solution

You have responded to 1.5 year old question, OP must have got the resolution by now :)

What have you tried?

The correct way of doing this is to use XML parser. I wonder why are you not using it. Did you look at this http://stackoverflow.com/questions/14153988/how-should-i-parse-this-xml-string-in-python?

How do vehicle.Insert() know that it has to call sp_VehicleInfo stored procedure? Where have you defined this? And there are problems in your SP as you are using the SP name in your INSERT INTO sp_VehicleInfo query

+5

Tested version of your solution.

DECLARE @EMP TABLE
(
EmpId int,
Name varchar(10)
)
;

DECLARE @Advance TABLE
(
advanceId int,
empId int,
AdvanceDate DateTime
)
;

INSERT INTO @EMP (EmpId, Name)
SELECT 1, 'A'
UNION ALL
SELECT 2, 'B'
UNION ALL
SELECT 3, 'C'
;

INSERT INTO @Advance (advanceId, empId, AdvanceDate)
SELECT 1, 1, '01-Jan-2015'
UNION ALL
SELECT 1, 1, '01-Jan-2016'
UNION ALL
SELECT 3, 1, '01-Feb-2016'
UNION ALL
SELECT 4, 2, '01-Jan-2016'
;

with AdvanceCnt as (
select
EmpId,
AdvanceDate,
ROW_NUMBER() over(partition by EmpId order by AdvanceDate) as rowid
from @Advance
WHERE AdvanceDate between '01-Jun-2015' AND '31-Jul-2016'
)
SELECT E.EMPID,
E.NAME, AC1.AdvanceDate as AdvanceDate1, AC2.AdvanceDate as AdvanceDate2
from @EMP E
LEFT OUTER JOIN AdvanceCnt AC1 on E.EMPID = AC1.EMPID AND AC1.ROWID = 1
LEFT OUTER JOIN AdvanceCnt AC2 on E.EMPID = AC2.EMPID AND AC2.ROWID = 2

Yes, you can do that as well, to me group by let you add more filters if needed later, kind of more adaptive (all you need to add is having filters)

You are not thinking! Points to ponder!
* Where have you declare the @rn? what is its type?
* SET @rn=0; SELECT @rn = @rn + 1 will always return 1! Why?
* Why have not you used AUTO_INCREMENT?

Would not @rn=0; Select @rn+1 will always turn out 1 also?

Try Debugging the code by using this query. Select 1 As `Sno`, perName As `Name`, speDesignation As `Designation`, speId As `SysId` From main.SupplierPeople Inner Join main.people On spePerId = perId Where speSupId = pSupplierId

+5ed

Let's just stick to your current problem now, we will look at your 100+ rate codes later, did you try executing the above query?

have you read CTE (Common Table Expression)? Your problem is recursive by nature hence can be easily solved by a CTE. Do google like "SQL CTE sample", then try writing a CTE, once you have started let us know where you have stuck

write your sql here so we could fix it

Its homework and we don't do homework! Sorry
What have you tried by the way?

have you debug it?

You probably have missed a ';' somewhere in your code.

where is the question?

You now need to check your update query, one way of debugging is to change your update to SELECT and see your return result conforms to what you expect, like for example check below query and analyse what is wrong?
SELECT School.DateTravelPlanSubmitted, SchoolSignDate.SignoffSchoolDateMax
FROM School
INNER JOIN SignOff ON School.SchoolID = SignOff.SchoolID
inner join (select SignOff.SchoolID,SignoffSchoolDateMax=max(SignOff.SignedOffBySchoolDate)
from SignOff
inner join School on School.SchoolID=SignOff.SchoolID
group by SignOff.SchoolID)
SchoolSignDate on SchoolSignDate.SchoolID=School.SchoolID

+5ed

what have you tried?

This is homework right?

Can you share your rows that has been duplicated with the original one?

You need to use Question and Comment button to add comments instead of adding comments as solution. Please remove this solution

+5

:)

The Table list you are seeing @SQLDeveloper are tables that are present in the Oracle Database regardless of who has created what. SQLDeveloper or no other tool can differentiate table owners the way you want.

Since you have created 10 tables then how hard it is to remember all?

Yes, that's true, this is the solution, post it as solution

show your code

I don't know your business case but usually Transactions do not get purge because of strict regulatory archiving policy. why don't you archive transactions for a day and get the count from archived table/repository.

Are you purging records or archiving ? for every 30 mins

Have you updated this,
string ozSURL = "url_to_be_provided";

You are trying to build a Windows Explorer Extension?

Told you already, its a quick solution, correct way would be to identify why your Category xml has duplicate entry in the first place.

I have modified the solution, check again

ok, so if i understood you correctly you want this
and (GradutionYear =2016 and isnumeric(GradutionYear)=1 and GradutionYear<>0 ) and (Rank in(53322,53323,53324,53325,53327,53328,53329,53330,158676,158677,158678,158679)) to be this
and (GradutionYear =2016 and isnumeric(GradutionYear)=1 and GradutionYear<>0 ) and (Rank in('53322','53323','53324','53325','53327','53328','53329','53330','158676','158677','158678','158679')) for all rows...right?

What is a POPUP? do you mean server will broadcast a message to all connected clients and this message will show as a popup over desktop of clients?

ic, you need to improve your question by adding all these information, secondly what about comment filter? what is the role of comment filter in your query?

show us 10 sample rows and the desired result in tabular form

instead of adding new solution you should update your first solution by using Improve SOlution button

none of these values will get update because none of the columns contains and ' and (Rank in(1321619,1232323,123131)) and (Comment like '%2016%')'... right?

put rows that have your values that you like to change

Can you put 10 rows here to have an idea what kind of data you have in column

how did you assume that i update for a single row? did you try adding multiple rows in @TBL and see what is going on?

:D

why are you continuously clicking the exe file? stop continuous click and problem might go away :)

Can you elevate the access right of the application to administrator and execute the application again and see does this solve your problem?

what error are you getting ? what is the datatype of itemcode field?

+5

Isn't the error is clear? SQL Serevr is not able to understand what is '06.06.2015'. change it to '06-Jun-2015' and test again.

Did you look at SQL Server Replication?

Which version of Visual Studio are you using for setup building?

It means that one of your column have received data larger than their allocated space.
You need to extend your column sizes and try again. Check which column have got broken

which error? Do remember, we can't read your screen, your hard disk, your mind. So help yourself by helping us

ROFL :D

What have you tried?

Write the command that is generating this error!

How about sharing your code with us so that we look whats getting wrong?

Well you can easily find the issue by just dropping a break point over objMaintenane.Expenses.Add(i) line and debug it, check what insert query is generating to DB. This is a minute job and you can do it

My guess is OP wants to build an application that automatically gets updated without giving a prompt to user. Some thing like Smart Client application that gets updated without given a notification to the user that a new version is present at server or i might be wrong totally :)

You need to provide schema information, specially how you going to filter data based on date. Do you have created_on type of column n all tables?

Have made changes to the solution. Try the new one

You can do a loop over table, store the process_date in a variable @TABLENAME and then finally PRINT that variable as you are showing in ur comment :) though i can't comprehend what actually you are trying to acheive

It seems like you are writing some ETL for BI analysis. Why can't you refresh your facttranemp by purging it entirely and regenerating on each day?