Viewing 15 posts - 1 through 15 (of 266 total)
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...
June 15, 2018 at 10:50 am
Thanks a lot everyone
September 20, 2017 at 12:16 pm
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...
September 20, 2017 at 11:31 am
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...
September 20, 2017 at 11:22 am
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...
August 31, 2016 at 8:30 am
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...
August 25, 2016 at 12:40 pm
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...
May 4, 2016 at 4:07 pm
Thanks for your response but we dont have C# expertise to wrote the code..
Will it be a problem to export clobs using bcp?
May 4, 2016 at 11:12 am
Thank you for the answers
March 23, 2016 at 9:06 am
I should have figured that on my own 🙂 Thank you so much!
March 22, 2016 at 1:25 pm
In Oracle, result looks like:
select field10,field5, lpad(t.field10,3,'0')||'_'||t.field5 name_yn from table2 t
field5 - varchar2(10)
field10 field5 ...
March 22, 2016 at 12:18 pm
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?
March 15, 2016 at 11:58 am
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...
March 15, 2016 at 11:31 am
March 15, 2016 at 11:28 am
Okay thanks. I will post the same on SQL Server 2008.
March 15, 2016 at 10:49 am