Search:

Type: Posts; User: szlamany

Page 1 of 13 1 2 3 4

Search: Search took 2.39 seconds; generated 33 minute(s) ago.

  1. Replies
    355
    Views
    21,991

    Re: Trump indicted for January 6th

    Absolutely...it is called Projection Psychology and you constantly do it.

    Right back at you dude - you explained yourself perfectly.

    Your posts really do make me want to leave this tech forum...
  2. Replies
    355
    Views
    21,991

    Re: Trump indicted for January 6th

    The funny thing is that people that are on the other side feel the exact same way ABOUT EVERY SINGLE THING you are doing and saying as well. Can you imagine that?

    The division is real - it's here...
  3. Thread: Post Race!

    by szlamany
    Replies
    68,852
    Views
    17,962,772

    Re: Post Race!

    That really made me laugh! Thanks!
  4. Replies
    355
    Views
    21,991

    Re: Trump indicted for January 6th

    I adopted use of Twitter way back prior to Trump's WH win in 2016 - had an out with some local TV personalities and sought alternate sources at that time. What this gives me is a really large source...
  5. Replies
    355
    Views
    21,991

    Re: Trump indicted for January 6th

    @funky - thanks for that response - well worded and I can fully respect your position.

    I am simply waiting for the outcome - I am avoiding conclusions.

    I personally stopped watching all MSM...
  6. Re: [RESOLVED] Connect to sql server from Blazor Server application

    @mmock

    Sounds like you are well into it and having some success! Good luck!
  7. Thread: Post Race!

    by szlamany
    Replies
    68,852
    Views
    17,962,772

    Re: Post Race!

    Hits acre ash stop!
  8. Re: Get rows till the sum() is equal to or greater than

    And we finish with this:



    Select ABC.*,Final.*
    From (Select XYZ.PartNum,Max(XYZ.Id) "StartingIdForPart"
    From (Select *
    ,Sum(Quantity) Over (Partition By PartNum order by Id Desc)...
  9. Re: Get rows till the sum() is equal to or greater than

    This gives you the StartingIdForPart values


    Select *
    ,Sum(Quantity) Over (Partition By PartNum order by Id Desc) "RunningTotal"
    From @TT
    Order by Id

    Select XYZ.PartNum,Max(XYZ.Id)...
  10. Re: Get rows till the sum() is equal to or greater than

    This query


    DEclare @TT Table (Id int, PartNum varchar(100), Quantity int)

    Insert into @TT values (1,'P001',1),(2,'P0123',4),(3,'P001',2)
    ,(4,'P0122',6),(5,'P001',4),(6,'P001',3)...
  11. Replies
    355
    Views
    21,991

    Re: Trump indicted for January 6th

    Living in this country, I cannot get past the stubbornness - it's part and parcel a major player in the division that Obama and his team pushed into the forefront.
  12. Replies
    355
    Views
    21,991

    Re: Trump indicted for January 6th

    @sapator - you will never get through to these folk here. They are staunch believers in the story they share here. I would have thought that TDS symptoms would lessen in this group after a few...
  13. Replies
    355
    Views
    21,991

    Re: Trump indicted for January 6th

    Wow - that seems like an attack - I'll put it at the level where it has zero sting, lol...

    You "know" what others have read - that's an interesting superpower!

    And seems you have a new pair...
  14. Replies
    355
    Views
    21,991

    Re: Trump indicted for January 6th

    There is a huge swath of the country that feels 100% opposite of what you just stated. And you say it with such force - as if that is 100% truth. Doesn't that bother you a bit? Can't you even see...
  15. Re: Getting the ball rolling. Which VB6 projects are you working on?

    Thanks for the info - I had no idea that steampunk was so specific!

    It is a picture of an actual breaker panel - not like someone crafted it for visual art! And as you can see, they really must...
  16. Re: Getting the ball rolling. Which VB6 projects are you working on?

    @yer...I frequent a Facebook group that shows pics of old electronic parts and what not. Someone posted this and referred to it as steampunk (at least to him). Thought it might inspire you as you...
  17. Replies
    12
    Views
    1,232

    Re: Some issues with my C# Hello World program

    Here I have 9 projects under one solution. Archive, Curator, Librarian, Reader and UI are all set to START at once - I run all 5 at the same time. Each one (of the first four) takes a different...
  18. Replies
    16
    Views
    1,711

    Re: Access Inconsistency

    GUID's in single quotes are STRING literals.

    GUID's in {}-curly braces are treated properly as 16 byte values.

    This link alludes to the issue - which I believe is a "parsing" issue and not a...
  19. Thread: Post Race!

    by szlamany
    Replies
    68,852
    Views
    17,962,772

    Re: Post Race!

    That's all I was thinking as I was reading your post! When my wife and I are sitting out back on our deck and hear one go by, we always look at each other and comment "fxxxxt", lol! (British term...
  20. Re: Convert Windows Desktop Code to Mobile

    Single Source of Truth! I love that statement - thank you so much David! It applies to so much. I've always told those that have worked for me that there is only "one right way to do something". ...
  21. Replies
    15
    Views
    1,990

    Re: Best practice for store db string connection

    Found this post I made here on the forum on 12/20/2021...it's related to a web.config file. Doesn't the connection string you are talking about get stored in some application config file? Maybe...
  22. Replies
    3
    Views
    622

    VS 2019 Re: Problems accessing AD Groups

    I put the container in - a few . levels and some / levels.

    domain.xxxx.local/Locations/Central Office/Staff Groups

    So the pcDomain is "domain"
    The pcContainer is "xxxx.local...and so on..."
    ...
  23. Replies
    3
    Views
    622

    VS 2019 Re: Problems accessing AD Groups

    I left the container blank - the un/pw check was working - I thought I was good enough.

    Other client sites I do put a container value in WEB.CONFIG as well.

    Are GROUPS in a container? Like I...
  24. Replies
    3
    Views
    622

    VS 2019 Problems accessing AD Groups

    I'm trying this code - what is in the IF 1=1 THEN block - trying to enhance this backend ASP.Net / IIS code to handle AD Group Membership and not just Username/Password validation. I am getting no...
  25. Re: Convert Windows Desktop Code to Mobile

    Web app is less learning curve than doing an actual Mobile app, imo.

    Mobile apps have to follow all kinds of button and click rules - home buttons and back buttons. It's a whole new paradigm. ...
  26. Replies
    57
    Views
    3,983

    Re: Return to very slow query

    This is a good read:

    https://devblogs.microsoft.com/azure-sql/ctes-views-or-temp-tables/

    And again - I'm not sure how CTE's materialize - if that's a memory object or a disk based stored...
  27. Re: Convert Windows Desktop Code to Mobile

    You are going to have to do a bit of research here, if no one has experience with these tools in DevExpress.

    Bottom line is that some function will run on the server to return/process data with...
  28. Replies
    57
    Views
    3,983

    Re: Return to very slow query

    I love all this talk of CTE and this and that.

    CTE might use TABLE VARIABLES - which are typically memory objects - and for these purposes (8 million rows), might tank in the long run. I only...
  29. Re: Convert Windows Desktop Code to Mobile

    I would start a new thread in the JavaScript forum here - asking about tutorials or quick sample code of the latest and best JS library for AJAX calls to IIS backend services.

    I use jQuery - which...
  30. Replies
    57
    Views
    3,983

    Re: Return to very slow query

    TEMP table data is stored in the TEMPDB "database". It should be tuned by your DBA to work for all needs.
  31. Replies
    57
    Views
    3,983

    Re: Return to very slow query

    It is what SQL does when it builds your query. It uses "temp space" to build working recordsets that are then trimmed down.

    You can see this very act described in an EXECUTION plan.

    When you...
  32. Replies
    57
    Views
    3,983

    Re: Return to very slow query

    @zvoni - that "one index" at a time information is why I suggested the approach I did a couple posts back.

    That way you can FORCE the use of EACH index, in order, thus cleaning up and removing...
  33. Replies
    57
    Views
    3,983

    Re: Return to very slow query

    I'm late to the game here - I see you are in a SPROC - correct?

    With that said, you can create TEMP tables - right?

    The WHERE clause of the update is kind of tough - the OR is bad for speed in...
  34. Thread: Punch cards

    by szlamany
    Replies
    22
    Views
    1,721

    Re: Punch cards

    That is "Arena Style Scheduling" - very old school! Sounds mid-west like to me as well - Ohio or Illinois?
  35. Thread: Punch cards

    by szlamany
    Replies
    22
    Views
    1,721

    Re: Punch cards

    I've been doing school district software for ages...in the 1980's we used punch cards for attendance. Each student in the High School (2000 kids) would have a punch card printed with their STUDENT...
  36. Re: Convert Windows Desktop Code to Mobile

    Post 2 of 2 - architecture...

    You only write a handful of backend webservice functions - like the SourceService function in the post above.

    So re-use is key here.

    And with that said, since...
  37. Re: Convert Windows Desktop Code to Mobile

    Post 1 of 2 - code example first - next post will go into a bit of the architecture of this type of application.

    Basically from the web page you run JavaScript code like this - here I have a...
  38. Re: Convert Windows Desktop Code to Mobile

    @mmock - late to the game here!

    Are you married to going with a heavy app on the mobile device, as opposed to a browser app?

    My life has been all browser for some time now - using IIS for the...
  39. Thread: New Threads

    by szlamany
    Replies
    67
    Views
    3,782

    Re: New Threads

    I truly enjoy Twitter - strange to hope for it's demise. If you are a user and it's done you wrong, I guess I can fathom that level of disdain for some software platform.
  40. Replies
    23
    Views
    1,550

    Re: Revisionism vs. Preservationism?

    It's just changing of the guard, imo. I've worked with town and city governments for decades now, and the youth taking over have no clue how things were traditionally run.

    This can be as easy as...
Results 1 to 40 of 497
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width