Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: Urgent..........How to import Excel having Multiple Sheet

    would you happen to have any help on writing this script?

    im clueless about vb .net

    and really need to pass the sheetnames into my dataflow task

  • RE: Calculating Work Days

    i just cut and paste from your code. (dont worry i left your name on there :D)

    so yeah if you put in any consecutive saturday and sunday you get a...

  • RE: Calculating Work Days

    jeff...i came up with an interesting dilemma with your function.

    if the start date is a saturday and the end date is a sunday it returns a -1.

    i think this should...

  • RE: case statement trouble in select

    hey greg...i like your idea, except that it would check for a null between those specific dates. what i intended to do was perform a certain calculation based on the...

  • RE: case statement problem in select

    hey earl,

    yes you're right...but these are simply on a reporting perspective and my company is such that you dont want to lock up any data while you're trying to extract...

  • RE: Calculating Work Days

    excellent! i was trying it without the dbo part, trying to use it as a system function i guess 🙂

    you're the man!

  • RE: Calculating Work Days

    is there anyway to edit this function so that it will return a value without declaring an output parameter?

    like how datediff or other functions work? simply two parameters and enclosed...

  • RE: Calculating Work Days

    ohhh i see. wow. thanks a lot. never dawned on me.

    thank you very much.

  • RE: Calculating Work Days

    ok i know this is a serious newb question and someone else had an issue when they tried to run this as an sp. i'm trying to run this as...

Viewing 9 posts - 1 through 9 (of 9 total)