This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 28.999999999999996%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHL%3C/text%3E%3C/svg%3E)
Hello everyone,
Please see our questions below:
Our question: How can we perform SQL for one single table?
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
Additional SQL Server features and topics not covered by specific categories
Our company data comprises just ONE big table. We divided it by the WZ code, because otherwise it would be too large and we would lose sight.
This sounds very funny to me. Most company has a business which is complex enough to comprise many entities. For instance, Customers, Products, Employees, Forecasts etc. If you have put all of that in a single table, you might have done something wrong.
And I don't have the foggiest idea what a WZ code is.
As Bjoern says, we need some more details about your table(s), for instance the CREATE TABLE statement.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 52%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Hi @Hannah Lee
Sorry I don't understand your requirements very well, please provide more sample data or details about your issue.
Best regards,
LiHong
Can you show us your data structure? Either as a sketch or as a DDL or screenshots?1
Without any information on your environment, your system, and your "data layout," we cannot give you any (working) advice.
Maybe it is just a simple "JOIN," or it can be a complex workflow...
Sorry, I don't understand what you have on table(s) (you wrote one?) and what your requirements are?
May can you explain it detailed, please?