90 also having no compitablility issue

Give alias to to your set set of query

May be this will help you

SELECT a.Province ,a.District ,

FPS =

STUFF ( ( SELECT ','+ b.fp

FROM #Result b

WHERE a.Province = b.Province

AND a.district = b.district

GROUP BY FP

ORDER...

SELECT *

FROM

#Companies

WHERE CompanyID = @CompanyID

OR

(

CompanyID IS NULL AND

CompanyID IN(Select CompanyID FROM #CompanyGroups WHERE CompanyGroupID = @CompanyGroupID)

)

Try this

SELECT *

FROM TableA a

LEFT OUTER JOIN TableB b ON a.LoanID = b.LoanID

WHERE b.ColumnA <> 'Y'

When we use INNER JOIN it will consider only commom records. But the user...

Using inner join A.id=B.id-1

Using cte expression and join

Maybe data type mismatch issues.

Make sure variable type and column types are same.

May be this query will help your problem

CREATE TABLE #Temp (Name varchar(100), value int)

INSERT INTO #Temp

SELECT 'Day1', 12

UNION

SELECT 'Day2' ,6

UNION

SELECT 'Day3' , 10

UNION

SELECT 'Day4' ,8

UNION

SELECT...

DECLARE @number INT = 1000;

SELECT STUFF(

(

SELECT SUBSTRING(CAST(@number AS VARCHAR(19)),Num.N,1)

FROM sys.columns Col

INNER JOIN

(

SELECT N

FROM

( VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9), (10),(11),(12),(13),(14),(15),(16),(17), (18),(19)

)A (N)

)Num on Num.N<=(LEN(@number))

Group By Num.N

ORDER BY...

Is theere any releationship between ProviderId, Address and City. If then use PIVOT

You can refer this blog

http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/75dbead0-0144-4a68-b2d6-02df12873341

Deterministic results will get the same result set at any time with specific set of input values

Ex: dateadd function

Nondeterministic result will get the different result with specific set of input.

Ex...

Make sure Report SP is working fine with the input parameters.

We can simplify the above query to

select @v-2 =case when t1.col2 like '%*%' then t2.col2 else t1.col2 end

from @table1 t1, @Table2...

Try this

SELECT PARSENAME(REPLACE('/Folder/File/Name', '/', '.'), 2)