Forum Replies Created

Viewing 15 posts - 226 through 240 (of 541 total)

  • RE: Export to Excel

    Thanks I will check it out. How would the end user use the tool as at present they simply select the report they wish to run, once rendered thet choose...

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

    August 11, 2009 at 5:19 am

    #1037322

  • RE: FORMAT output to two Deciaml Places

    Thanks guys. Jeff I am using Visual Web Developer 2008. I tried omitting the formatting from the T-SQL then on the column within the GridView in VWD I set ConvertEmptyStringToNull...

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

    July 20, 2009 at 1:54 am

    #1026785

  • RE: Stored Procedure used for Wild Card Search on Web Form

    Hi Florian.

    DECLARE @prods TABLE (Id INT IDENTITY, Name VARCHAR(100))

    INSERT INTO @prods

    SELECT 'Prod1'

    UNION ALL SELECT...

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

    July 14, 2009 at 4:32 am

    #1024304

  • RE: Stored Procedure used for Wild Card Search on Web Form

    Thanks to all. The table in question has 34000 rows.

    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

    July 11, 2009 at 2:43 pm

    #1023556

  • RE: multiple dataset in one tab

    Pleased to here you resolved.

    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

    July 11, 2009 at 3:00 am

    #1023460

  • RE: Stored Procedure used for Wild Card Search on Web Form

    Thanks. I must say I thought adding 'Search' to the web form was going to be simple! 🙂

    They had an old site running on MySQL that worked fine.

    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

    July 11, 2009 at 2:58 am

    #1023459

  • RE: multiple dataset in one tab

    As far as I am aware a table can only reference a single dataset.

    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

    July 10, 2009 at 9:54 am

    #1023168

  • RE: Stored Procedure used for Wild Card Search on Web Form

    Terry many thanks for taking time to respond to my post.

    I will try the code posted.

    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

    July 10, 2009 at 8:32 am

    #1023075

  • RE: User Permissions to Email Report Subscriptions

    Thanks. One other thing. I created a new folder and uploaded a report to it. When the user browses to the folder it displays 'There are no items in 'Folder...

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

    July 8, 2009 at 12:49 am

    #1021502

  • RE: Reference Table in DB on Named Instance

    Thanks guys, linked servers is way to go then.....

    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

    July 3, 2009 at 9:41 am

    #1019809

  • RE: Help with a SELECT query used in SSIS package

    Poor old Tommy is dead.......

    Thanks for all your efforts, your code looks neater than my attempt.

    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

    June 24, 2009 at 8:51 am

    #1014701

  • RE: Help with a SELECT query used in SSIS package

    Gianluca many thnaks for taking time to review my thread, I have struggled to get onto the site from the office.

    I also reviewed my code and came up with the...

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

    June 24, 2009 at 8:41 am

    #1014692

  • RE: Deploying SSIS Packages

    OK, I could run the package OK with the new credentials however I was unable to complete the 'Package Installation' wizard on the target server.

    To resolve this added the login...

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

    June 22, 2009 at 9:13 am

    #1013374

  • RE: Deploying SSIS Packages

    Hi, in answer to my own question I decided to create a new sql login and grant 'SELECT' permissions to the limited number of tables the account needed to access...

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

    June 22, 2009 at 8:29 am

    #1013324

  • RE: Expression Builder

    Just to update this post I found the following article regards 'Custom Logging using Event Handlers' that others may find of use.

    http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.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

    June 22, 2009 at 3:09 am

    #1013166

Viewing 15 posts - 226 through 240 (of 541 total)