Forum Replies Created

Viewing 15 posts - 8,941 through 8,955 (of 15,381 total)

  • RE: Alpha Numeric number Generation

    nitin_456 (3/25/2013)


    Totally Blank , Plz see if you can suggest something.

    Honestly I would suggest not doing this. The code will make your eyes bleed before you even get close to...

  • RE: Alpha Numeric number Generation

    nitin_456 (3/25/2013)


    Hi Sean- It always be 5 digit Code + constant.

    The logic for this type of thing is horrible. It ends up being a scalar function and performance is not...

  • RE: Alpha Numeric number Generation

    nitin_456 (3/25/2013)


    Hello,

    Need help with in writing a Stored Procedure for Auto Alpha Numeric Generation. If I pass an Alpha numeric in the format mentioned below , I...

  • RE: Concatenation help

    FOR XML

    If you want more specific help you need to provide more details.

  • RE: Message Snippet

    I agree!!! This would be an awesome addition. I far too often find myself typing in the same things over and over again. It would be great to have a...

  • RE: Extract Saturday through Friday as the weekly date range

    fergusoj (3/25/2013)


    I have data with attendance hours/dates for every day of the month/year. I need to create a query where I can select a range of dates, such as Jan....

  • RE: Remove characters after last slash in string

    raym85 (3/25/2013)


    It bothered me now.

    So i had to come up with a way to, but I would prolly choose the first one opver my own.

    DECLARE @LastValue varchar(100)

    declare @string varchar...

  • RE: Importing 00:00 into Table

    Good point Lynn!!!

  • RE: Performance ISSUE by USING CURSOR HELP !!!!

    Syntactically it appears to be just fine. If there are logic issues I can't do much to help because there is no ddl to work with. Please take a few...

  • RE: Importing 00:00 into Table

    DarthBurrito (3/25/2013)


    Sean Lange (3/25/2013)


    Since you are trying to record the amount of TIME something took why not use the TIME datatype?

    declare @Time time = '09:26'

    select @Time

    Now you have stored only...

  • RE: Importing 00:00 into Table

    Since you are trying to record the amount of TIME something took why not use the TIME datatype?

    declare @Time time = '09:26'

    select @Time

    Now you have stored only the amount of...

  • RE: Increase values with update statement

    ByronOne (3/25/2013)


    Hi everyone

    I hope somebody can help...

    I have a table in SQL with the following columns: FinancialYear (varchar), Site (varchar), ProductRange (varchar), ProductName (varchar), PlannedSales (decimal).

    I want to...

  • RE: Performance ISSUE by USING CURSOR HELP !!!!

    ERIC CRUDELI (3/25/2013)


    I'm lost :doze:

    The Data source I have to use for Insert is in Temporary table #temp2

    Where is the link ?

    I'm sorry the code I posted wasn't very clear....

  • RE: Performance ISSUE by USING CURSOR HELP !!!!

    ERIC CRUDELI (3/25/2013)


    Hello,

    OUTPUT INSERTED.YourIdentityColumn, INSERTED.easilyPatId

    My identy colunm is tel_id but for the second output is INSERTED.@easilyPadId (value get from cursor). Is it correct ?

    Thanks

    Eric

    I think you missed the point. You...

  • RE: Some guidance needed....

    It seems like maybe this should be in a query instead of the report. Then you don't need any sort of stop gap due to time limitations. Create a table...

Viewing 15 posts - 8,941 through 8,955 (of 15,381 total)