Microsoft SQL Server | Forum profile

The dependency Dave is talking about is 2NF. 5NF doesn't apply here - for 5NF there must be a composite key of three or more attributes and no none-key attributes.

Code: SELECT left(P.productID, 2) as category, P.productID, P.inventory_count FROM products as P INNER JOIN (SELECT left(productID,2) as category, max(inventory_count) as max_inventory_count FROM products where inventory_count > 0 and active_product=1 GROUP BY left(productID,2) ) AS C ON left(P.productID,2) = C.category AND P.inventory_count = C.max_inventory_count If multiple Products have the same (highest) inventory_count, they will...

Hi, I have 3 stored procedures each executing insert statements in the db. I am using ASP.NET to pass parameters from and to the stored procedures by handling their data sources' events. - First procedure inserts a record in a table returning the newly inserted row - Second procedure gets this value and and uses it for insertion to other tables The problem is all the insert statements in those 2 procedures need to succeed before being...

Quote: Originally Posted by pootle flump Even though I was logged in using a SQL Server login, the wizard defaulted to authenticating using windows authentication - I had to re-enter my SQL Server log in details ****I bet this is where your process is going wrong - do these people have access to the database via windows authentication?**** You are correct - The Database defaults to Windows on my machine and works because I already have access...

you're confusing me, because you are combining a date and a "number" How is that suppose the be a valid date/time?

Quote: Originally Posted by duro when the items are the same it returns all the rows Which row do you want to return if there are several rows with the same highest inventory_count? You need to be more specific about your selection criteria.

Data is currently being imported from SQL into an excel sheet starting in column B. In column A the following formula is concatenating the data =B124&C124. On several other tabs the date is on the X axis and a Cost Center (CC) is on the Y axis. The following formula populates the table based on the SQL data being imported =IF(ISNA(VLOOKUP(P$7&$H18,Data!$A:$D,4,FALSE)),0,V LOOKUP(P$7&$H18,Data!$A:$D,4,FALSE)) The end...

Quote: Originally Posted by dportas Couldn't the price per product change during the period specified by "Halyyear"? i'm guessing it's a typo, and should actually be "halfyear", with 1HF09 representing the first half of 2009, while 2HF09 is the second half do you think the unitprice and quantity should be in separate tables? what would that be, 5NF? 6NF? are unitprice and quantity even...

Is this any good? Code: DECLARE @addresses table ( post_code char(8) ) INSERT INTO @addresses (post_code) VALUES ('SW185NT') INSERT INTO @addresses (post_code) VALUES ('SW18 7RT') INSERT INTO @addresses (post_code) VALUES ('SW15XQ') INSERT INTO @addresses (post_code) VALUES ('NW2 6TT') INSERT INTO @addresses (post_code) VALUES ('SW18 5NT') INSERT INTO @addresses (post_code) VALUES...

Hello experts, I’m having a challenge in writing a simple delete statement. I’ve a table (FirstLevelChangeDetail) which has same number to 2 fields (CapturedDate & DbTotal) however there is the 3rd entity which is RecordNumber and it’s different. I’ve 5 rows which have same CapturedDate and DbTotal but Different RecordNumber. I still need to delete them even though they are different records. When I wrote the following select...