Looking at plan i see only 3 tables behind the views. Seems like kind of EAV database design.

Probably optimizer is totally lost on proper cardinality estimations when decoding views...

Using TVF is another story. CROSS APPLY with row-scope...

Plain Goup By

CREATE TABLE #Orders (ID INT IDENTITY(1,1),OrderID INT,ProjectId INT,ProductID INT,ProjectAmt DECIMAL(10,2),ProductAmt DECIMAL(10,2));

INSERT INTO #Orders

(

...

If as originally was stated you need preceeding months (jan, feb, march) for april, april not included, then a minor tweak is needed

LEFT JOIN

ON ... >=

...

Try

select name

from admins

where group in ('TJA','tJB','tJK','tnr')

group by name

having count( distinct group)=4

Also you can use xp_dirtree SP to get a table of files and dirs in the target physical location.

Note the path should be specified for your MSSS ...

Have you tried index on IpTo ?

karthik82.vk (3/23/2015)

---

Hi All,

I tried changing the length of @tbl_style variable from 1024 to 2000. However i am getting the same error. The @tbl_style variable has to do nothing with...

Although both queries below compute the same result set i see no reason why to go this way. 'Traditional' GROUP BY performs by far better.

select distinct [SalesOrderID], s...

Most probably proc parameter @TBL_STYLE NVARCHAR(1024) is the problem.

When concatenating two NVARCHAR(n) strings, where n is not MAX, the length of the result can not exceed 4000. Intermediate result is...

mbSanDiego (3/21/2015)

---

I had to add each column being selected into a Group by to make it work, but I do not know why.

SELECT c.CarId, c.CarName, c.CarColor, COUNT(t.TrailerId)...

Undocumented sp_MSforeachtable may process only tables needed

http://stackoverflow.com/questions/9679997/sql-server-sp-msforeachtable-usage-to-select-only-those-tables-which-meet-some-c/9680217#9680217

EXEC sp_MSforeachtable

@command1='select ''?'', count(ID) from ?',

@whereand='AND o.id in (select object_id from sys.columns c where c.name=''ID'')'

govind.sharma1 (3/20/2015)

---

declare @Xml_prod xml

select @Xml_prod= cast(c1 as xml) from OPENROWSET (BULK 'C:\xmldownload\adzunajobfeeds.xml',SINGLE_BLOB) as T1(c1)

Msg 6365, Level 16, State 1, Line 1 An XML operation resulted an XML data type exceeding...

siggemannen (3/19/2015)

---

This is part of SQL Unit-tests, so need a TSQL solution :/

HASHBYTES will give different results for following two xmls:

<xml>

<attribute1>1/<attribute1>

<attribute2>2/<attribute2>

</xml>

<xml>

<attribute2>2/<attribute2>

...

Use a compare xml tool, for example http://www.altova.com/diffdog/xml-diff.html