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

    • But all those examples sell a wide variety of things,  and mostly they are well spread out along Lordship Lane. These two shops both sell one very specific thing, albeit in different flavours, and are just across the road from each other. I don't think you can compare the distribution of shops in Roman times to the distribution of shops in Lordship Lane in the twenty first century. Well, you can, but it doesn't feel very appropriate. Haa anybody asked the first shop how they feel? Are they happy about the "healthy competition" ?
    • ED is included in the 17 August closure set (or just possibly 15 August, depending on which part of the page you trust more) listed at https://metro.co.uk/2025/07/25/full-list-25-poundland-stores-confirmed-close-august-23753048/. Here incidentally are some snippets from their annual reports, at https://find-and-update.company-information.service.gov.uk/company/02495645/filing-history. 2022: " during the period we opened 41 stores and closed 43 loss-making/under-performing stores.  At the period-end we were trading from 821 stores in the UK, IoM and ROI. ... "We renogotiated 82 leases in the year, saving on average 45% versus the prior lease agreement..." 2023: "We also continued to improve our market footprint through sourcing better store locations, opening 53 and closing 51 stores during the year." 2024:  "The ex-Wilco stores acquired in the prior year have formed a core part of this strategy to expand our store network.  We favour quality over quantity and during the period we opened 84 stores and closed 71 loss-making/under-performing ones."
    • Ha! After I posted this, I thought of lots more examples. Screwfix and the hardware store? Mrs Robinson and Jumping Bean? Chemists, plant shops, hairdressers...  the list goes on... it's good to have healthy competition  Ooooh! Two cheese shops
    • You've got a point.  Thinking Leyland and Screwfix too but this felt different.
Home
Events
Sign In

Sign In



Or sign in with one of these services

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