troubleshooting Question

Need help in making the desired output in a query

Avatar of dileepav
dileepavFlag for India asked on
Microsoft SQL ServerMicrosoft SQL Server 2005SQL
2 Comments1 Solution210 ViewsLast Modified:
Hi Experts,

I need Help in making a query, These are the steps I do here

I am taking the data from one table and storing it in a different table, But I am not getting the expeted result, I am attaching the following:

(1) Table structure for S_TIS_INTEREST_RATES - Sparse Table
(2) Table structure for TISINT
(3) Sample data for S_TIS_INTEREST_RATES
(4) Sample data for TISINT
(5) Current code that I am using for this purpose.
(6) Expected O/P.
(7) Current O/P.

Current Stored Procedure I/P Param - 201104 means yyyymm

Can you please help me in getting the Expected O/P. Expect the current code all are available at the excel sheet (.xls file).

Dil. Current-Query.txt Book1.xls
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros