Stored Procedure with optional parameters - Hi, I have a table create table StudentBankDetails (AccountID nvarchar(10) not null , Name nvarchar(255) not null , [Address] nvarchar(255), CurrentBalance Money , BankStatus nvarchar(10)) and...
Calling a Insert/Update Stored Procedure from a Result set of Query - Hi, I have created a stored procedure(1) to do an insert / update when a parameter is passed. i have a table...
Data file growth events and clustered index - Hello Guys, I a table of around 10 GB size. Recovery model of database (SQL Server 2005) is simple. For some...
How to modify query to only use base tables - I'm new to SQL so I'm not really sure what to do. Also not sure if I'm on the right forum...
Table copy - hI all, how can i copy a table with an specific amount a data. example: myTable has 5 millions rows. I will create myNewTable...
moving sql2005 database to sql2014 - Hi, Can we directly restore sql2005 database backup on sql2014 instance ? thanks.
Options for auditing SQL logins - We're running SQL 2014 SP1. We're needing to audit who is logging into SQL to check if SQL users are...
Query help filling in dates and data - I have a data table and a calendar table. I need to fill in the gaps to have a row...
Query help - Maybe my skull is a little too thick today but I cannot figure out why this is not grouping correctly: SELECT...
GROUP BY in SQL Server 2014 - Hello all, The same query with a group by clause I try to run on SQL Server 2005 and on SQl...
How to extract overlapping date ranges from a table of date ranges - Would appreciate help and or hints to the following scenario:: Magazine subscriptions are registered on a per subscriber basis with subscription...
Help with Query to Look at the list and return repeated value if condition is met - Hi Everyone I asked a similar question in my previous post but didn't get the right result , although it is nearly...
When Your Primary Key is Not the Clustered Index - Hi, We have tables that have primary keys that are not the clustered index. The primary key still gets used...
How to imbed an image into an email sent by dbmail - Hello all and thank you in advance for your time and expertise. I am sending out customer statements in email using...
SQL Reproting Failed to query - Hi Good Day, Kindly please help me on my problem regarding the reporting services of SQL server. I have a...
Reporting Services From a Data warehouse - Bottleneck On Every Month - Hi All, I am a Software Engineer working in an MNC on MSBI Platform. I have been working in Reporting services project...
Warning 1 [rsInvalidColor] The value of the BackgroundColor property for the page ‘Page’ is “Light Green”, which is not a valid BackgroundColor. - I am following examples/exercises in this book: https://drive.google.com/open?id=0ByFnKe4djAO-d29ZTUJrbExhbzQ page 238. I am getting an error: Warning 1 [rsInvalidColor] The value of the...
IF Exist Delete file and copy a Template File VB.NET Script Task - I'm trying to remember how I would check for the existence of a file and Delete it in a VB...
Importing Excel file - Overriding the ACE driver's field type - Hi All, I know this is an age old problem, however, does anyone know how to get around the ACE driver...
Change the Language for SSIS Script Task - How can I change the OOP language that SSIS uses for things like the Script task? Mine comes up to...
