Viewing 15 posts - 16 through 30 (of 46 total)
Hi Luis,
I have got it 🙂 ...
I have used below query to get the sum of aging bucket.
Please tell me if it is wrong Luis......
February 16, 2017 at 1:25 pm
Hi Luis,
I am having one small doubt in the SP, Sorry i didn't realize this earlier. I would also like to show one last column where it shows...
February 16, 2017 at 1:13 pm
Thanks very much for explaining the current problem and providing solution for it.
I am going through the new stored procedures and...
February 16, 2017 at 12:29 pm
GilaMonster - Thursday, February 16, 2017 12:37 AMTable definitions please & index definitions.
Hi Gila,
Thanks very much for checking this .. I...
February 16, 2017 at 12:19 pm
Thanks Very Much Steve !!!
Understood 🙂
July 30, 2016 at 7:41 pm
Hi Steve ,
Thanks very much for detailed and clear explanation 🙂
To check the subqueries, you'd need to replace the a.xx in the subquery with a particular value to...
July 30, 2016 at 6:12 pm
Hi pietlinden, SQLGuru
Thanks for your advise,
below is the query which i use for updating the table
declare cGetSicErrorData cursor for
select distinct PolicyNine, ErrorSicFour, ErrorSicFifth
...
February 2, 2016 at 5:00 pm
Hi Chris,
Thanks very much for the advise !
I have one doubt, please clarify on the below quotes,
You might have to adjust the column list in the PARTITION BY clause
You mean...
November 2, 2015 at 5:50 am
Hi Mister,
Thanks Very much for your help. Its working !!
October 22, 2015 at 10:01 am
Hi Luis,
Thanks very much for the query ! . Certain Records seems to be missing while running the query.
Hi Matt,
Thanks Very much for formatting it. I am new to...
October 22, 2015 at 6:15 am
Hi Laxmi,
Thanks for the suggestion.
I am not inserting anything into the table, I just need to Find the count of duplicates. Please tell why I need to use insert statements.
January 8, 2015 at 11:57 am
Hi GiraffeDBA,
Thanks verymuch !!!
Worked perfectly.
The issue you are running into is that the inner joins are trying to combine the records that meet both of ON clauses
Could you please...
January 8, 2015 at 11:55 am
Hi All,
Please help me in writing a query for above scenario.
January 8, 2015 at 2:04 am
Hi,
Sorry for late reply, I got disconnected from Net. I have tried the inner Join, But The expected output is not coming. Please advise.
Please check the below scenario.
I have...
January 7, 2015 at 8:41 pm
Hi Gila,
I have not tested with Production data, I will test it and let you know the status shortly.
Thanks Again.
January 7, 2015 at 4:38 am
Viewing 15 posts - 16 through 30 (of 46 total)