juergen d

Argentina

Age: 37

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

profile for juergen d on Stack Exchanges

12h
answered query last value
12h
comment Sqlite Query can't get 100%
Why round anyway? You use int values. So the calculation's result is int too
12h
comment Would a query run in a try statement that failed if it was before the error occured?
If you put a transaction around the code then you can roll back everything when an error occurs.
22h
awarded Nice Answer
1d
revised TNeed to filter out same reps on same order# and sales code
added 12 characters in body
1d
revised How to emulate ISNOTNULL()
added 159 characters in body
1d
answered How to emulate ISNOTNULL()
1d
comment How to emulate ISNOTNULL()
What do you want to do? Count how many times the field is not null?
1d
comment What is the name of the second user in a table?
That is totally opinion based and off-topic as such
1d
comment Why can't I MATCH() AGAINST() one of the columns in my FULLTEXT index?
stackoverflow.com/a/3381924/575376
1d
comment Why can't I MATCH() AGAINST() one of the columns in my FULLTEXT index?
If 50% of your records contain the text you search for, then it will be ignored. Is this the case for you?
1d
revised SQL Select questions
added 20 characters in body
1d
comment Rearrange string in SQL
Never, never, never store multiple values in a single column. You are better off by changing your DB design.
1d
answered mysql date comparison only comparing year
2d
awarded order
2d
comment Joining to child data which may or may not have data for each record in parent table
Use left join instead of join or inner join
May
25
reviewed Close Delete multiple rows error
May
25
reviewed Close reports/charts from a MySQL DB
May
24
awarded Custodian
May
24
reviewed Edit crystal report how to display date in boxes of Bank Check Book
1 2 3 4 5