Forum Replies Created

Viewing 15 posts - 346 through 360 (of 541 total)

  • RE: SUM Order Value by Month based on parameter BETWEEN @StartDate AND @EndDate

    OK moving on............The user either wants to select Orders by date range or simply return all Orders.

    ="TOTAL FOR MONTH:" & MONTH(First(Fields!Date.Value, "dsBidReport"))

    Should display as December & not 12.

    I have tried...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 19, 2008 at 7:04 am

    #915238

  • RE: SUM Order Value by Month based on parameter BETWEEN @StartDate AND @EndDate

    OK there is a flaw in my formatting! If I group every column then add to the group footer:

    =MONTH(First(Fields!Date.Value, "dsBidReport")) & " " & Sum(Fields!Value.Value, "dsBidReport")

    The Value 12 + Sum...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 19, 2008 at 4:11 am

    #915096

  • RE: Return Average Cost (MIN 10 values) for Product?

    Thanks for the link. The table is being used for migration purposes so once the data is migrated to the new system it will no longer be required.

    I worked on...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 19, 2008 at 12:16 am

    #915006

  • RE: Return Average Cost (MIN 10 values) for Product?

    Thanks for the reply. I will haved a crack at the code tomorrow and post back if I hit a wall (table structure etc..)..

    One quick question. As this is a...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 18, 2008 at 3:23 pm

    #914904

  • RE: SSIS Newbie

    Thanks Jack, pretty sure it wasn't but been wrong before 🙂

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 18, 2008 at 10:35 am

    #914738

  • RE: CONVERT nvarchar to datetime

    Back again. I am sure I am missing a trick having reviewed the last error posted so do not waste any time on this thread, I will revisit what I...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 18, 2008 at 8:38 am

    #914614

  • RE: CONVERT nvarchar to datetime

    Hi Lynn. I tried that initially which returned error:

    Msg 8115, Level 16, State 2, Line 1

    Arithmetic overflow error converting expression to data type datetime.

    The statement has been terminated.

    I then came...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 18, 2008 at 8:30 am

    #914600

  • RE: WHERE when using Table Alias

    Thanks Gail.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 11, 2008 at 6:34 am

    #911025

  • RE: WHERE when using Table Alias

    Thanks Ronald. I was having a blonde moment.

    Initially I tried:

    WHERE Products.ProductId LIKE 'DME_'

    The returned zero.

    Many Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    December 11, 2008 at 6:09 am

    #911005

  • RE: Backup Strategy / Backup the Backup

    Thanks guys.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    November 21, 2008 at 8:15 am

    #901647

  • RE: Backup Strategy / Backup the Backup

    I did not purchase the SQL Agent for Symanatec.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    November 21, 2008 at 6:14 am

    #901566

  • RE: Backup Strategy / Backup the Backup

    Thanks for the replies. I keep 2 weeks worth as storage is not an issue at the moment.

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    November 21, 2008 at 3:33 am

    #901518

  • RE: INSERT INTO

    Chris many thanks, exactly what I was after.

    Many Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    November 18, 2008 at 6:00 am

    #899846

  • RE: INSERT INTO

    Thanks Chris. You were correct.

    I ran the following after confirming your code executed OK:

    INSERT INTO [Training].[dbo].[ProductProductCategories]

    ([Product])

    SELECT p.Product

    FROM [Training].[dbo].[Products] p

    LEFT...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    November 18, 2008 at 5:39 am

    #899831

  • RE: Make Text Visible IF Statement?

    Thanks for the advice.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    November 14, 2008 at 2:10 pm

    #898878

Viewing 15 posts - 346 through 360 (of 541 total)