Forum Replies Created

Viewing 15 posts - 496 through 510 (of 3,666 total)

  • RE: Using Wildcard with a date column

    anthony.r.colvin (7/28/2015)


    I was looking for a way to use a wild card on a date column, but could only convert the file first then use the wildcard Is there...



    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 different OLAP vs Dimensional Modeling? Can any one explain

    OLAP is an acronym for Online Analytical Processing. OLAP performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.

    Dimensional modeling (DM)...



    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: can I safely use top n for select/delete in a while loop?

    sqlguy-736318 (7/27/2015)


    Hi, can I safely use top n select/delete in a while loop? For example:

    declare @FieldVal int

    while (select count(*) from @MyTempTable) > 0

    begin

    select top 1 @FieldVal = FieldVal from...



    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 Skynet Coming?

    Eric M Russell (7/28/2015)


    Iwas Bornready (7/28/2015)


    Maybe in a thousand years.

    If the AI robots are designed to think like humans, then hopefully they will turn on each other, killing themselves off...



    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: NOT IN

    SQL-DBA-01 (7/28/2015)


    If the question could have been asked to check the returned value:

    SELECT Value

    FROM #tmpOldValue

    WHERE Value NOT IN (SELECT Value FROM #tmpNewValue)

    The answer would have been := 6

    Please, lets...



    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: Max DB Size for SQL Server Express

    SQLRNNR (7/24/2015)


    Sean Lange (7/24/2015)


    Alvin Ramard (7/24/2015)


    Revenant (7/24/2015)


    I cannot believe that this resulted in five pages of discussion.

    Thanks, Mike!

    Make that 6.

    Still on page 2 for me. 😛

    Same here;-)

    Can we drive this...



    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: Max DB Size for SQL Server Express

    Revenant (7/24/2015)


    I cannot believe that this resulted in five pages of discussion.

    Thanks, Mike!

    Make that 6.



    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: Find any character that isn't a number or letter - confused!

    This would be much easier if you could use regular expressions in SQL.



    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: Max DB Size for SQL Server Express

    Ed Wagner (7/24/2015)


    Alvin Ramard (7/24/2015)


    SQLRNNR (7/24/2015)


    Vimal Lohani (7/24/2015)


    where is express edition mentioned in question.

    In the question title.

    Just like many of the forum questions asked. You have to read the title...



    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: SSIS challenge

    nightowl23 (7/24/2015)


    I have three tables in data base:

    customer

    product

    sales

    and i want to use SSIS package dynamically load data from database into three separate flat file, each table into each file.

    i know...



    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: Max DB Size for SQL Server Express

    I only read the title and got it right. 😛



    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: Max DB Size for SQL Server Express

    SQLRNNR (7/24/2015)


    Vimal Lohani (7/24/2015)


    where is express edition mentioned in question.

    In the question title.

    Just like many of the forum questions asked. You have to read the title too to get 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]

  • RE: Are the posted questions getting worse?

    rodjkidd (7/24/2015)


    GilaMonster (7/24/2015)


    rodjkidd (7/23/2015)


    Gail, well done. Seriously impressive.

    I hope you are celebrating this weekend?

    Taking myself and a good book to an expensive Chinese restaurant tonight. Yes, that's a celebration.

    Well...



    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: array variables in sql server?

    ScottPletcher (7/23/2015)


    But a temp table / table variable won't begin to match the performance of a true array.

    C'est la vie.



    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: Application Constantly Dropping and Re-Creating Tables

    By dropping the tables each time, you could break something that is dependencies related.

    For example, you had to grant permission on a table for whatever reason. When you drop 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 - 496 through 510 (of 3,666 total)