dcsimg

Search:

Type: Posts; User: MMock

Page 1 of 13 1 2 3 4

Search: Search took 1.36 seconds.

  1. Re: [RESOLVED] How far will you go to avoid a double-negative?

    Yup, it has a small issue! LOL. Small I can deal with.
  2. Re: How far will you go to avoid a double-negative?

    We are using a dropdownlist. The choices are "YES (Customer has PM)" and "NO (Customer does not have PM)". This has worked for us in the past. On occasion, my boss has asked for it to be presented...
  3. Re: How far will you go to avoid a double-negative?

    Moribund? That is so sad. I think I will cry.


    "We"? As in people at work??? But yes, I see the confusion!

    Anyway, I think passel made a good point when s/he spoke of a deviation. But...
  4. [RESOLVED] How far will you go to avoid a double-negative?

    I hate double negatives because I agree with this.

    So I am fighting my boss who just asked me to create a new checkbox called "No PM". This would indicate that a customer doesn't have...
  5. Re: Can I write a view with IIF in it?

    Hunh. How I ever didn't see that on my own, I can't even begin to explain. Many thanks for being my eyes today!
  6. [RESOLVED] Can I write a view with IIF in it?

    I guess a long time ago, before IIF was invented (or available to us), my fellow developer wrote his own iif function that went like this:


    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    --...
  7. Replies
    3
    Views
    481

    Re: Do you write joins like this?

    Interesting. Thanks. I will take a look at it some more on Monday. The great outdoors is calling me right now, LOL.
  8. Replies
    3
    Views
    481

    Do you write joins like this?

    An easy question for you on a Saturday (that is actually sunny and warm over here in New England!)

    I am working with someone else's query, and is this some kind of a shorthand to list a couple...
  9. Re: Don't (Throw Exception) on NullValue - your help is URGENTLY requested!

    To TysonLPrice, I apologize. I didn't even see your post. However, I did not want to change the sproc. I didn't believe that was the way to go, since the full dataset was fine yet the filtered...
  10. Re: Don't (Throw Exception) on NullValue - your help is URGENTLY requested!

    I figured out what I could do. (The hard part was explaining to the company VP, who was being my sounding board, why this worked and the other way didn't!)

    Since the code liked the full datatable...
  11. Re: Don't (Throw Exception) on NullValue - your help is URGENTLY requested!

    I know what you are saying, but I am not sure it will help. Here is my scenario right now. I chose PA with an empID of 80. So right here, I am on the bolded line exeptioning

    ...
  12. [RESOLVED] Don't (Throw Exception) on NullValue - your help is URGENTLY requested!

    I'm having this problem but I don't understand why.

    I am running a stored procedure from my C# code called xsp_ProjectList. It gets a list of projects our employees are working on. Then there...
  13. Re: query to get a row with MAX date and one other column

    Yes, that is exactly what I was missing! Thanks again!
  14. Re: query to get a row with MAX date and one other column

    Thank you! I totally switched gears and don't want to end the week in a bad mood so I'll try this when I'm done!
  15. [RESOLVED] query to get a row with MAX date and one other column

    My problem is the same as this one here https://stackoverflow.com/questions/3680254/t-sql-selecting-column-based-on-maxother-column

    There were four solutions to that question and I am trying to...
  16. Re: Will you do a post mortum with me?

    Also a great tip, thanks!
  17. Re: Will you do a post mortum with me?

    lol!
  18. Re: Will you do a post mortum with me?

    We're way too chill for even a QA department, LOL. My boss usually just tells me, if worse comes to worst the users can just use paper for a while.
  19. Re: Will you do a post mortum with me?

    Zvoni, interesting idea, thanks. FD - not sure why I didn't think to drop the columns. But I could've/should've and it's pretty chill here so even if I caused errors in the live system, users...
  20. Re: Will you do a post mortum with me?

    Thanks, tg. Good advice for next time!
  21. [RESOLVED] Will you do a post mortum with me?

    I want to know how I could've avoided this bug.
    We have a function that goes: SELECT @Result = sum(MRSaleAmount) FROM Jobs WHERE (CustNo = @cust_no) AND (MRSaleDate BETWEEN dateadd(yy,-1,GETDATE())...
  22. Re: Grid doesn't exception with a lot of rows, then I filter and it exceptions with l

    I wasn't really looking for an alternative, more an explanation of what was wrong with the method I was using.
    It would be one thing if I posted, how do I do this. I posted, this is how I am doing...
  23. Re: Grid doesn't exception with a lot of rows, then I filter and it exceptions with l

    So all this time, I've been filtering my grids wrong? I decided to take a filter-my-grids 101 class and I copied this code from a stackoverflow post and I am not exceptioning anymore.


    ...
  24. [RESOLVED] Grid doesn't exception with a lot of rows, then I filter and it exceptions with less

    I don't understand this problem I am having. I am binding a data grid to the results of a stored procedure. That works perfectly.

    Then I started to add a a filter. Namely, every row has a...
  25. Replies
    15
    Views
    759

    Re: I'm having a problem with midnight

    Sorry, I refreshed and vbForums reposted.
    Usually it's only my smart phone that makes me look like an idiot.
    ;)
  26. Replies
    15
    Views
    759

    Re: I'm having a problem with midnight

    No, didn't feel that way at all and I have been meaning to get back to this but let's face it, it's not a fun problem so I think I subconsciously blocked it out.
    I've also been adhering to the...
  27. Replies
    15
    Views
    759

    Re: I'm having a problem with midnight

    No, didn't feel that way at all and I have been meaning to get back to this but let's face it, it's not a fun problem so I think I subconsciously blocked it out.
    I've also been adhering to the...
  28. Replies
    15
    Views
    759

    Re: I'm having a problem with midnight

    So in all fairness to the programmer who designed this, he probably thought it was redundant to specify the date in every column where we save time. In other words, you have Date once and let's say...
  29. Replies
    15
    Views
    759

    Re: I'm having a problem with midnight

    Nope, presumably I do not. There's a whole separate column called Date and that's the day of the week that the person worked. Then all the other columns, even though they are DateTime types, we...
  30. Replies
    15
    Views
    759

    I'm having a problem with midnight

    I'm working on a form in our application where an employee enters hours worked for each day.
    The data is written out to a table called Hours, and one pair of fields for example is TimeIn and...
  31. Re: Copy record from one table to another using TableAdapter

    Your buzzing appears to be fine! (I even stole your words to use as my comment!)


    foreach (dsTimeSheetsTables.HoursRow drHoursSource in dtHoursSource.Rows)
    ...
  32. [RESOLVED] Copy record from one table to another using TableAdapter

    I thought this was really cool when I did it once before in my code to copy data from a record into another record and then modify just a few of the dest record's columns.

    ...
  33. Re: Is there a better way than to call this function 3x?

    I've been knocked up with CTE's once or twice. I will let you know on Monday if I have trouble doing it on my own. Trying to take the weekend off! You should, too...;)
  34. Is there a better way than to call this function 3x?

    This is a select of a column in a view I am working on. Syntactically, what can I do to only call the function once and use the results three times, or does it matter?

    CASE
    WHEN...
  35. Re: Please fact-check my simple trigger

    Awesome! Thank you!
  36. Re: Please fact-check my simple trigger

    Okay, thanks. This is why I asked. There are some triggers in our database already so I was using them as an example, but I didn't want to blindly use them without fully understanding.
    Regarding...
  37. [RESOLVED] Please fact-check my simple trigger

    I have a small table that has a column called SystemRelease with date/id created and date/id modified.
    I don't need a history, but whenever a user edits the SystemRelease I want to capture who is...
  38. Re: Maintaining updates to a dictionary so spellcheck recognizes new words

    OK, thanks for your input! I'm not happy but most likely you are right.
  39. Re: [RESOLVED] If you wouldn't mind helping me with a query...

    No, if there's a primary sales person I want his row and if there is no primary salesperson I just want a row to know that forecast data has been created for this sale. One record or more, it...
  40. Re: [RESOLVED] If you wouldn't mind helping me with a query...

    Of course you personally would...!
    Are you saying I may not get the right results the way I am doing it?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width