I forgot to mention that the CTE and ROW_NUMBER functions are not needed at all if you change to ORDER BY with OFFSET and FETCH options.

The MAXDOP option might give...

You're welcome. Be sure to understand how the code works...

Speaking about bad coding habits :crazy:

Your code will allow sql injection. You need to parametrize your query.

You will construct your conditions like this:

if (@Date <> 0)

Begin

...

ROW_NUMBER is not designed to return data in certain order (even if it returns the rows in order most of the times when dealing with 10 rows). Your query is...

More than a simple order by is needed. You need to use CROSS TABS (or pivot if you want to complicate yourself :-P).

Here's a nice article on them: http://www.sqlservercentral.com/articles/T-SQL/63681/

And here's...

You can't guarantee and order if you don't have an ORDER BY in your query. If you have repeated values, the order won't be guaranteed either.

I would suggest that you normalize your tables and have an additional table for the telephone numbers.

What would happen if an employee has more than one cell phone? Or several...

You need to understand that people are in different timezones. It was 4am when you posted your reply.

To get the day...

You need to unpivot your table.

An easy way is to use CROSS APPLY and VALUES clause.

SELECT ParentID

,Child

,NULLIF(ParentID-1, 0) AS ParRel

FROM #TestTable t

CROSS...

Remove ",catalog.datfin" from GROUP BY.

If you include it in the group by, you'll getting the minimum value for each date and that will be each date.

That code is full of syntax errors. Missing conditions on your JOINs and ON used more than once.

BTW, your subquery might give you an error if more than one year...

Have you checked if you have any triggers on finalTbl (I assume that might not be the real name)?

You need to include it in your subquery when creating the pivot. Something like this:

from (

select t.Month_date,b.tour_date,m.bus_id,b.[status]

from #bus_master m

LEFT

JOIN #Busdetails b ON m.bus_id = b.bus_id

left outer join #temp t on...

Sean Lange (4/24/2014)

Here we created a nonSARGable predicate by casting the column but we also added an implicit conversion because now that our previous integer value has been cast a...

Number 9 and 10 are just wrong. Taking aside that number 9 suggest to make a query non-SARGable to "improve server statistics", both examples rely...