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)