Forum Replies Created

Viewing 15 posts - 196 through 210 (of 541 total)

  • RE: BUILTIN\ADMINISTRATORS

    Thanks Jeffrey.

    -------------------------------------------------------------------------------------
    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

    March 4, 2010 at 1:38 am

    #1128323

  • RE: Delegate to non admin

    Found this on Andrew Fryers blog thought others might find it useful:

    http://blogs.technet.com/andrew/archive/2008/07/14/licensing-sql-server-client-tools.aspx

    Regards,

    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

    February 26, 2010 at 7:02 am

    #1125553

  • RE: Delegate to non admin

    Thanks for the input. How does visual studio (delivered with SQL) fit in regards deployment to multiple users?

    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

    February 25, 2010 at 1:18 am

    #1124783

  • RE: Export to Multiple Worksheets

    Thanks for posting.

    Kind Regards,

    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 22, 2009 at 12:08 pm

    #1095588

  • RE: CONCATENATE fields in JOIN

    Point taken, legs duly slapped 🙂

    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 22, 2009 at 6:18 am

    #1095350

  • RE: CONCATENATE fields in JOIN

    Thanks for taking time to reply.

    A friend has just come up with the answer as follows:

    INNER JOIN (SELECT AccountingYear * 100 + AccountingPeriod AS YRPR,AccountingYear,AccountingPeriod,PeriodClosed,ROW_NUMBER() OVER(PARTITION BY AccountingYear * 100...

    -------------------------------------------------------------------------------------
    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 22, 2009 at 5:00 am

    #1095328

  • RE: Export to multiple worksheets in same spreadsheet?

    OK, I have made some progress (testing on 32 bit XP laptop).

    Firstly I added a linked server:

    DECLARE @rc int

    DECLARE @server nvarchar(128)

    DECLARE @srvproduct nvarchar(128)

    DECLARE @provider nvarchar(128)

    DECLARE @datasrc nvarchar(4000)

    DECLARE @location nvarchar(4000)

    DECLARE @provstr...

    -------------------------------------------------------------------------------------
    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, 2009 at 4:40 am

    #1093955

  • RE: Export to multiple worksheets in same spreadsheet?

    Thanks for the links.

    Kind Regards,

    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, 2009 at 1:44 am

    #1093906

  • RE: Export to multiple worksheets in same spreadsheet?

    In testing I received error "Microsoft.ACE.OLEDB.12.0" has not been registered.

    I have done some research and apparently there is not a ACE provider for 64bit?

    I am running Windows 7 Ultimate 64bit...

    -------------------------------------------------------------------------------------
    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 17, 2009 at 10:03 am

    #1093591

  • RE: Export to multiple worksheets in same spreadsheet?

    Thanks for that, very much appreciated.

    Kind Regards,

    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 16, 2009 at 3:47 pm

    #1093340

  • RE: Export to multiple worksheets in same spreadsheet?

    Hi, yes T-SQL to to Excel and I was hoping to automate.

    Kind Regards,

    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 16, 2009 at 1:07 pm

    #1093273

  • RE: Export to multiple worksheets in same spreadsheet?

    Thanks for the link.

    I am looking to go the other way. Run a SQL query that outputs to excel. For each GL Code create a seperate worksheet in the excel...

    -------------------------------------------------------------------------------------
    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 16, 2009 at 6:01 am

    #1092944

  • RE: Stored Procedure - A better way?

    DISTINCT

    There must have been a reason at the time....I will check and remove if not required.

    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 17, 2009 at 9:46 am

    #1080369

  • RE: Stored Procedure - A better way?

    Thanks Dave, I will take a look.

    Kind Regards,

    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 17, 2009 at 8:11 am

    #1080287

  • RE: Create Endpoint Error

    Thought I would post my solution.

    It transpires I had not permitted the account used in the Endpoint role membership on system databases Master & msdb.

    msdb:Roles

    SQLAgentOperatorRole

    SQLAgentReaderRole

    SQLAgentUserRole

    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

    October 27, 2009 at 3:00 am

    #1071067

Viewing 15 posts - 196 through 210 (of 541 total)