We have one single hash (#) table, in which we insert data processing
priority wise (after calculating priority).
for. e.g.
Company Product Priority Prod. Qty Prod_Plan_Date
C1 P1 1 100
C1 P2 2 50
C1 P3 3 30
C2 P1 1 200
C2 P4 2 40
C2 P5 3 10
There is a problem when accessing data for usage priority wise.
Problem is as follows:
We want to plan production date as per group (company) sorted order and
priority wise.
==>With less data, it works fine.
==>But when there are more records for e.g. 100000 or more , it changes
the logical order of data
So plan date calculation gets effected.
==Although I have solved this problem with putting identity column and
checking in where condition.
But, I want to know why this problem is coming.
If anybody have come across this similar problem, please let me know
the reason and your solution.
IS IT SQL SERVER PROBLEM?
Thanks & Regards,
T.S.Negi 5 4438
> when there are more records for e.g. 100000 or more , it changes the logical order of data
Are you referring to the perceived order in the table? Rows in tables
have NO logical order in a relational database. If you require a
particular order you have to query them using a SELECT statement with
an ORDER BY clause otherwise the ordering is undefined.
If that doesn't answer your question then please describe your problem
with DDL (including keys), sample data INSERT statements and show your
required end result.
--
David Portas
SQL Server MVP
--
While inserting records in hash table. It is already order by on some
fields.
But when selecting/updating records, I want the same order of records
should be updated/selected.
"Rows in tables have NO logical order in a relational database"
I think, True for hash(#) and permanent table.
T.S.Negi
David Portas wrote: when there are more records for e.g. 100000 or more , it changes the logical order of data Are you referring to the perceived order in the table? Rows in tables have NO logical order in a relational database. If you require a particular order you have to query them using a SELECT statement with an ORDER BY clause otherwise the ordering is undefined.
If that doesn't answer your question then please describe your
problem with DDL (including keys), sample data INSERT statements and show
your required end result.
-- David Portas SQL Server MVP --
There is an update condition. Which I want to make sure, performing on
ordered data (order by used at the time of insert).
I want to avoide loop.
Reason: "Rows in tables have NO logical order in a relational database"
!!!!
So Please advice.
Thanks,
T.S.Negi
Sample SQL:
===========
UPDATE #WK_PDR_Process ingData SET
@Opn_Stock_Qty= CASE WHEN (
@Customer_Cd = Customer_Cd
AND @Product_No = Product_No
AND @Product_Site_C d = Product_Site_Cd
AND @Assy_Company_C d = Assy_Company_Cd
AND @Assy_Section_C d = Assy_Section_Cd
AND @Line_Cd = Line_Cd
) THEN @Opn_Stock_Qty + @Production_Qty - @Requirement_Qt y
ELSE begin_Stock_Qty END,
Calc_Stock_Qty= @Opn_Stock_Qty + Production_Qty - Requirement_Qty ,
@Customer_Cd = Customer_Cd,
@Product_No = Product_No,
@Product_Site_C d = Product_Site_Cd ,
@Assy_Company_C d = Assy_Company_Cd ,
@Assy_Section_C d = Assy_Section_Cd ,
@Line_Cd = Line_Cd,
@Production_Qty = Production_Qty,
@Requirement_Qt y = Requirement_Qty
FROM #WK_PDR_Process ingData ti********@mind-infotech.com (ti********@min d-infotech.com) writes: While inserting records in hash table. It is already order by on some fields.
And once it is inserted, there is no longer any order.
But when selecting/updating records, I want the same order of records should be updated/selected.
"Rows in tables have NO logical order in a relational database" I think, True for hash(#) and permanent table.
Well, obviously you have some operation that does not give you the
desired result, and you posted an UPDATE statement, which is a little
funny, because all you do is to assign a variable.
I suggest that you follow the standard recommendation and post:
o CREATE TABLE statement for your table(s)
o INSERT statements with sample data.
o The desired result given the sample.
o A short narrative of what ou are trying to achieve.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
UPDATEs are not ordered either. The result of your UPDATE statement is
undefined, unreliable and, in my view, not useful.
Please specify the whole problem rather than post fragments of your
non-working solution. The best way to specify the problem is to post
DDL, sample data and required end results. See: http://www.aspfaq.com/etiquette.asp?id=5006
--
David Portas
SQL Server MVP
-- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: toedipper |
last post by:
Hello,
I am designing a table of vehicle types, nothing special, just a list of
unique vehicle types such as truck, lorry, bike, motor bike, plane, tractor
etc etc
For the table design I am proposing a single column table with a field name
called vehicle_type and this will contain the vehicle type.
Sot it will be
|
by: andreas.maurer1971 |
last post by:
Hi all,
since a few years I use the following statement to find duplicate
entries in a table:
SELECT t1.id, t2.id,...
FROM table AS t1 INNER JOIN table AS t2
ON t1.field = t2.field
WHERE t1.id < t2.id
|
by: John A Fotheringham |
last post by:
I've probably not given the best title to this topic, but that
reflects my relative "newbie" status.
I have a table that goes essentially
TS DATETIME
jobnumber VARCHAR
jobentry VARCHAR
...
|
by: flipdog |
last post by:
Hello all,
I didn't know there is a thread on hash function started in this newsgroup
so reposted my posting from another group.
Hope I can have some feedbacks. I am new to hash table.
I came across a very well presented tutorial web page wrt hash table. In
its content, it listed a number of hash functions which the web master(?)
quoted...
|
by: kaosyeti |
last post by:
i have a (hopefully) small problem. i have created a system where a user
enters customer information into a table through a form. this table has no
primary key. there are 9 fields on the form to be filled in, one of which is
a date field. right now, i've been using this db myself and have entered
only 10 days of sample data to check my...
| |
by: Johan Tibell |
last post by:
I would be grateful if someone had a minute or two to review my hash
table implementation. It's not yet commented but hopefully it's short
and idiomatic enough to be readable. Some of the code (i.e. the
get_hash function) is borrowed from various snippets I found on the
net. Thee free function could probably need some love. I have been...
|
by: shaanxxx |
last post by:
I wanted to write hash function float or double. Any suggestion would
be appreciated.
|
by: ravi |
last post by:
Hi
can anybody tell me that which ds will be best suited to implement a
hash table in C/C++
thanx. in advanced
|
by: Miley |
last post by:
Hi everyone,
This is my question/problem.
I have a table with orders and a table with order details.
Clients can order multiple products at once during one order, so one line has to be inserted in the main order table, and multiple order details from the same order in the order detail table.
How do I do this?
Right now if a client...
|
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...
|
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. ...
| |
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...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |