Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LonnieM
Starting Member
15 Posts |
 Posted - 2008-12-08 : 14:54:09
|
| Hello All,I have a large table of items or SKU’s that contains stocking flag by column ([01], [02],[03]…[50]). The name of each column corresponds to an actual stocking location code in another table. The data in these columns is also the same as the column name (i.e. [01], [02]) or it is NULL if the item is not in that location. In this same table I have a column [Optimum] that lists the code for the optimal location to pull this item or stock from. I need to be able to determine if the value in the [optimum] column has a match in the appropriate stocking location columns. (I need to tell the table to check the appropriate column ([01], [02] etc…) and see if there is a value (anything other than “NULL”) in that column.)I am thinking I need to read the [Optimum] column value into a variable and then somehow check that column (and record) for a match. Any better ideas or thoughts on how I might do this?1) Before you answer … I am fairly “stuck” with this table design. I would be open to hearing any better design ideas but am somewhat limited in what I can implement.2) Please be explicit in any coding suggestions as I am fairly limited ? here as well.I hope I have explained this well enough, if not please email me back for any clarification necessary.Thank you,Lonnie M |
|
|
|
|
|
RE: Variable or Any Advice