HI Everyone,

Well, thanks for the query, all the time, the query had been right. I went through the SP that processed it and realized that all Values of DS=...

Hi John,

Yes, I know its hard. Half of our time is spent in decoding the table structure, datatypes and the store procedure. I would say its a perfect example...

IMPORT_OCR_ADMIN_2000_1 has a field called GUID but its not same as GUID of table B.

GUID in Table A - Unique Identifier automatically generated when the fields are entered

GUID...

IMPORT_OCR_ADMIN_2000_1 is Table A

Hi mrpolecat (Any short name? Though its quite funny, very long to type each time :D)

But cd.GUID can not be NULL at all.

Basically I want then records that are...

Hi mrpolecat,

SELECT ocr.*

FROM IMPORT_OCR_ADMIN_2000_1 AS ocr

left join IMPORT_CD_D as cd

on '2OCR_ADMIN_'+REVIEW_DATE+PAT_ID+Convert(varchar(9),ocr.Form_Id) = cd.GUID and cd.DataSource_ID = '24'

where ocr.DataSource_ID = '24'

This is...

Hi All,

It worked, I mean the query had been right since the beginning, it was the data. It was not an actual NULL but a TEXT value NULL and...

Hi Grant,

I used an RIGHT outer join as I wanted to retain all values from the right table but it doesnt seem to work, its returning the same two...

Hi Grant,

I had rewritten the query to resolve this issue but also to improve performance as below:

DECLARE @REGION char(1)

SET @REGION = 'T'

DECLARE @PRAC_ID varchar(5)

SET @PRAC_ID = '11060'

SELECT Max(D.DATAAGE)...

the thing is we need to first figure out if the table has a field called Name and then if it has, then find if it does has value Name1...

Happy birthday Kendall

Hi TheSQLGuru,

I am sure, I must have got it wrong. As I addmited earlier, yes I have been ROW based thinker so far but as pointed out by Jeff, I...

Hi TheSQLGuru,

We have hired an expert and he has done an incredible job by reducing the data prcoessing time from 14 minutes per record to 3 minutes per record....

I would be greatful to Rudy and Jeff, if they can pass me their list for performance tunning and optimization

Thanks once again....

Hi Everybody,

Thanks John, Jeff and Rudy.

I never knew what I have learnt today thanks to Jeff. I was always a ROW based thinker, but from now onwards, I...