I have the following stored procedure where I have data coming from @promocode I want to find the closest match to the string supplied. Below is what I have so far which matches exactly...I want the match to work finding the closest string or the first string that matches even if its only 1 character that matches.
CREATE PROCEDURE FindCorrectPromoCode
SELECT PromoCode FROM BrandseedPromoCodes
WHERE PromoCode = @PromoCode
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.