Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
HELP!!! I want to Update a column in SQLServer
This is working: UPDATE F_omzet SET kostenplaatscategoriekey = '1' WHERE inkoopomzet >= 0.2 * (SELECT SUM(inkoopomzet) FROM F_omzet) Thanx for the answer but i have this now and i want more. Maybe you can help me with that to. I want something like this : UPDATE F_omzet SET... -
Want to make a formula!!
HELP!!! I want to Update a column in SQLServer I want to make a update, but i tried a lot. But it isnt working. Has to be something like this : Update F_omzet Set kostenplaatscategoriekey = '1' HAVING (inkoopomzet * 100 / SUM(inkoopomzet) >= 20 ) The table name = F_omzet. Every row = <NULL>...- steefmen
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
HELP!!! I want to Update a column in SQLServer
I want to make a update, but i tried a lot. But it isnt working. Has to be something like this : Update F_omzet Set kostenplaatscategoriekey = '1' HAVING (inkoopomzet * 100 / SUM(inkoopomzet) >= 20 ) The table name = F_omzet. Every row = <NULL> inside of kostenplaatscategoriekey. The formula...
