Matthew

Reno, NV

Age: 26

I'm an AV geek at heart but I love programming.

11h
comment How to match patterns stored in SQL table
Do you need to store 'today is [date]' or can you just store 'today is' and have another column indicating the '[date]' part?
11h
comment From two tables to one
Can you elaborate on what you're trying to do?
1d
awarded Caucus
1d
awarded Constituent
2d
answered Do conditional INSERT with SQL?
2d
answered How to convert a SQL date to a DateTime?
May
18
comment Explode range of integers out for joining in SQL
Yes, I see that you JOINed on the BETWEEN .. it's a good solution
May
18
comment Explode range of integers out for joining in SQL
+1 for putting my general solution into code and testing it!
May
18
comment multiple threads in for each loop
@Cherry glad I could help. Maybe you can post the code you ended up using?
May
18
awarded Enlightened
May
18
comment how to generate all possible equations with a set of number and operators?
I don't think it's infinite, I think it's ((N! * N) - 1) * 4 ... that's a rough guess, still an awful lot of possibilities to test individually.
May
18
revised Explode range of integers out for joining in SQL
added 131 characters in body
May
17
revised Explode range of integers out for joining in SQL
added 55 characters in body
May
17
revised Explode range of integers out for joining in SQL
added 55 characters in body
May
17
revised Explode range of integers out for joining in SQL
added 55 characters in body
May
17
answered Explode range of integers out for joining in SQL
May
17
comment Explode range of integers out for joining in SQL
Can you use CLR?
May
17
comment Explode range of integers out for joining in SQL
Is it possible to have the application code "explode" the string before going to sql? SQL server can do this, but it's not ideal.
May
17
comment INSERT values from one table to another with the same ID NUMBERS
+1 assuming he doesn't want to just duplicate the columns indicated.
May
17
comment need efficient database model
We all need an efficient database model!
1 2 3 4 5