DarenR's Profile User Rating: -----

Reputation: 518 Enlightened
Group:
Active Members
Active Posts:
3,497 (1.58 per day)
Joined:
12-January 10
Profile Views:
32,767
Last Active:
User is offline Feb 05 2016 04:27 AM
Currently:
Offline

Previous Fields

Country:
US
OS Preference:
Who Cares
Favorite Browser:
Who Cares
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Who Cares
Your Car:
Nissan
Dream Kudos:
0

Latest Visitors

Icon   DarenR sleepy

Posts I've Made

  1. In Topic: I created an ER Diagram for a room rental, and i have some questions

    Posted 4 Feb 2016

    payment and booking should have a pk booking_id pointing to fk booking_id and the same with payment
    also why do you have client id on almost all your tables?

    since booking has a client id and client has a client id -- you dont really need one in payment
  2. In Topic: Need help waiting for an external event from within a stored procedure

    Posted 4 Feb 2016

    Yeah use the KISS method-- ive found this usually fixes a lot of head aches
  3. In Topic: Need help waiting for an external event from within a stored procedure

    Posted 4 Feb 2016

    yes resources do return but in your case youre using some to run pr 1 and then more when you run pr 2 and if i read this correctly pr1 will always be running?
    you could try what that ms site tells you or you can try to code the code behind in the app on your local code and test it there before implementing it. Also the time thing-- they shouldnt be to mad since they are the ones who made it a cluster to start with-- but you never know
  4. In Topic: What are you working on today?

    Posted 4 Feb 2016

    3rd day of head ache since i pulled my awesome neck muscle
  5. In Topic: Need help waiting for an external event from within a stored procedure

    Posted 4 Feb 2016

    1. why would you want to do this? cant you just put it in the code behind that only activates on event then call your main stored procedure?
    2. this method you want to do will eat up resources
    3. generally while loops need a select right before an IF statement

My Information

Member Title:
D.I.C Lover
Age:
100 years old
Birthday:
September 11, 1915
Gender:
Location:
PA
Full Name:
Daren Rodriguez

Contact Information

E-mail:
Private

Comments

DarenR has no profile comments yet. Why not say hello?