| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> sure, use the nopaste
<1> no paste?
<0> read the topic
<1> sweet
<1> done
<1> http://www.sql-servers.com/nopaste/?show=697
<0> bbias meeting
<0> at first glance it appears your normalization migth be a little bit off
<0> but...
<0> ever think about just grabbing the list of identifiers and then dumping the delete statement
<0> rather than using a bunch of cursors
<1> nope - im no SQL guru!
<1> :)
<1> will have to research identifiers a bit more
<0> i.e.. delete from table where saleOrderID IN (SELECT attemptId FROM Attempt WHERE enrollmentId = @enrollmentId)
<0> rather than using a cursor
<1> thats gonna get pretty messy pretty quick tho - no?
<0> well take the concept of what I just gave you
<0> if I understand what you are tyring to do
<0> you are trying to kill eveyrthing if someone delets something
<0> i.e.. if you delete a user, delete all the ***ociated info with that user
<1> yeah - everything that is dependent on that item
<1> yeah
<1> exactly
<0> yeah so basically there is no real reason I can see that you NEED a cursor
<1> the FKs wont let just delete that base record - i have to delete eerything that maps back to it
<0> right understood
<1> yup
<2> Why not set the FK to delete cascade?
<0> yeah thats the word I was looking for
<0> thank you halo
<1> alter the table in the store proc?
<0> I couldnt of the name that its called for fk's
<1> higher ups dont like cascade on delete :T i suggested that in the beginning
<1> but anyhow - regardless of the merits of cursors vs cascade on delete - why would sql server 2000 think that all those tables are dependant on that stored proc?
<2> DELETE ChildTable FROM ChildTable INNER JOIN ParentTable ON ChildTable.ParentID = ParentTable.ID WHERE ParentTable.Something = @Blah;
<2> Because SQL marks object dependencies when you create sprocs that reference tables.
<1> can i remove the dependencies?
<1> also - i have other simple SPs that just SELECT foo from bar and when i delete them it doesnt say that table bar is a dependecy
<3> anyone here live in cali?
<4> i have a mailing address there
<3> i'm just curious how people can afford to l ive there
<3> especially socal where homes are like 600k+ on average
<3> must have a lot of apartments
<3> lotsa condos
<0> I live in fl and the median home price in palm beach county is $449,000
<5> 600k is like a shack
<3> $449k eh
<0> yeah
<3> what's the job market like there?
<6> its called cost of living
<0> so far so good
<3> jacksonville is high too
<0> yeah but they are a little cheaper
<0> i live in boca raton fl
<3> hmm
<3> i wanna move
<3> california and earthquakes or florida and hurricanes :p
<5> cocoa fl ;)
<0> cocoa is nice
<3> florida with no state tax tho!
<3> woohoo
<5> cleaper.. within commuting distance to everything
<0> hurricanes > earthquakes
<5> thats where i would live
<0> job markets in cocoa arent there
<3> nothing for c#/.net?
<0> its either commute to orlando or maybe daytona
<0> we are hiring a .net developer
<3> what's the salary like over there
<0> it varies
<0> I think they are hiring senior level .net developers
<0> if I had to guess its prolly in the 55-60k
<5> cocoa is within 30 minutes of cape canaveral, melbourne, wpb, pb. its a great spot on the space coast
<0> its not 30 minutes from wpb
<3> senior level is 55-60k?
<3> omg
<0> I dunno
<0> Im guessing
<0> I have no idea
<0> maybe more maybe less
<0> *shrug*
<0> im not senior
<0> lol
<3> i make 80k right now
<5> ok not close to wpb :P
<0> melbourne is okay
<5> wrong beeach i was thinking
<0> lol
<0> daytona its close to
<3> i could make upwards of 90k if i tried hard enough to find it
<0> when they post jobs here they don't post the salaray
<3> but for a great work environment you tend to make concessions :p
<0> so I dunno how it works
<0> yeah
<3> all i know is i'm depressed and i think i need a change of scenery
<7> heh
<7> ]55-60k for senior?
<0> read what I said after that
<7> i think thats the pay level for "entry levela" seniors
<0> I don't know what the pay scale for that is
<3> 55-60k here is like what people get out of college
<3> maybe for someone with 1 year of experience
<7> HEH
<0> where you from now grad?
<3> 60-75k is for 3 years exp
<3> atlanta
<3> but it's unfair to compare this job market to most places, we have a very competitive and strong job market
<7> eeeks
<7> atalanta
<7> I've heard the money is good
<7> but i think i'd have to be making 150k+
<3> it's probably the #1 or #2 job market for .net developers in the nation
<7> to move to atlanta
<3> why so?
<7> cause that has to be one of the ugliest cities i've had the displeasure of seeing - heh
<3> you can't make 150k here without being management or doing some serious contracting
<7> heh
<3> the most i've heard a developer make here is 115k
<7> yeah - thats why i'm not in Altanta right now :D
<7> i wanna screw developing
<7> i want to get into consulting or ****
<7> actually i'd like to get into something not related to comptuers at all :p
<4> mcdonalds is hiring
<3> see, my main problem is i am very picky about jobs
<3> i had 5 last year and 4 ****ed
<3> in other job markets i can't be as selective
<2> Maybe the jobs are really picky about you.
<4> oh yes, you seem very selective.
<3> no, some were really bad
<5> last 2 years have been awesome for me...3 previous ****ed
<3> 1 had a 4 tiered webservice implementation where 1 request to get data would chain over 10 webservice calls
<7> <4> mcdonalds is hiring
<3> another had a micromanaging CEO who would snoop emails
<7> need 200k
<3> and a developer there was basically customer support
<7> i am very picky to
<0> its all relatvie to size and budgets
<7> ?
<7> i dont think its relative to size or budgets heh
<5> if you get paid, quit bitching
<7> unless you're after "perks" that cost money
<4> mcdonalds only has three tiers, register, fryers and grill
<3> lol
<7> wrong
<3> some things are more important than money
<7> they have 6 tiers
<0> arrakis, it is, if they are over budge
<0> t
<7> dude
<0> they start making stupid decisions
Return to
#sql
or
Go to some related
logs:
#politics
cdoex.dll windows vista
#stocks
#windows
#beginner
ponro.is
#gentoo
#politics
zidanne bang bang
irc fluke
|
|