Click here to Skip to main content
15,880,972 members

Questions

Questions

1
answer

Create recursive CTE for this table

19-Nov-22 20:48pm - updated 19-Nov-22 21:20pm
0
answers

Can anyone help me with code optimization on my T-SQL 2K16 query?

14-Sep-20 21:07pm - updated 14-Sep-20 21:12pm
1
answer

Help me to achieve this result of query like below given output

12-Feb-20 0:12am - updated 12-Feb-20 1:52am
1
answer

Conversion of CTE to temp table in SQL to get all possible parents

10-Sep-19 3:15am - updated 10-Sep-19 3:35am
2
answers

How to get day differences and fiscal date ranges by providing start date and end dates

2-May-19 0:57am - updated 7-May-19 20:49pm
2
answers

T-SQL single row corresponding rows

6-Jun-18 7:37am - updated 7-Jun-18 0:18am
1
answer

Convert SQL server 2012 query to SQL 2008

7-Sep-16 22:58pm - updated 8-Sep-16 2:58am
2
answers

Retrieving hierarchical table data as simple table format for report? Help please!

18-Aug-16 2:44am - updated 25-Aug-16 22:07pm
1
answer

How do I solve the problem with my query?

8-May-16 14:32pm - updated 8-May-16 21:51pm
1
answer

Query to group and sort hierarchical data

17-Nov-15 23:29pm - updated 18-Nov-15 23:15pm
3
answers

Need Help in Recursive Query in SQL using CTE

14-Sep-15 4:18am - updated 14-Sep-15 20:22pm
3
answers

show previous quarter avg sale with current quarter avg sale

1-Sep-15 4:40am - updated 6-Sep-15 19:18pm
1
answer

How to acheive result set basing on cte's and levels

31-Mar-15 4:26am - updated 31-Mar-15 7:08am
1
answer

How can we use CTE in sql?with example

21-Sep-14 20:44pm - updated 21-Sep-14 20:54pm
1
answer

Merge Parent and Child Tables

11-Sep-14 0:43am - updated 12-Sep-14 20:34pm
1
answer

Weekly Item Count in SQL Server

13-Mar-13 12:46pm - updated 13-Mar-13 14:28pm
2
answers

creating stored procedure for 'th' highest marks

17-May-12 19:20pm - updated 17-May-12 19:43pm

To narrow down your search try filtering by tags using the Filter box at the top right.