Skip to content

Group by question in SQL Server, migration from MySQL

Failed finding a solution to my problem, would love your help. ~~ Post has been edited to have only one question ~~- Group by one query while selecting multiple columns. In MySQL you can simply group by whatever you want, and it will still select all of them, so if for example I wanted to select the newest 100 transactions,

SQL join table with 12 column composite PK with itself painlessly

I have a table with a composite natural primary key that involves 12 columns (c1, c2, …, c12). I want to write a self join query: This join is a pain to write. Is there a better way? Answer Personally, if you must have a 12 column “key”, I would DROP that key, and create a computed column that concatenates

Need to Update based on ID and Date

I have the following SQL statement, which I think should update 1 field, using some pretty simple standard deviation logic, and based on ID and Date. I think the ID and Date has to be included to get …

Save other ID in database

I have 2 table here : 1. tblPurItem : itemID, categoryID, purchaseMeasurementID, stockMeasurementID, calculationMeasurementID, retailrecipeID 2. tblRecipe : recipeID, recipeName, …