Search Results - VBForums

Search:

Type: Posts; User: InvisibleDuncan

Page 1 of 13 1 2 3 4

Search: Search took 0.07 seconds.

  1. 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...
  2. 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...
  3. Replies
    48
    Views
    1,357

    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...
  4. Replies
    48
    Views
    1,357

    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...
  5. Replies
    48
    Views
    1,357

    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...
  6. Replies
    48
    Views
    1,357

    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...
  7. Replies
    48
    Views
    1,357

    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...
  8. Replies
    10
    Views
    532

    Re: or !=

    Oops - double post!
  9. Replies
    10
    Views
    532

    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...
  10. Replies
    10
    Views
    532

    [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...
  11. Replies
    14
    Views
    1,514

    Re: IRS Telephone Scam

    It wasn't Russell Brand, was it?
  12. 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...
  13. 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...
  14. 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....
  15. Re: Pattern matching for ASCII characters only

    Ah, right - that would probably explain it. Thanks!
  16. 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...
  17. 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...
  18. Replies
    45
    Views
    1,289

    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...
  19. Replies
    134
    Views
    5,366

    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.
  20. Replies
    10
    Views
    523

    Re: Worst Thing Ever?

    EastEnders. :mad:
  21. 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...
  22. Replies
    134
    Views
    5,366

    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...
  23. Replies
    0
    Views
    157

    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,...
  24. 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...
  25. 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...
  26. Replies
    14
    Views
    836

    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...
  27. Replies
    28
    Views
    1,282

    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...
  28. Re: Join versus Where Exists

    That's a little mean if it's always the same bunch of people who help you out.
  29. 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...
  30. 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...
  31. 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...
  32. [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...
  33. Replies
    30
    Views
    1,883

    Re: Redskins

    As someone who comes from Britain but not from England, I would disagree. There's a massive difference.
  34. Replies
    30
    Views
    1,883

    Re: Redskins

    I think you were invaded by the Scots once or twice. ;)

    There are some people who get offended for a living, generally on behalf of someone else who is utterly unconcerned by the issue. I think...
  35. Replies
    18
    Views
    1,022

    Re: dday10-1

    Was this you?
    110569
  36. Replies
    31
    Views
    1,604

    Re: Vocabulary test

    No thinking, just knowing.

    I got 3,860 on my second attempt, but it's not registering my clicks quickly. I had a couple where I clicked within the first second, but it sat and waited for a moment...
  37. Replies
    145
    Views
    8,660

    Re: Sorry guys but I'm done!

    I'll give Meals-On-Wheels a shout for you.
  38. Replies
    145
    Views
    8,660

    Re: Sorry guys but I'm done!

    I promoted you. ;)

    No, I actually come from the Western Highlands and I know a few McIlhinney families, so I assumed you were from a similar area.



    Fin? I'd have thought "Fitz".
  39. Replies
    3,231
    Views
    125,309

    Re: The Golden Chair

    I have debatable onions.
  40. Replies
    31
    Views
    1,604

    Re: Vocabulary test

    3,740 for my first attempt. Might try again later, but I'm supposed to be working.
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.