-- always check the equivalent SELECT is returning an appropriate result set

SELECT a.ID, b1.ID, b2.ID,

FLAGB1 = CASE WHEN b1.ID IS NULL THEN 'N' ELSE 'Y' END,

FLAGB2 = CASE...

Your query almost certainly isn't doing what you are expecting. The column Usr...

Read about BEGIN in books online. Which statements do you expect to be executed when IF returns true?

homebrew01 (1/30/2014)

---

We haven't written any code like that in a while. It is easy to search for '*=' and find the left joins. Not so easy to find the...

Tell us - try them.

vip.blade (1/27/2014)

---

Hi,

thanks for your fast response! It's a function to calculate the Levenshtein-Distance from this article: http://www.sqlservercentral.com/articles/Fuzzy+Match/92822/

As far as I know there is no way to transform...

You're welcome. If you've run the code you will have noticed that you get duplicates - the same name pair appears twice in the result set, a.firstname + b.firstname and...

-- you have to test each row against all the other rows in the table i.e. CROSS JOIN:

;WITH [50RandomRows] AS (SELECT TOP 50 * FROM [AdventureWorks2012].[Person].[Person] ORDER BY NEWID())

SELECT

a.BusinessEntityID,...

This thread has been fun to watch, thanks folks! Here's an option I'm surprised nobody posted up:

CREATE FUNCTION [dbo].[IF_ProperWithREPLACE]

(

@inputstring VARCHAR(8000)

)

RETURNS TABLE WITH SCHEMABINDING

AS

RETURN

(

SELECT ProperisedString =

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

' '+@inputstring COLLATE...

1989/90 I worked for a while in...

Each enrollee has a (random) small number of cycles, each cycle has a (random) number of symptoms - is this correct?

If a group 5 symptom is allocated at any point,...

Looking at the original code, it appears fine. A test harness works fine too, showing that your theory is sound:

CREATE TABLE #tbl_directdebits (

ID INT IDENTITY(1,1),

ref VARCHAR(2),

recurperiod VARCHAR(2),

servicelevel VARCHAR(2),...

Sean Lange (1/8/2014)

---

Take a look at the link provided by Jeff above or the same link in my signature about splitting strings....

Which is probably faster than this, but you get the idea:

WITH SampleData (VendorNbr, CCode, PayDate, NetPaid) AS (

SELECT 'AAAAAAAAA', 1, 20120101, 3000.00 UNION ALL

SELECT 'AAAAAAAAA', 1, 20120101, 6000.00 UNION ALL

SELECT...

harita (1/8/2014)

---

hi all

I am trying to insert from tableA to tableB

there are 1000 records in tableA and I want to insert 100 records at a time into tableB

idea is to...