Forum Replies Created

Viewing 15 posts - 916 through 930 (of 3,666 total)

  • RE: SELECT a String

    Please stop posting the same thing in multiple forums!



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: How to schedule SSRS Report

    Chris Ells (11/25/2014)


    Unfortunately, that link doesn't explain even how to create a subscription.

    Maybe this link is better.

    http://lmgtfy.com/?q=how+to+schedule+ssrs+report+for+emailing



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Update statement bringing unexpected results.

    As far as the number of records showing up in the messages tabs is concerned, that's the way it should be.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SQL DBA knowing user passwords

    GilaMonster (11/20/2014)


    NJDave (11/20/2014)


    Should a SQL DBA know users passwords when using SQL Server authentication?

    Absolutely not.

    Agree!!!



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SQL DWH to SSAS Cube

    Sounds like what you're asking is beyond what this forum was intended for.

    I think you need to find a good book on SSAS and start reading.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Error creating temp table based on IF logic

    g.britton (11/13/2014)


    The temp table in the dynamic sql is created in a different context and not available to the calling context. e.g.

    DECLARE @sql nvarchar(4000) = N'create table #foo(a int)';

    EXEC sp_executesql...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Merge replication between SQL 2008 Express and SQL Compact

    You might want to look into synchronization, instead of replication.

    How to: Execute Database Synchronization (SQL Server)

    http://msdn.microsoft.com/en-us/library/dd918848%28v=sql.110%29.aspx



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Script Component help

    Here's a few links that might be helpful:

    Integration Services (SSIS) Expressions

    http://msdn.microsoft.com/en-us/library/ms137547%28v=sql.110%29.aspx

    SSIS Expression Cheat Sheet

    http://pragmaticworks.com/Training/Resources/Cheat-Sheets/SSIS-Expression-Cheat-Sheet



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Is Shrinking Log Files Good or Bad?

    I'd like to know where so many people got the idea that the database should be set to Simple Recovery Mode first.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Posted from SSIS 2005 Forum, on tight deadline need help.

    Easiest option is to add a FileSystemTask for each file type you need to process.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Am I breaking Normalization

    OCTom (11/3/2014)


    How about using an Orders History table and store the ordered price there?

    Tom

    I don't see a need for an Order History table. The Orders table can be...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Am I breaking Normalization

    If you want to record what the price was at the time of the order, then I would keep the price in both table. This is normal (no pun...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: IN or OR

    Aleksl-294755 (11/3/2014)


    Good question. Never thought about using the second option. I learned something. Thanks!

    Same here. Thanks.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: update query for isnull columns

    batgirl (10/27/2014)


    do you get any results when you select rows using the same where clause?

    The rephrase the above question, what do you get when you run the query below?

    SELECT *...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Bad Query Plan Headache

    Is the suggested index based on more than one column? if so, you might have the columns in the wrong order. The suggested index does not necessarily have the...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 916 through 930 (of 3,666 total)