Resources   No resource found

• How to Check If a Stored Procedure Exists in SQL ServerApr 29, 2026. A comprehensive guide explaining how to check whether a stored procedure exists in SQL Server using multiple methods such as INFORMATION_SCHEMA, sys.procedures, OBJECT_ID, and SSMS UI. The article also highlights practical use cases, best practices, and common issues developers face while validating stored procedures across different environments like development and production.
• What is Stored Procedure vs Function in SQL with Examples?Apr 17, 2026. Unlock the power of SQL! Learn the key differences between Stored Procedures and Functions with examples. Optimize database operations and boost performance. Discover when to use each for efficient, scalable applications.
• What Are Stored Procedures in SQL Server and How to Use ThemApr 03, 2026. Master SQL Server Stored Procedures! Learn to create, execute, and optimize them for improved performance, security, and code maintainability. Step-by-step guide.
• What Is the Difference Between Stored Procedures and LINQ in .NET?Feb 23, 2026. Explore the key differences between Stored Procedures and LINQ in .NET for database interactions. Optimize your ASP.NET Core apps for performance and maintainability.
• Blazor with PostgreSQL using ADO.NET (Enterprise-Ready Guide)Feb 05, 2026. Connect Blazor apps (Server/WebAssembly) to PostgreSQL using ADO.NET (Npgsql). Ideal for high-performance, enterprise systems needing full SQL control and stored procedures.
• Entity Framework Core – Database First ApproachDec 14, 2025. This article provides a complete and descriptive explanation of the Entity Framework Core Database First approach. It explains how EF Core generates entity classes and DbContext from an existing database, how scaffolding works, how relationships, views, and stored procedures are handled, and how to safely manage schema changes using re-scaffolding and partial classes. Written in simple language, this guide is ideal for beginners and professional .NET developers working with legacy or enterprise databases using Entity Framework Core.
• Understanding Views, Indexes, Functions & Stored Procedures in SQL ServerDec 01, 2025. Master SQL Server! This beginner's guide explains Views, Indexes, Functions, and Stored Procedures with syntax and examples. Boost performance and simplify queries.
• Stored Procedures: What They Are & Why Beginners Should Use ThemNov 27, 2025. Unlock database efficiency! Learn stored procedures: reusable SQL code for improved performance, security, and maintainability. Perfect for full-stack beginners.
• Building a Professional Full-Stack Application with Repository Pattern, Unit of Work, Stored Procedures, Pagination, Sorting, and SearchingNov 27, 2025. Build scalable ASP.NET Core apps using Repository & Unit of Work patterns, stored procedures, EF Core, and Angular. Master pagination, sorting, and searching!
• SQL Views vs Stored Procedures vs Functions — What’s the Difference?Nov 25, 2025. Understand the core differences between SQL Views, Stored Procedures, and Functions. Learn when to use each for optimal database performance, maintainability, and scalability.
• How to Create Stored Procedures in SQL Server | Beginner to Intermediate Practical GuideNov 24, 2025. Master SQL Server stored procedures! This guide covers creation, benefits, and best practices for efficient, secure, and maintainable database interactions. From basic CRUD to advanced error handling, learn to centralize SQL logic.
• Writing a Dynamic Pivot Grid Stored Procedure for Reports in SQL ServerNov 17, 2025. Create a reusable SQL Server stored procedure for dynamic pivot reports. Handle dynamic columns, values, and groupings for flexible reporting solutions. Ideal for dashboards.
• Using JSON and XML Data Efficiently in SQL Server for APIsNov 05, 2025. Leverage SQL Server's JSON & XML capabilities for efficient APIs. Parse data, return responses directly from SQL, boosting performance & simplifying integration.
• Dynamic Stored Procedure Mapping Using Reflection in Repository PatternNov 03, 2025. Dynamically map stored procedures to C# models using Reflection within the Repository Pattern. Reduce boilerplate code, improve maintainability, and achieve clean architecture. Automate parameter mapping and result conversion for scalable database access.
• Writing High-Performance Stored Procedures in SQL ServerOct 31, 2025. Boost SQL Server backend performance! Learn to write efficient stored procedures with indexing, minimal joins, and proper error handling. Optimize your queries now!
• Delete Single or Multiple Records from GridView in ASP.NETOct 13, 2025. Learn how to implement single and multiple record deletion in ASP.NET GridView using checkboxes, client-side validation, and a SQL Server stored procedure. This tutorial covers UI design with a GridView, JavaScript for select-all functionality and validation, server-side C# code for deletion, and the SQL stored procedure.
• Find High-Usage Queries and Stored Procedures in SQL ServerSep 05, 2025. Identify the SQL statements and stored procedures that burn the most CPU, IO, and time using SQL Server DMVs—plus quick scripts, filters, and tips to fix them.
• Building HIPAA Incident-Response & Breach-Notification WorkflowsJul 12, 2025. Design end-to-end HIPAA incident-response and breach-notification workflows. Learn how to set up detection pipelines, author playbooks, enforce notification timelines, and use ready-made template notices.
• Maintaining HIPAA Policies, Training & Documentation: A Continuous Compliance FrameworkJul 12, 2025. Learn how to version-control HIPAA policies, automate workforce training tracking, and keep your compliance documentation continuously up to date with audit-ready processes and tools.
• 🚀 Automating SQL Server Database Backups and Remote Table SyncJul 11, 2025. This SQL stored procedure automates local database backups and replicates all tables to a remote server with suffixes, ensuring disaster recovery, reporting, and schema sync—no manual table handling required.
• How To Run JavaScript in Power Automate Desktop Using “Run JavaScript” ActionJun 17, 2025. Learn how to run JavaScript directly in Power Automate Desktop using the “Run JavaScript” action. Build objects, return JSON via WScript.Echo(), and integrate JS logic seamlessly into your PAD flows.
• Mastering Named, Positional, and Input/Output Parameters in Stored Procedures with EF CoreMay 22, 2025. Understanding Name Parameters, Positional Parameters, Input/Output Parameters, and Their Usage in Stored Procedures with EF Core
• Execution Process of SQL Queries vs Stored Procedures Apr 21, 2025. Dive deep into the internal execution process of SQL Server queries with this one-of-a-kind article comparing normal SQL queries and stored procedures.
• SQL Stored Procedure vs. Azure Data Factory Data FlowSep 27, 2024. This article compares SQL Stored Procedures and Azure Data Factory (ADF) Data Flows for creating staging tables and migrating data to Dynamics 365 (D365). It examines their differences in execution time, cost, and scalability, offering insights into which method is best suited for data migration tasks.
• How to Show Direct Binary Image Using Handler in ASP.NET WebFormsAug 09, 2024. Learn how to display images stored as binary data in a database using an HTTP handler in ASP.NET WebForms. This guide covers creating a database table, a stored procedure for image retrieval, and implementing an HTTP handler to serve images dynamically. It also includes integrating the handler into a web form.
• Create XML in .NET Core API and Send to Stored Procedure Using DapperJul 30, 2024. Learn how to create and send XML data to a stored procedure in a .NET Core Web API. This guide covers setting up a .NET Core Web API project, generating XML from data models, using Dapper for database interaction, and configuring a stored procedure to handle XML data. Ideal for complex data integration.
• Real-World ADO.NET Use Cases: Case Studies and Best PracticesJul 24, 2024. ADO.NET remains a robust data access technology within the .NET framework, even as newer technologies emerge. Its ability to manage data interactions efficiently makes it suitable for a variety of real-world applications.
• Performance Optimization in ADO.NET: Tips and TechniquesJul 23, 2024. Optimize ADO.NET performance by leveraging connection pooling to reduce overhead, using efficient command execution strategies such as stored procedures and batch processing, and retrieving data effectively by selecting only necessary columns and implementing paging.
• Executing Commands with ADO.NETJul 22, 2024. Explore how to use ADO.NET’s SqlCommand class for executing SQL queries and stored procedures in .NET applications. This guide covers setting up SqlConnection, using methods like ExecuteNonQuery, ExecuteScalar, and ExecuteReader, and preventing SQL injection with parameterized queries.
• Working with Stored Procedures in ADO.NETJul 22, 2024. Stored procedures are a powerful feature in database management systems that allow you to encapsulate complex logic and operations on the server side. When using ADO.NET in a .NET application, stored procedures can be leveraged to interact with the database efficiently.
• Detailed Explanation of Procedure and Function in SQL ServerJul 22, 2024. Stored procedures are precompiled sets of one or more SQL statements that can be executed together. Functions in SQL Server are essential database objects that contain a series of SQL statements and provide either a single value or a table as output.
• ASP.NET C# Display Bootstrap Bar Chart from Database ValuesJul 22, 2024. Create a stored procedure in SQL to fetch monthly audit data and display it in an ASP.NET application. Use Visual Studio to create a master page with jQuery and Flot libraries. Serialize the data to JSON in the code-behind, then plot it in a bar chart on a content page.
• How to Create Server-Side Pagination, Searching, and Sorting Stored ProcedureJul 19, 2024. This article demonstrates how to create a SQL Server stored procedure for server-side pagination, searching, and sorting. The procedure efficiently handles large datasets by dynamically calculating total rows, applying filters, and sorting data.
• Generic Repository with EF Core Store Procedure in .NET Core 8Jul 16, 2024. Entity Framework Core (EF Core) empowers .NET developers with seamless database interaction through object-relational mapping (ORM) and support for stored procedures. It optimizes performance by executing complex SQL logic directly on the server, enhancing efficiency for CRUD operations.
• How to Convert varbinary to Base64 String in SQL ServerJul 03, 2024. Learn how to convert varbinary data to Base64 strings in SQL Server using XML functions and the CAST method. This tutorial provides clear steps and SQL examples for encoding binary data, crucial for web applications needing text-based transmission of images and files.
• Store Locations and Retrieve Dropdown Data with Stored ProcedureJul 03, 2024. Explore efficient location data management with this guide on storing locations in a database table. Learn to utilize stored procedures for streamlined retrieval of dropdown data, ensuring optimized database performance and simplified data handling in your applications.
• Creating a User Login System with SQL Server Stored ProceduresJul 02, 2024. Implementing secure user authentication in SQL Server involves creating a UsersDetails table for storing credentials and developing a LoginUser stored procedure. This procedure validates user inputs against stored data, ensuring robust login functionality for applications.
• Oracle Stored Procedure Output Parameters with Dapper in ASP.NET CoreJun 11, 2024. This article provides a detailed guide to integrating Oracle stored procedures with ASP.NET Core using Dapper, focusing on handling output parameters, which can often be a challenging aspect of database interactions.
• Improved Performance by STORED PROCEDURESJun 08, 2024. Stored procedures in relational database management systems (RDBMS) encapsulate frequently used SQL statements for efficient execution. They offer dynamic SQL execution, return values via OUT keywords, and include procedural logic like IF-ELSE and loops.
• SQL Server Internal Stored Procedures That You Should UseJun 06, 2024. SQL Server internal stored procedures are invaluable tools for developers, offering streamlined access to database information, session management, resource monitoring, configuration settings, and more. From sp_help to sp_monitorConfig, these procedures simplify routine tasks, enhance productivity.
• Optimizing Performance with Dapper with .NET Core API May 30, 2024. Learn Dapper best practices for optimal database interaction in .NET applications. Explore techniques like using output parameters and handling multiple result sets in stored procedures. Enhance efficiency with optimized query writing for delete operations.
• Dotnet Core, EF Core Store Procedure With Multiple ResultsMay 20, 2024. Entity Framework Core coupled with stored procedures for SQL database data retrieval encounters a constraint: consistent return of all columns required for DbQuery<T> properties. This alternative approach offers solutions.
• Using Stored Procedures in MySQL Enhanced Code PerformanceApr 30, 2024. Stored Procedures in MySQL offer a streamlined approach to executing complex or frequently used SQL logic with a single call, supporting input parameters, procedural logic, and return values.
• SQL Stored Procedures: Benefits, Implementation & Best PracticesApr 19, 2024. Stored procedures are a powerful feature of SQL databases that allow developers to encapsulate SQL logic and execute it as a single unit. In this article, we'll delve into the concept of stored procedures, explore their benefits, discuss how to implement them, and highlight some best practices for using them.
• Table-Valued Parameters in SQL ServerApr 16, 2024. Table-Valued Parameters in SQL Server enable passing multiple rows of data to stored procedures, enhancing performance for bulk operations. Utilizing user-defined table types, they streamline data manipulation tasks and allow parameterized queries, optimizing database development and improving overall performance.
• MERGE Stored Procedures in SQL ServerApr 15, 2024. In this article, I present how to use the MERGE statement in a stored procedure to merge a single record and how to use it to merge a list of records by using Table-Valued parameters in SQL Server.
• Stored Procedure with Dapper in .NET Core APIFeb 12, 2024. f you're diving into .NET Core development and want to leverage the simplicity and efficiency of Dapper for working with databases, understanding how to use Dapper with stored procedures is a valuable skill. In this article, we'll explore the basics of integrating Dapper with stored procedures in a .NET Core application.
• Efficient API Development Database Operations in ASP.NET Core Web Using Dapper and Stored Procedures Dec 26, 2023. Employing Dapper in ASP.NET Core for database operations brings a streamlined approach to handling data, ensuring efficient and straightforward interactions. When complemented with stored procedures, this combination elevates the API development process, enhancing performance and maintainability. Leveraging these tools empowers developers to create robust, high-performing applications while simplifying database access and management.
• Query to Find and Drop User-Defined Stored ProcedureDec 20, 2023. In this article, we will learn about dangerous SQL scripts that iterate through user-defined stored procedures, views, functions, and user-defined types, dropping them one by one. Caution: Do not run in production environments; it poses serious risks.
• CRUD Stored Procedures in Azure Cosmos DBOct 26, 2023. In this article, we will learn how to create the stored procedures in the Azure Cosmos DB for inserting, reading, updating, and deleting the Azure Cosmos DB collection items.
• Stored Procedure in SQL ServerSep 12, 2023. A stored procedure is a reusable collection of SQL statements stored on the database server. It simplifies code maintenance and execution. Stored procedures can be invoked by triggers, other procedures, and various programming languages like Java, .Net, and Python, making them versatile.
• Insert JSON Array into Table with Stored Procedure ParameterSep 04, 2023. Learn how to efficiently save and insert JSON array data into a database table using SQL Server's T-SQL language, with adaptable concepts for other database systems.
• Understanding User-Defined Table Types (UDTs)Aug 04, 2023. Learn about User-Defined Data Types (UDTs) in database management systems. UDTs offer flexibility to create custom data types, enabling better organization and management of complex information in various scenarios. Explore examples and benefits.
• How to Implement Login Stored Procedures with Node.js and MySQL?Jul 27, 2023. In this article, we learn how to create a login stored procedure MySql and how to call Stored Procedure in Node.js.
• How to Create Stored Procedures for CRUD?Jul 23, 2023. In this article, we will learn how we can create Stored Procedures for CRUD operations in SQL Server.
• Calling a Stored Procedure in ASP.NET CoreMay 22, 2023.
• How to use MySQL Stored ProceduresMay 01, 2023. MySQL Stored Procedures are pre-compiled SQL code blocks that are created and stored in the database and may be executed whenever necessary for better performance and security.
• Stored Procedures Vs Functions In SQL - Types, Differences, And Best PracticesApr 03, 2023. This article provides a comprehensive guide to stored procedures and functions in SQL, including their types and differences. It explains how these powerful tools can simplify database management, enhance security, and improve performance. The article also provides examples of different types of stored procedures and functions, such as simple stored procedures, input and output parameters, scalar functions, and table-valued functions. Furthermore, it highlights the differences between stored procedures and functions in terms of their usage, purpose, and return values. Finally, it includes best practices for using these tools in SQL programming.
• How To Pass JSON As Parameter To Store ProcedureMar 17, 2023. In this article, you will learn how to pass json as parameter to store procedure.
• How To Post Data Using Stored Procedure With MuleSoftMar 16, 2023. In this article, you will learn how to post/insert data with input parameters using stored procedure with MuleSoft project.
• How To Call Stored Procedure With MuleSoftMar 10, 2023. In this article, we will learn how to call Azure SQL Server Stored Procedure with MuleSoft.
• Step By Step Procedure To Create An Environment For Power AutomateMar 06, 2023. This article will guide you through the process of creating power automate environments and provide instructions on how to manage environment creation using the admin center.
• Stored Procedure With Searching, Sorting And Pagination In SQL ServerJan 14, 2023. In this article, we will create a Stored Procedure in SQL Server that fetches data from tables and performs operations like searching, sorting, and pagination based on parameters passed in that stored procedure and return data.
• Why We Use Stored Procedure In SQL ServerJan 11, 2023. A stored procedure is a set of SQL statements that is stored in a SQL database. It is used to perform specific tasks. SQL stored procedures are used to execute the same set of statements multiple times, improve performance, improve security, and make the application easier to maintain.
• CRUD Operation Using Entity Framework Core And Stored Procedure In .NET Core 6 Web APIOct 31, 2022. In this article, you will learn about CRUD Operation using Entity Framework Core and Stored Procedure in .NET Core 6 Web API.
• ORM Vs Stored Procedures In ProgrammingAug 10, 2022. In this article, you will learn about ORM vs Stored Procedures in Programming.
• How To Use Stored Procedure By Getting Database Connection Using DbContext In RepositoryJul 09, 2022. Sometimes we need to create API/s and perform custom operation with database where we can perform create, insert, update and delete on entity/ties or table/s according to our requirement. Then we can use Store Procedure.
• Customize Swagger UI In ASP.NET Web API Restful ServiceMar 30, 2022. Swagger UI is very powerful documentation tool for Restful services so lets learn how we can implement and customize in Web API Restful service.
• Implement Swagger UI In ASP.NET Web API Restful Service For Documentation Using SwashbuckleFeb 28, 2022. Swagger basically is a framework for describing, consuming, and visualizing RESTful APIs. The nice thing about Swagger that it is really keeps the documentation system, the client, and the server code in sync always, in other words the documentation of methods, parameters, and models are tightly integrated into the server code.
• Table As Input Parameters For Stored ProcedureFeb 21, 2022. This article will discuss the StoredProcedure Parameter: DataTable.
• How To Query Dataverse In Microsoft SQL Server Management Studio (SSMS)?Dec 08, 2021. Querying Dataverse in Microsoft SQL Server Management Studio (SSMS) involves using Transact-SQL (T-SQL) to interact with tables, views, indexes, and stored procedures. Understanding entity relationships and data types is crucial for accurate retrieval and manipulation of data within Dataverse.
• Asynchronous RPC Communication Using RabbitMqDec 06, 2021. This article provides a walk-through for creating an Asynchronous RPC communication between two applications using RabbitMq
• Split Alphabets From Alphanumeric String In SQL ServerFeb 03, 2021. This article gives an explanation about how to split alphabets from the alphanumeric string in an SQL server. Here I'll also explain how to create a function in an SQL server.
• How To Create And Use Procedure And Function In PostgreSQLJan 25, 2021. PostgreSQL is the most popular object-relational database system. It is robust, high performance, plus open-source, and free.
• Create Dynamic Pivot Table Using Store ProcedureJan 18, 2021. Learn how to create a dynamic pivot table using a stored procedure in SQL. This guide covers transforming rows into columns dynamically, automating pivot table creation, and efficiently querying large datasets.
• SQL Server Create And Execute Parameterized Stored Procedure From Another Stored ProcedureJan 11, 2021. In this article am going to explain how to create and execute parameterized stored procedure From another stored procedure, how to prevent SQL Injection attacks, how to insert data in the table using stored procedure in SQL Server with example. And also show you how you can use the procedure in SQL Server with an example.
• How To Convert List <DataTable> Into DataSetDec 29, 2020. Retrieve employee details from database using stored procedure. Group data by department with LINQ. Export List&lt;DataTable&gt; to Excel with multiple spreadsheets. Bind List&lt;DataTable&gt; to GridView for display. Assistance needed for implementation.
• Introduction To gRPC And its Implementation In .NET Core 3.1Dec 14, 2020. Learn the fundamentals of gRPC and its integration with .NET Core 3.1 in this introductory guide. Discover how gRPC facilitates efficient, cross-platform communication using protocol buffers. Explore service-oriented architecture, remote procedure calls, and asynchronous messaging for building robust distributed systems.
• ASP.NET Core, Web API - Entity Framework Call Stored Procedure ImplementationDec 09, 2020. We can build Web API and Entity framework with code first or database first approach, however, it is hard to do so in the real working environment with ASP.NET Core Web API calling stored procedure. This article will give the way for developers by using ASP.NET Core, Web API, Entity Framework to call Stored procedure, step by step.
• ASP.NET Core, Web API - Entity Framework Call Stored ProcedureDec 09, 2020. We can build a Web API and Entity framework with a code first or database first approach, however, it is hard to do so in the real working environment with ASP.NET Core Web API calling a stored procedure. This article will give a way for developers to do this by using ASP.NET Core, Web API, and Entity Framework to call a Stored procedure step-by-step.
• CRUD Operation In C# Windows Application Using Store ProcedureNov 16, 2020. This guide explores implementing CRUD operations in a C# Windows Forms application using stored procedures. Learn to connect to SQL Server, execute stored procedures, and handle data efficiently.
• C# Artificial Intelligence Login Details - Application Based On SQL Store ProcedureNov 09, 2020. In this article, you will learn about C# Artificial intelligence login details for an application based on a SQL store procedure.
• Implement Stored Procedure, UDFs And Trigger In Cosmos DB Using ASP.NET Core Web ApplicationSep 09, 2020. In this example, we will demonstrate how to implement Cosmos DB related Server-side objects like Stored Procedure, Trigger, UDFs, etc in an Asp.Net Core Applications.
• How Safe Is Enhancing The Product Development ProcedureAug 11, 2020. In this article, you will learn how safe is enhancing the Product Development Procedure.
• .NET Core Web API Curd Service Based On SQL Store ProcedureAug 03, 2020. In this article, you will learn about a .NET core Web API Curd Service based on a SQL store procedure.
• How To Build Server Side Objects Like UDF, Stored Procedure, & Trigger In Cosmos DBJul 13, 2020. In this article, we will discuss the UDF, Stored Procedures, and Triggers in Cosmos DB.
• What Is Stored Procedure In SQL Server?Jul 11, 2020. In this article, we are going to learn about the Stored Procedure and the difference between Stored Procedures and Functions.
• Build 🏗️ Age Calculator Application Using MVC And SQL ServerJun 08, 2020. In this article you will learn about Age and Years of experience calculator using MVC and scalar function.
• Calculate Age And Experience Using Table Data And Stored Procedure In MVCJun 03, 2020. In this article, you will learn how to display the date in year, month, and days using a scalar function with a stored procedure in MVC filter.
• Consuming Web API In .Net Core 3.1 MVCMay 28, 2020. In this article, You will learn how to consume web API in .Net Core 3.1.
• Filter Records By Passing Multiple Parameters In Stored Procedure Using MVCMay 27, 2020. Here we can filter records using by passing various input parameters to stored procedure and Dynamic Sql in MVC.
• Learn About Stored Procedure Scaffolding Utillity For .NET Core 3May 16, 2020. This article shows how to use SPToCore utility to scaffold stored procedures for a .NET Core project
• Stored Procedure in SnowflakeMay 04, 2020. A Stored Procedure in Snowflake is a precompiled set of SQL and/or JavaScript code that can be stored in the Snowflake database and executed later as a single unit. It allows you to encapsulate complex logic or business rules into a reusable and manageable code block. Stored procedures are primarily used for performing repetitive tasks, complex calculations, data validation, or any operations that involve multiple SQL statements and business logic.
• Search Records Between Two Dates Using Stored Procedure, Web API And ReactJSApr 09, 2020. In this article, you will learn how to search Records Between Two Dates Using Stored Procedure, Web API And ReactJS
• Rethinking Sorting In SQL Server Stored ProceduresJan 31, 2020. In this article, you will learn how to sort in Stored Procedures
• SQL Bulk Insert And Update Records Using Stored ProceduresJan 20, 2020. Today we will learn how to insert and update multiple records using single stored procedure and user defined table type
• SQL Stored Procedure TutorialJan 07, 2020. In this article, you will learn how to use Store Procedure in SQL.
• Using Table Type Parameter In .NET CoreDec 30, 2019. In many cases, we need to send a list of objects to the stored procedure to save or update the list of data in the database, which helps in increasing the performance of the application. Here I&#39;ll explain how to send a list of data to stored procedure from WEB API (Entity Framework) .NET CORE.
• PowerQuery - Dynamically Pass Database Name as Parameter to fetch the Records from Different Datasets using Managed Parameters and FunctionsNov 05, 2019. In this article, we will talk about how we can get the database name using Stored Procedure based on the Customer ID and pass that Database Name to another stored procedure as a Parameter to load the records from that particular dataset using Functions.
• Effective Paging, Sorting And Filtering Using SQL Server Stored ProcedureOct 29, 2019. In this article, I will cover and discuss the Effective Paging, Sorting and Filtering with Stored Procedure in MS SQL Server.