Forum Replies Created

Viewing 15 posts - 1 through 15 (of 266 total)

  • RE: SQL Server 2012 SP4

    Yes agree. This is for one of our clients and yes we have been pushing for an upgrade, for years! Hoping they upgrade soon, but as of now we are...

  • RE: SQL error

    Thanks a lot everyone

  • RE: SQL error

    Is there a way to exclude those records that divide by zero in the SQL and do the calculation only for those records that is not zero in the divide...

  • RE: SQL error

    Hi friends,

     I understand when bargain=100.0000, I get the divide by zero error. But when bargain =0.0000 and serno=7.90,  the result should be 7.9 and I need to use...

  • RE: Load data using SSIS

    Sorry about the late response..

    The problem was the folder path I mentioned for FTP had multiple files and sub folders in it. I removed all the other files...

  • RE: Load data using SSIS

    I googled about this error and found a solution to provide the serverpassword for FTP using a package config file. I did that and now I get a different error...

  • RE: sql 2005 install on Windows 2008

    I'm looking at MSDN, but it is not clear to me whether if I will have to install SQL server 2005 first and then install the Service packs or if...

  • RE: loading data into oracle

    Thanks for your response but we dont have C# expertise to wrote the code..

    Will it be a problem to export clobs using bcp?

    Thank you

  • RE: SQL convert

    Thank you for the answers

  • RE: SQL convert

    I should have figured that on my own 🙂 Thank you so much!

  • RE: SQL convert

    THank you.

    In Oracle, result looks like:

    select field10,field5, lpad(t.field10,3,'0')||'_'||t.field5 name_yn from table2 t

    field10- number(2)

    field5 - varchar2(10)

    field10 field5 ...

  • RE: Star schema

    Thanks. If we create fact and dimension tables under same dbo schema, can we still implement the star join optimization features like bitmap filtering etc on these tables?

    Thanks...

  • RE: Star schema

    Please note that we are not looking to create a data warehouse. We just need to create tables in star schema so the 3rd party tool can access these tables...

  • RE: Star schema

    Please note that we are not looking to create a data warehouse. We just need to create tables in star schema so the 3rd party tool can access these tables...

  • RE: Star schema question

    Okay thanks. I will post the same on SQL Server 2008.

Viewing 15 posts - 1 through 15 (of 266 total)