Forum Replies Created

Viewing 15 posts - 856 through 870 (of 3,666 total)

  • RE: Your Tools

    Eric M Russell (2/19/2015)


    Alvin Ramard (2/19/2015)


    This editorial came on an interesting day.

    A few hours ago I decided I need to get my hand on a cheaper option to Erwin or...



    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: Convert mm/dd/yyyy, m/d/yyyy and mm/d/yyyy Date format To Date/datetime (yyyy/mm/dd) in SSIS

    ilokris (2/19/2015)


    @luis,

    Your Question: ''Why don't you define your column as a date data type in your flat file connection and save yourself some problems? Your destination column should be a...



    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: Your Tools

    This editorial came on an interesting day.

    A few hours ago I decided I need to get my hand on a cheaper option to Erwin or DB Artisan. I'm working...



    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: WHERE 1 = 1,who uses this besides me

    I use it regularly, but only when I'm developing queries or in ad-hoc queries.

    Interesting that I saw this post just now. I just finished removing one of these 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: SQL Injection, Still?

    It shouldn't be to hard to develop a function, or functions, on the application development side that test all SQL statements to prevent injection. Once that's done, just have...



    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 Injection, Still?

    Thanks for the idea for a great topic for an upcoming user group meeting.

    Now, Just need to find someone to present it.



    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: Importing spreadsheet in one single column

    SSMS_2007 (2/13/2015)


    I am trying to import 1 spreadsheet to a database table. I am using SSMS export import wizard to import spreadsheet. My goal is to import whole spreadsheet in...



    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: Deleting data (rows) from table to reclaim space

    Instead of deleting 5 years worth all at once, try deleting a smaller date range at a time, say one month at a time.



    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: Creating an Upload process

    If I were doing this, I would do it using SSIS.



    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: T-sql script

    Maintenance plans generate SSIS Packages. Just edit your package(s) to add a FileSystem task to move the existing backup(s) before the backup task(s).



    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: Need help adding a Script Component Transformation in Data Flow using BIML

    I would be very happy to see the script component section.



    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: no more free (proper) SCD Task for 2012?

    You should contact Pragmatic Works and ask them what the status is.



    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: Need help with sequencing

    Sean Lange (1/23/2015)


    surf4profit (1/23/2015)


    I have a

    Are we supposed to fill in the blank?

    I am going to guess "purple man eating elephant".

    No, it's: "I have a dream." 😉



    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 write query with groupby

    ramana3327 (1/21/2015)


    Hi,

    How can we write the query using groupby. I need to have group by only one column. Is it possible through subquery?

    select col1, col2, col3

    from testtable

    group by col1.

    Can...



    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: Query Returning Zero

    kabaari (1/19/2015)


    Alvin and Andrew,

    Those both achieved my goal. I was having difficulty with querying against a getDate() Inserted value. The time is also captured at insert which had thrown some...



    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 - 856 through 870 (of 3,666 total)