Viewing 15 posts - 1 through 15 (of 17 total)
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=...
May 21, 2008 at 3:14 am
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...
May 20, 2008 at 9:03 am
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...
May 20, 2008 at 7:52 am
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...
May 20, 2008 at 7:31 am
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...
May 20, 2008 at 6:36 am
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...
May 7, 2008 at 8:00 am
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...
May 7, 2008 at 6:44 am
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)...
May 7, 2008 at 6:21 am
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...
June 4, 2007 at 7:29 am
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...
April 30, 2007 at 7:59 am
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....
April 30, 2007 at 7:33 am
I would be greatful to Rudy and Jeff, if they can pass me their list for performance tunning and optimization
Thanks once again....
April 30, 2007 at 3:14 am
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...
April 30, 2007 at 3:05 am
Viewing 15 posts - 1 through 15 (of 17 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy