Viewing 15 posts - 7,621 through 7,635 (of 13,469 total)
so no business logic? just if a record exists, refuse deletion?
in that case, you don't need to do anything, really...just try and delete, and if it fails due to a...
May 9, 2011 at 12:40 pm
something like this looks like it will work to me:
I'm gneerating a list of tables that are either the HEAP index or the clustered index shows zero rows
SELECT
...
May 9, 2011 at 12:24 pm
John I downloaded the proc and put it on my dev server that i know is fairly busy, and even with those two bits turned on, I couldn't get the...
May 9, 2011 at 11:53 am
Ninja's_RGR'us (5/9/2011)
I'll let you figure this on out... or correct lowell's typos :w00t:. Yes uncalled-ish for ;-).
😀 only uncalled for when it's not true!
anyway, fix the syntax issues in...
May 9, 2011 at 11:47 am
mikeincape (5/9/2011)
Ahhh Ha!Ok.... Runs fine on my server. Must be from using the express version on my local pc...
[fist pump] YES!!!!
May 9, 2011 at 11:23 am
SKYBVI (5/9/2011)
Should the logins be transferred before or after the restoration of system and user dbs.Regards,
Sushant
the order really will not make any difference, as long as both are completed before...
May 9, 2011 at 11:20 am
Ninja's_RGR'us (5/9/2011)
It's definitely possible, but if he could run my create db code, then I don't see why it would fail there (never seen that before).
The only thing I can...
May 9, 2011 at 11:09 am
mikeincape (5/9/2011)
Yes... This gives me the dataset I need. Thanks!... Still getting that weird error though... Any Ideas?
Ninja's is going to kick me for repeating what he already proved wrong...but...
May 9, 2011 at 11:04 am
here's a potential version that doesn't use row_number;
hopefully that will work as welll:
SELECT
cl.RecordStatus,
cl.ActiveClient,
cl.SystemEffective,
cl.Firstname,
cl.Lastname,
cl.MiddleI,
cl.SSN,
cl.ClientID,
...
May 9, 2011 at 11:01 am
sounds like the delay might be related to WINS/ name resolution on a network;
is the server a permanent server, or is it a laptop that joins the network occasionally? I've...
May 9, 2011 at 10:57 am
with the addition of the FlagDate DESC that Ninja noticed to the row number's Order by, does this get you closer to what you wanted?
SELECT
cl.RecordStatus,
cl.ActiveClient,
...
May 9, 2011 at 10:54 am
mikeincape (5/9/2011)
And that is am awesome catch on the comma... I never would have found that.
Should...
May 9, 2011 at 10:35 am
Ninja's_RGR'us (5/9/2011)
bg.FlagDate as EnteredDate,Missing the comma at the end of the line.
I think Lowell's having issues with that today :hehe:.
man that's for sure; i im flubbing up syntax a...
May 9, 2011 at 10:31 am
the database compatibility is set to 80 instead of 90, or you posted a SQL2000 question in the 2005 forum;
the ROW_NUMBER function was introduced in 2005, so i assumed you...
May 9, 2011 at 10:29 am
ok just a slight variation:
gotcha, i think this will do it: try the inner query witht he row number and see that it''s returning the client id and the...
May 9, 2011 at 10:15 am
Viewing 15 posts - 7,621 through 7,635 (of 13,469 total)