Recent content by happy1001

I want to import the data from specific Access Database and Table to SQL Server, using SQL Script. I am trying to implement the solution as given in this link - http://www.codeproject.com/Articles/21351/Import-Data-to-SQL-Server-from-Excel-or-Access-usi Here is the code that I have tried -...

Good link from Pinal Dave - blog.sqlauthority.com/2008/08/06/sql-server-query-to-find-column-from-all-tables-of-database/ SQL SERVER – Query to Find Column From All Tables of Database SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS...

Thanks Galaxiom, I will check it out and revert back.

Just as you and me, I am sure, there would be a lot of other guys who would be facing similar problems with databases. That is why I think that maybe there is some special tool developed for solving this trouble. If we are not able to find any specific tool, then there would be no other way then...

Suppose someone has to work on a lot of different SQL Server Databases which have got a lot of Tables and Queries / Views inside them. After a period of time, it becomes very difficult to remember exactly what kind of columns are present...

Is someone familiar with the method by which one can calculate the Percentile Ranks for the IV Implied Volatility in a Stock Market Database ? IV Percentile rank simply tells us whether implied volatility is high or low in a specific underlying based on the past year of IV data. For example, if...

Thanks for the correction Rx_ I just marked the thread as solved. Thanks for providing the code again :)

Hi Rx_ ! When I went through your complete code, I realized that your commenting style is just - AWESOME :D Really enjoyed it. Thanks and regards

WOW thanks a ton for sharing it along with the Code. It works like a charm. I am very grateful that you decided to share it. If this is just an extremely simple version of the task that you are involved in, then the whole comparison work would be something real complicated, I guess. As I was...

I have got 2 lists in 2 separate sheets in the same excel file. The Small list has got 20 Customer Names in it and the Big list has got 50 Customer Names in it. I need to compare the names given in the BIG List, with the names given in the SMALL List and then if there is a match of name...

Thanks for the link GinaWhipp