Viewing 15 posts - 1 through 15 (of 39 total)
February 17, 2019 at 9:02 pm
let me rephase my query ;
i am using sql server 2012
I need help to Query optimization. Query is part of StoredProcedure which executes for more than one hour.
August 22, 2017 at 4:56 am
Also, your prior topic is...
August 22, 2017 at 4:55 am
August 22, 2017 at 2:49 am
July 19, 2017 at 5:51 am
Thom A - Wednesday, July 19, 2017 5:20 AMYour table is called FactTable. I used a temporary table in my example.
I am...
July 19, 2017 at 5:27 am
July 19, 2017 at 5:10 am
July 19, 2017 at 4:58 am
July 19, 2017 at 4:33 am
I donot have access to change your database design. The above table have may columns and i have used only sample columns for the context of the posting it.
Can...
July 19, 2017 at 4:33 am
Below is my result query...
SELECT *,
STUFF((SELECT ',' + DeptName
FROM Table_Dept
WHERE ',' + t.DeptCode + ',' LIKE '%,' + DeptCode + ',%'
FOR XML PATH('')),1,1,'') AS DeptName
FROM
(
SELECT h.Header_ID,
td.ListNumber,
td.PhaseCode,
td.DeptCode,
td.City
FROM Table_header h
INNER JOIN (SELECT...
February 3, 2014 at 8:30 am
Sorry,
I was not able to find the soultion with the above cte code and i need to use recusive function for the same.
January 20, 2014 at 9:55 am
Hi
The above Cte works fine.
I need to use recursive funtion since i have the stored proedure with more data columns.
In my current funcion, i am unable to do recursive of...
January 20, 2014 at 9:21 am
Viewing 15 posts - 1 through 15 (of 39 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