ShorePatrol (8/7/2015)

---

Hi Folks,

I have some indexes over 30% fragmented. Some are much more...

I have a job maintenance plan to "re-organize" indexes every Sunday on all databases. I didn't know if...

Usually, if the number of records to appear in a separate report is small enough, there's really no reason NOT to have a section whose visibility is controlled. ...

brett.walker (8/6/2015)

---

Hello,

This question is regarding SQL Server 2008 R2 SSRS. Please let me know if this is the incorrect forum and I'll move it.

I have a balance sheet report...

Depending on how you need to make this decision, try something along the...

Okay, two things:

1.) By just throwing out "Invalid" instead of a negative result, you end up hiding the true cause of the problem, AND you might well entirely miss any...

fnndala2 (8/5/2015)

---

@Grant Fritchey thank you, I do get your concern very well and at first I was not aware that the question is missing some query calling the function but...

The original Oracle query was recursive, and the CTE, or Common...

I think I'd take the source and re-compile using a .NET 4.0 or later framework and at least Visual Studio 2008, if you haven't already tried that... Beyond...

Yogeshwar Phull (8/5/2015)

---

Hello,

I have a procedure that was taking around 11-12 seconds to run on SQL Server 2012 Enterprise edition with Always ON configured..

There is table named fs.performance that has...

s.chandrahasan (8/5/2015)

---

Dear All ,

declare @var varchar(8000)

set @var='Name1~50~20~50@Name2~25.5~50~63@Name3~30~80~43@Name4~60~80~23'

---------------------

Create table #tmp(id int identity(1,1),Name varchar(20),Value1 float,Value2 float,Value3 float)

Insert into #tmp (Name,Value1,Value2,Value3)

Values ('Name1',50,20,50 ), ('Name2',25.5,50,63 ), ('Name3',30,80,43 ),...

dmartins.dam (8/5/2015)

---

ERRATUM.

Correct query :

select b.isin, a.market, a.ccy, a.stock_mkt, max(a.year)

,max(a.month), max(a.day) from market_table a inner join

isin_table b on a.id =...

I know, but at the time I started that post, no one else had responded yet....

kennyhuang0108 (8/4/2015)

---

Thank you all.

I think the result I would like to see is as below

sorry for the confusion.

Bf_ORGN_CD LEV5 ...

Luis Cazares (8/4/2015)

---

Hi welcome to the forums.

What you explain might be possible, but a simple pdf with truncated rows won't help. We need DDL, sample data as insert statements and...

Eirikur Eiriksson (8/4/2015)

---

sgmunson (8/4/2015)

---

According to MS doc, that applies only to...