Search Results - VBForums

Search:

Type: Posts; User: InvisibleDuncan

Page 1 of 13 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    61
    Views
    1,556

    Re: Ferguson

    No, that's not what I said at all. My point is that they seem to be incapable of looking at it as anything other than a matter of race. Their stance is that it is inherently racist for a white cop to...
  2. Replies
    3,236
    Views
    128,985

    Re: The Golden Chair

    Curried scones with horseradish trousers. Yule!
  3. Re: Specifying date format when reading XML into SQL

    Thanks, TG - I'll give that one a whirl. ;)
  4. Re: Xbox One games are attached to Xbox Live account?

    I seem to recall hearing that this was the case. It's also the reason why it's so difficult to buy and sell second-hand games for the One.
  5. Replies
    152
    Views
    6,281

    Re: Frickin' Lasers for Eyes!

    Maybe it's time to introduce the word "lawyer" to the conversation. I'm not a litigious person, but this is disgraceful.
  6. Replies
    61
    Views
    1,556

    Re: Ferguson

    I think a large part of the problem is racism on the part of the rioters. There seems to be an automatic assumption on their part that because the cop was white and the guy he killed was black, that...
  7. Specifying date format when reading XML into SQL

    A colleague of mine is working on a procedure that reads some XML and inserts it into a SQL Server 2008 table. This is all very straightforward but he's struggling with the dates that are coming in....
  8. Replies
    152
    Views
    6,281

    Re: Frickin' Lasers for Eyes!

    Must admit, I didn't know that this was an expected side effect. I don't think I would go for a treatment that improves one aspect of your vision at the expense of another. :(
  9. Re: Reaching another database using dynamic SQL

    Hi guys,

    Thanks for pointing me back towards sp_ExecuteSQL. I had tried that initially but was getting strange errors that made no sense to me. However, my issue actually turned out to be that I...
  10. Reaching another database using dynamic SQL

    I want to get some data from another database. The name of the other database can change depending on the context, so I figured I'd build the SQL dynamically and execute it. However, it's not doing...
  11. Replies
    48
    Views
    1,491

    Re: Taking the "U" out of the UK

    I'm actually not convinced that this is true. I would agree that a majority of Kievians wanted a change of leadership, but it doesn't follow that the whole of the country did. It was a case of the...
  12. Replies
    48
    Views
    1,491

    Re: Taking the "U" out of the UK

    For the most part, they didn't actually promise anything new towards the end of the campaign - what they did was reiterate the promises they'd already made but which had been largely ignored because...
  13. Replies
    48
    Views
    1,491

    Re: Taking the "U" out of the UK

    Wasn't that offered once, roughly when Holyrood was instituted? Or am I imagining that? :confused:

    I know that at the moment there are lots of English people who are aggrieved at the amount of...
  14. Replies
    48
    Views
    1,491

    Re: Taking the "U" out of the UK

    Lol! I like the idea of banknotes made out of liquorice. :bigyello:

    It does seem bizarre that they thought sending David Cameron would help. He is the epitome of what so many Scots hate about the...
  15. Replies
    48
    Views
    1,491

    Re: Taking the "U" out of the UK

    Overall I think NSA has nailed it. The biggest problem for the "Better Together" campaign is that they simply haven't bothered campaigning. The polls have always shown a massive majority for a no...
  16. Replies
    10
    Views
    544

    Re: or !=

    Oops - double post!
  17. Replies
    10
    Views
    544

    Re: or !=

    Thanks, guys. I hadn't seen != in years, but came across a whole clutch of them in a set of stored procedures written by a 3rd party. I was just wondering if they knew something I didn't.

    I think...
  18. Replies
    10
    Views
    544

    [RESOLVED] or !=

    Quick question, folks: In SQL, is there any reason to prefer <> or != over the other, or is it simply personal preference? Is one standard and one non-standard?

    Annoyingly, they're very hard terms...
  19. Replies
    14
    Views
    1,558

    Re: IRS Telephone Scam

    It wasn't Russell Brand, was it?
  20. Re: Permissions to use SPs and UDFs that don't update data

    Thanks, Bill - I'll give that one some thought. Our databases are huge with hundreds of tables, procedures and functions, so it may not be practical - but it's better than anything I've come up with...
  21. Re: Permissions to use SPs and UDFs that don't update data

    Bill: I'm using 2008 R2. You may be right about the functions - I thought that was the case but I wasn't sure.

    DS: Loads of our SPs update data, so we can't grant execute permissions on...
  22. Permissions to use SPs and UDFs that don't update data

    For security reasons, we developers don't have access to our live databases. However, read-only access is temporarily granted when we need to investigate specific problems that are happening in live....
  23. Re: Pattern matching for ASCII characters only

    Ah, right - that would probably explain it. Thanks!
  24. Pattern matching for ASCII characters only

    I'm trying to write a function that strips out all non-ASCII characters in a field when I select it, but I'm having trouble with the pattern matching. I've tried this (using the collation statement...
  25. Re: [SERIOUS] Scotland - Backpack Trip [\SERIOUS]

    It very much depends on what kind of things you like to do. I'd agree with Dex about going to a ceilidh if you get the chance - they're always full of high energy. I'd also recommend going to a...
  26. Replies
    45
    Views
    1,338

    Re: UKers look here

    I'm intrigued by the popular assertion that UKIP are right-wing. If you look at their policies, they are actually firmly left-wing, wanting to renationalise several industries and increase the size...
  27. Replies
    152
    Views
    6,281

    Re: Frickin' Lasers for Eyes!

    I think you mean "the worst bit so far". Wait until you start seeing ghosts, or murders as they happen. I'm fairly sure that's what happens after every eye operation.
  28. Replies
    10
    Views
    532

    Re: Worst Thing Ever?

    EastEnders. :mad:
  29. Re: Biggest Impact - TV/Movie Tech that's doesn't exist

    Surely a Tardis would trump all of these? The ability to travel anywhere in time and space beats the ability to travel anywhere in space.

    I'd go back in time and take out a patent on a rectangle...
  30. Replies
    152
    Views
    6,281

    Re: Frickin' Lasers for Eyes!

    That's the bit that impressed me about this whole thing: they didn't try to pressure you into going for the more expensive procedure.

    If it all goes horribly wrong, do they give you a jar to bring...
  31. Replies
    0
    Views
    159

    Breakpoints in SSIS not being hit

    I've inherited an SSIS package which is really rather horrible. It is now falling over on a particular task, and I'm trying to put a berakpoint in the script to find out what's happening. However,...
  32. Re: Passing an encrypted password into SQL Server from VB.Net

    In all honesty, as a developer myself I'm fairly relaxed about developers being able to see the password. Unfortunately, one of our team has been using these credentials to make changes to a database...
  33. Passing an encrypted password into SQL Server from VB.Net

    We have a few VB.Net applications that connect to a SQL Server 2008 database using SQL Server authentication. Basically, we have a config file that contains an encrypted password, and our...
  34. Replies
    14
    Views
    849

    Re: All perspective I guess...

    Did that really come as news to you, though? It's something that I assumed everyone was aware of.

    Many, many countries don't use computerised systems at immigration control, particularly at...
  35. Replies
    28
    Views
    1,339

    Re: Too late for that...

    From this side of the pond, the biggest problem with US politics would seem to be the money involved. This in turn leads to political campaigning being unbelievably vicious (if TV dramas are to be...
  36. Re: Join versus Where Exists

    That's a little mean if it's always the same bunch of people who help you out.
  37. Re: Join versus Where Exists

    Hmmm - I'm not sure whether I've successfully rated your posts. I just get the message that "you must spread some reputation around before rating this post" or words to that effect. I got the same...
  38. Re: Join versus Where Exists

    Guys - thank you. The execution plan was fairly non-committal, probably because there's no actual data in the Agent table anymore (someone helpfully dropped and recreated it), but it did look as if...
  39. Re: Join versus Where Exists

    szlamany - Our coding standards say to never use SELECT *, so I tend to stick with that even if it doesn't matter.

    It's SQL 2008 R2, and it's to be used for a view that will only be used as part...
  40. [RESOLVED] Join versus Where Exists

    I want to get data out of a single table, restricted to where an ID field exists on another table. The ID may exist more than once on the second table, so doing a join would cause me to get duplicate...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.