This site is devoted to Transact-SQL (MS SQL Server), so you may not get an answer to a MySQL question.

Drew

Please do a little research and look up the design flaw called EAV. You are reinventing it, and on top of that, you added assembly language style bit flags....

1 Don't concatenate the strings, that's more overhead, just check the len of each: LEN([address 1]) + LEN([address 2]) + LEN([address 3]) = 0 /*easier, to me*/ OR (LEN([address...

Itzik Ben-Gan did a series of articles on intervals and counts which can be modified to answer your question.  Here is the first article in the series.  Had you...

I use SQL Prompt at a previous employer, so I am quite familiar with it.

Snippets was one of the reasons that I requested SQL Prompt here.  Although, I edited the...

After almost a year, I finally got a license for RedGate SQL Essentials.  SQL Prompt is so much better than the native Intellisense.

Drew

The logic for the rows that you want to return is unclear.  For instance, if you supply "Emp = 1 and HeaderID = 123 and Status = Failed" why should...

I would recommend against this.  You're likely to break things in ways that aren't obvious.

Drew

I just know that Drew is going to post a really snappy solution to this one ... that's what usually happens after I post my overblown version. But here...

Your code works , if you place the columns as you want to see result ( as example i provided) , but if i place all the columns in...

I have read many great helpful articles on Tally Tables by Jeff Moden, Lynn Pettis, and many others; however I haven't seen one on how to allocate quantities using...

There is also a problem with your formula.

• You're dividing your seconds by 10.0 and then rounding.
• You're then multiplying by 30 and changing the units to minutes.

  • This is...

Why are you trying to make a database program behave like a spreadsheet?  They are two very different tools and they both have their uses.  Use the right tool for...

XML is case sensitive.  Your bulk insert use DateofBirth but your VB script uses Dateofbirth.  Make sure that the case matches.

Drew

That's what comes from using a formula that you found on the web without understanding exactly what it is doing.  The zero that you are using is a shortcut for...

• This reply was modified 6 years, 2 months ago by drew.allen.