Jump to content

Recommended Posts

Ok, figured it's a chance to get EDF on the google knowledge base map.


For the most part in my job (IT development) I can just google a class or error and get a wealth of useful information.


But recently I've started upgrading stuff to reporting services 2008, SQL 2008 and I'm getting an average of no hits and no information, clearly I'm the only one doing this or no one can get anything to work and talk about it.


Yaw yawn etc.


Anyway, I figured we have thousands of intelligent people working in all sorts of professions and we might be a good resource to help each other in times of need, and mayhap a room to share this stuff might (or might not, fine fine, let it sink out of sight) be a good idea.


So when in need...is there a legal precedence for...how can I use linq to...dovetail joint the wrong way of going about...should I use butter or is a water based lube... etc this is the place to ask.

oookayyyyy


so can anyone tell me why, in SQL server, when trying to randomly get the Nth row from a table with


[pre]

WITH sentence AS

(SELECT

stuff,

row = ROW_NUMBER() OVER (ORDER BY Id)

FROM

SentenceType

)

SELECT

sen.stuff

FROM sentence sen

WHERE sen.row = (ABS(CHECKSUM(NEWID())) % 100) + 1 --random 1-100 this aint cryptography


[/pre]


and


[pre]

DECLARE @row INT

SET @row = (ABS(CHECKSUM(NEWID())) % 100) + 1 --random 1-100 this aint cryptography


;WITH sentence AS

(SELECT

stuff,

row = ROW_NUMBER() OVER (ORDER BY Id)

FROM

SentenceType

)

SELECT

sen.stuff

FROM sentence sen

WHERE sen.row = @row

[/pre]



they behave so very, very differently with the former utterly barmy and the latter working fine (but not how I want to do this)?

OK, got it.


In my first post it's calculating (ABS(CHECKSUM(NEWID())) % 100) + 1 against each row in the CTE, thus you will get as many (or as few) returned rows as you get coincidental matches between the (ABS(CHECKSUM(NEWID())) % 100) + 1 and the ROW_NUMBER.

Interesting I always thought the where clause was considered a static value applied to each row, not a row level value applied to each row. Hmm beware of any getdate() type stuff on a long running query I reckon.


One for the memory banks.

Thanks for your help everyone.


Right, I'm trying to write a romantic ditty with my own fair pen to get some violinists to play at my wife's romantic birthday dinner. Should I go with a minor scale for that romantic/melancholic intimacy or go with the majors for that get up and go celebratory tone of which she's so beloved?


Also should I learn how to play/write music too?

Brendan thats a piano piece, I prefer Dm it's the sadest of all keys you know. Major keys are too up beat, minor keys envolke emotion


Im not a developer more of a unix sys admin/engineer if you ever get a problem with Solaris Linux networking disk managment Veritas or LVM clustering or shared storage patching ipmp basic scripting etc then I may be able to help you out

You punk sh*t you. ;-)


Some of us had to write bubble searches when there was nothing but assembly. We wrote the bloody code.


Don't imagine I was always a logical recidivist. The models you use to reduce data factories now were written by me and my peers in between writing 'Tron' for 'Computer & Video Games' Magazine, 1984. (Yes, I know, CVG now, you p*nces).


You go off to these blinking exam courses in '95 and think you own the debate.


I laugh in the face of your language compiler trap, if only because in my day you'd be staring at one million data points without a clue at rationalising them. Sod it. You'd be going 'load the stack...skim the stack', it's binary dontcha know?


Incidentally, you'll never find the result by potting code. You have to feel the result. Stroke the knowledge. Numbers are an art, not a science.


Signed Grumpy B@stard

Ok ...now don't take offense are you a DIY a "Don or Dunce"

it goes in between the fittings ( LED downlighters ) and the main supply, a bit like a transformer does on L.V so say 6 lights can run off the main feed, they are small enough to push through the hole cut out for the fittings. they do need to be accessible in case of later failure. Also they won't heat up like LV's




See inclosed instruction supplied with the items(Don) or hire a sparks (Dunce)


W**F


PS. Turn off power at the mains before starting any electrical work

I'd do a scan for any malware, bots etc, just in case; maybe time for a defrag too? What OS are you?


Although I love Firefox I find it more memory intensive than IE on the whole, and blows up more often, but then I suppose I have more extensions than most, some of which, like firebug, get under the covers somewhat.


I've found Google Chrome the quickest and lightest so far, but it's still in Beta form.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Latest Discussions

    • Where did I say he did a good job? Yup and Corbyn was very close to Len McCluskey and funded by Unite wasn't he...they're all as bad as each other... Labour have to purge their party of the far-left - they're a disaster. Allan Johnson summed it up so well on election night in 2019....  
    • Thank you for the detailed advise @trinidad It is definitely damage we are concerned about. I don’t think Evri would agree to pay the bill to fix our gate or letter box if they were to be damaged as a result of their delivery drivers helper. Our doorbell can be heard from outside when rung so we don’t quite believe the aggressive simultaneous door/letter box banging is necessary. It can be quite a shock it is done very aggressively.  I’ll definitely action the steps you’ve kindly provided along with a phone call tomorrow. I do sympathise with the role drivers have and how busy they are, which is why we tried communicating directly with her but sadly we haven’t succeeded 
    • What outcome would you like? Disciplinary action? Not to have the driver back? Retraining? I know there is alot of pressure on drivers to deliver within a set day. if he slams the gate, is it evidence he is causing damage, or is the noise a irritant to yourself? You could put a sign up or buy a signing asking to close the gate gentle???? can you hear the door bell from the door? he might be ringing, not hearing and therefore knocking. In trhe notes section of the be livery page, there is a note section, although there is not 100 per cent these notes would be read as these drivers are constantly rushing.  I did a google search for you, i found this and you can try the envri website Contact Us | Evri   To complain to Evri, you can follow these steps: Contact Customer Service: Call Evri's customer service at 0330 808 5456 for assistance with your complaint.    1 Write a Letter: Address your complaint to Capitol House, 1 Capitol Close, Morley, Leeds, West Yorkshire, LS27 0WH.    1 Use the Official Website: Visit the Evri complaints page on their official website for detailed instructions on how to submit a complaint.    2 Email or Call for Specific Issues: For issues like missing or damaged parcels, you can email or call 0800 988 8888, which is free to call.    1 These methods will help you effectively communicate your concerns to Evri.   My driver is called anthony, he is brilliant to be honest. I cant fault him.
    • When I have more time and energy, I will look up the actual number of votes cast for each party in that election, rather than the number of seats won. I'm interested to see that you apparently  think that  Boris Johnson did a good job of "leading the country through Covid." Is your memory really that short? I won't stoop to calling Johnson and his cronies names in the way that you seem to think is appropriate for left wing politicians. At least the left wing politicians have some semblance of morals and a concern for people who aren't in some over privileged inner circle and/or raking in money for themselves on the back of an epidemic. I'm not going to open a can of worms on here  by commenting on the disgraceful so called "purge". 
Home
Events
Sign In

Sign In



Or sign in with one of these services

Search
×
    Search In
×
×
  • Create New...