4,221 reputation
42356
bio website jcolebrand.info
location Plano, LA
age 35
visits member for 3 years, 10 months
seen yesterday

I'm now working for a group out of Plano, doing primarily front-end work for mobile and online banking for credit unions. Time for me to get involved in the local user groups!

combined Stack Exchange profiles for jcolebrand

You probably want to gmail me if you need me directly. If I have to tell you what gmail address to guess at, you're not trying hard enough.

Everything else can be found at http://jcolebrand.info or http://about.me/jcolebrand


Nov
3
awarded  Good Question
Oct
25
comment Don't know how to transform variable entity into relational table
I would also suggest that breed is an attribute that all animals share, just in different ways.
Oct
21
comment Retrieving month from date field in my database
@Serg how often do you find yourself writing queries to do things that have no user interaction? What if the user were able to supply a given month and year, instead of us taking the current month and year from curdate()? I think that we should contemplate how to provide a parameterized query to find the data the user wants, and then as Aaron indicated, help the user figure out how to apply indexes to best give us the data quickly, so we don't have to do table scans.
Oct
21
comment Retrieving month from date field in my database
@Serg you may want to re-read the question and contemplate your answer, and possibly give more details on how this would be used, and what the value you've done above actually does in response to a UI selection of month and date.
Oct
21
comment Retrieving month from date field in my database
@ypercube sure it does. It just doesn't let the user select the actual month they want. What OP needs is a clear stored procedure that does basic TSQL (which means this is an SO Q) but what this answer offers is a RAD approach designed to indicate quickly in a demo how the product should work and as such I consider the informality of this post quite the avant garde expression for how little effort would go into such a query. I can definitely understand the delicate cycle of decision that led to this new poster on our site sharing such a simple selection, and allowing us to infer the obvious
Oct
17
awarded  Popular Question
Oct
13
comment Write filename, servername/IP and date+time in spool file
Hi will and thanks for the answer, but could you add a bit of explanation for those who don't speak PLSQL natively? This answer looks spammish to some of our readers because they don't understand what you're encouraging Jorge to do!
Sep
30
awarded  Explainer
Aug
28
revised Memory Issue - SQL Server 2008r2
deleted 27027 characters in body
Aug
13
revised Query for row combine
added 534 characters in body
Aug
5
comment Invalid date format in SSIS
@user3793534 when the answer proves to be your solution, you should check the checkmark underneath the votes on the left-hand side. We can provide further details if you need more assistance. Thank you.
Aug
5
revised VBA Maximize Access Application Main Window
added 28 characters in body
Aug
5
comment VBA Maximize Access Application Main Window
@MattyZDBA you should likely post that as the answer, as nothing else seems to have occurred here and that seems to have been the solution
Aug
5
revised Deny permissions for master in SQL Server
edited tags
Aug
5
revised Time series indexing
edited tags
Jul
29
revised Problems with foreign keys in a mysql database
added 34 characters in body
Jul
29
revised Different column for different conditions when joining
added 1530 characters in body
Jul
22
revised What does reslen and other means in mongodb log?
added 4 characters in body
Jul
18
revised Inheritance discriminator column better int or varchar or enum?
deleted 131 characters in body
Jul
7
comment MySQL replication working fine, but still shows “Waiting for master to send event” at 280000 seconds
No, not really.