Viewing 15 posts - 1,741 through 1,755 (of 2,458 total)
TheSQLGuru (3/4/2015)
Nevyn (3/4/2015)
SELECT PERSID,
CASE MAX(CASE DUESTATUS
WHEN 'Overdue' THEN 2
WHEN 'DUE' THEN 1
ELSE 0
END)
WHEN 2 THEN 'Overdue'
WHEN 1 THEN 'Due'
ELSE 'Unknown'
END DUESTATUS,
CASE MAX(CASE...
March 4, 2015 at 1:58 pm
I personally hate cursors because the syntax is bloated, counter-intuitive and just plain ridiculous. I have been writing SQL for 15+ years and still need to reference Books online or...
March 4, 2015 at 1:53 pm
DerbyNeal (2/25/2015)
You would handle this in the default value for each child parameter. Make the default value the same as the available values
Hi Alan,
Thank you for your reply, I appreciate...
February 25, 2015 at 6:28 pm
Sean Lange (1/30/2015)
Jeff Moden (1/30/2015)
Sean Lange (1/30/2015)
Jeff Moden (1/29/2015)
Sean Lange (1/29/2015)
Alan.B (1/29/2015)
I am certainly not anywhere at the same DBA skill level as say Jeff, Gail or Sean...
Gosh I am...
February 24, 2015 at 10:49 pm
Jeff Moden (1/29/2015)
Sean Lange (1/29/2015)
Alan.B (1/29/2015)
I am certainly not anywhere at the same DBA skill level as say Jeff, Gail or Sean...
Gosh I am humbled to be grouped with those...
February 24, 2015 at 10:23 pm
Sean Lange (1/29/2015)
Alan.B (1/29/2015)
I am certainly not anywhere at the same DBA skill level as say Jeff, Gail or Sean...
Gosh I am humbled to be grouped with those two in...
February 24, 2015 at 10:20 pm
I have created a report that contains a cascading drop-down. My problem is, when selections are changed/updated
on the parent (Customer Stopped Status) drop-down I need all of the resulting...
February 24, 2015 at 3:39 pm
Do you have any DDL? Sample data? Example of the desired output?
February 24, 2015 at 3:30 pm
ChrisM@Work (2/24/2015)
SQLRNNR (2/24/2015)
ChrisM@Work (2/24/2015)
Dogma spawns bad code as efficiently as laziness and ignorance.Nice. Great quote. I'm gonna use it now.:-D
That’s Plan B. Plan A was one of those...
February 24, 2015 at 12:14 pm
PHYData DBA (2/24/2015)
I stopped at the 5th time I saw "Select *" used in the code for an article about...
February 24, 2015 at 11:10 am
What Steve said (I just saw his response as I was about to reply)...
This is a good article SSC on the apostrophe topic... http://www.sqlservercentral.com/articles/T-SQL/95670/
February 24, 2015 at 10:28 am
Absolutely Brilliant article Gary, 5 stars! I really enjoyed the discussion about TVFs. Very good work sir!
February 24, 2015 at 7:12 am
Ditto what Gazareth said...
Do many shops use this design?
My experience has been - yes.
February 20, 2015 at 11:59 am
SQL Server Central is a goldmine. Read the stairways (which has already been mentioned), the blogs and the free redgate press books (especially the "Accidental DBA book".)
I would suggest...
February 19, 2015 at 7:44 pm
Anything that is not in the form of: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx where x is a hexadecimal value (e.g. 0-9 A-F) is going to fail... are c.evs_OrderIDid and b.ORdernumber formatted like that?
why...
February 19, 2015 at 7:38 pm
Viewing 15 posts - 1,741 through 1,755 (of 2,458 total)