T

 # List of allowed fund names

keep_fund_names = ["A", "B", "C", "D"]


# Filter the funds to include only the allowed names

keep_fund_names = {name: id for name, id in fund_names.items() if name in keep_fund_names}


Comments

Post a Comment

Popular posts from this blog

SSRS--Interview Basic Questions

Image
 1). What is SSRS (Sql Server Reporting Services) ? Ans : Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources.Which allow you to create tabular, matrix, rectangle, sub-report,,charts, Gauge, indicator reports in managed environment. Like a) Development Tool b) Configuration Tool c) Administration Tool d) Report Viewing Tool 2) What is report Manager? Ans:  Report Manager is a Web-based report access and management tool that you use to administer a single report server instance from a remote location over an HTTP connection. You can also use Report Manager for its report viewer and navigation features. You can use Report Manager to perform the following tasks: View, search, print, and subscribe to reports. Create, secure, and maintain the folder hierarchy to organize items on the server. Configure role-based security that determines access to items and operations. Configure rep...
Read more

SQL SERVER

Image
Ques: What is .LDF – SQL Server? Ans:  I was quite surprised to see search engines throwing very less information on this one, yet it’s a frequently asked question. LDF acronym stands for Log Data File (though could have been called – Transactional Log Data File). This is a must to have file, and is created at the same time the database file (.mdf) is created by SQL Server. So why do you need it?  For keeping .mdf consistent. To cut short I will copy these lines straight from  wiki  : “SQL Server ensures that any change to the data is ACID-compliant, i.e., it uses transactions to ensure that any operation either totally completes or is undone if fails, but never leaves the database in an intermediate state. Using transactions, a sequence of actions can be grouped together, with the guarantee that either all actions will succeed or none will. SQL Server implements transactions using a write-ahead log. Any changes made to any page will update the in-memory cache of ...
Read more

SQL SERVER – Introduction to CLR – Simple Example of CLR

Image
CLR is abbreviation of Common Language Runtime. In SQL Server 2005 and later version of it database objects can be created which are created in CLR. Stored Procedures, Functions, Triggers can be coded in CLR. CLR is faster than T-SQL in many cases. CLR is mainly used to accomplish task which are not possible by T-SQL or can use lots of resources. CLR can be usually implemented where there is intense string operation, thread management or iteration methods which can be complicated for T-SQL. Implementing CLR provides more security to Extended Stored Procedure. Let us create one very simple CLR where we will print current system datetime. 1) Open Microsoft Visual Studio >> Click New Project >> Select Visual C# >> Database >> SQL Server Project 2) Either choose from existing database connection as reference or click on Add New Reference. In my example I have selected Add New Reference. 3) If you have selected existing reference skip to next step or a...
Read more