Thank you so much

User wants to be able to view the other logins at server login not her own login name. As I understand Alter any login has the ability to create &...

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...

Thanks a lot everyone

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...

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...

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...

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...

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...

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

Thank you for the answers

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

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...

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...

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...