juergen d

Argentina

Age: 37

I learn a lot by participating on Stack Exchange. I like that!


profile for juergen d on Stack Exchanges

5h
awarded Citizen Patrol
7h
comment MySQL Order by Results of SUM
@MykolaEvpak: Sure, if it makes sense to you. There is nothing that prevents that. But in this case here ordering by a calculation of something you select seems totally reasonable.
7h
comment MySQL Order by Results of SUM
@MykolaEvpak: Of course you can order by a calculation.
16h
comment Is it better to store many booleans in one column or many?
-1 for the first sentance. Look this up yourself in the docs.
16h
revised Creating articles programmatically: you have an error in your SQL syntax;
added 5 characters in body
16h
revised How to get minimum unused number from a column in Oracle?
added 48 characters in body; edited tags
1d
comment What's the order of operation of a SQL update statement?
What do you mean?
1d
comment Is float used when you don't know how many digits a number will have?
The important part would be to know what you want to store
1d
comment Group by id and select most recent
@lurker: OP does not want any status, but the one from the last date
1d
answered Insert/Update unique numerical value in SQL Server Compact Edition
1d
comment MySQL filter on column value within multiple rows?
But in your where clause you only look at AND ItemName IN ('camera','phone'). So it does not matter if there are others
1d
answered MySQL filter on column value within multiple rows?
1d
comment Forward Thinking Systems: spam or not?
I recommend flag one of the posts in the future and explain all that to a moderator. No need to discuss this in public.
2d
comment How can I change a column value in MSSQL 2008 to NEGATIVE based on the condition of another field?
No idea what you mean. But you can use dynamic SQL. Look up EXEC()
2d
comment convert tostring to datetime in sql
And the problem with your code is?
2d
revised convert tostring to datetime in sql
deleted 7 characters in body
2d
comment SQL Adding Within Statment
For the resulting temp table of those 3 lines
2d
comment SQL Adding Within Statment
Start of last line: t2 on t1.orderid = t2.orderid. t2 is the alias for the subquery
2d
answered SQL Adding Within Statment
2d
comment how to insert value in single column for multiple rows?
I just did that.
1 2 3 4 5