Andomar

Netherlands

Age: 40

I'm a software developer at a telco supporting line-of-business applications. We use a variety of technologies from ASP.NET to Perl. I've come to appreciate SQL more over time, and I now spend most of my time in the database.

If you'd like to learn SQL properly, consider the awesome free SQL course from Stanford. The organization behind the course offers many other classes. I'm enjoying the Fantasy and Science Fiction course.

16h
awarded Nice Answer
16h
awarded Notable Question
1d
awarded Enlightened
Jul
25
comment Using stored procedures of another database
The error message suggests that the table does not exist. Are you sure there is a database2 on the same server, that has a Subject table in the dbo schema?
Jul
25
answered Using stored procedures of another database
Jul
25
revised String str in a condition where of plsql
added 37 characters in body
Jul
25
comment SQL get ROW_NUMBER and COUNT on every SELECT request
In my tests this is the best performing solution. If I were you I'd write a few alternatives and test them!
Jul
24
comment Find distinct values from two columns
The queries are equivalent (if the database is smart enough to see that * matches the group by.) Why would distinct perform better depending on the table definition?
Jul
24
revised SQL get ROW_NUMBER and COUNT on every SELECT request
added 73 characters in body
Jul
24
answered SQL get ROW_NUMBER and COUNT on every SELECT request
Jul
24
comment Sql server ignoring numerator as per denominator
@RBarryYoung: Good point :)
Jul
24
revised Sql server ignoring numerator as per denominator
added 105 characters in body
Jul
24
revised Sql server ignoring numerator as per denominator
added 148 characters in body
Jul
24
answered Sql server ignoring numerator as per denominator
Jul
24
answered How do I name the results of a joined table query
Jul
20
awarded database
Jul
19
answered how do i calculate the total billed amount for a particular day?
Jul
19
answered union all two table but diff number of column
Jul
18
answered Is it possible to get the ID of the row being inserted *in the statement*?
Jul
18
comment SQL Query - Range two dates - including nulls
@SeanLange: Here's a pastebin example
1 2 3 4 5