Yes, that's why I'm trying to improve my experience 😀

Grant Fritchey (6/4/2015)

---

I generally suggest outputting a file and...

Well, of course it's obvious if you explain it clearly 🙂

In my defence, I never said I knew anything about anything!

Thanks Jacob

Yes, I do:

Setup some test data first:

use tempdb;

go

-- create some test data, only 10 rows is fine

if object_id('test') is not null

drop table test;

go

create table [dbo].[test](

[id] [char](10) not null,

[dated] [date] null,

[value]...

I think the reports are "compiled" into the Segments table, so not easily changeable via TSQL.

You can use Powershell and the SSRS Web Services, here is a starter link: https://msdn.microsoft.com/en-GB/library/dn747196.aspx

DamianC (5/26/2015)

---

My version is Office 365 which provides 2013 for local use

I've done a bit of digging (including ringing MS) and found that its available on earlier versions but not...

DamianC (5/26/2015)

---

Thanks for the response

Unfortunately, it seems as though the home version does not get Powerpivot or view

I would have to buy the full blown Excel product

Would have thought MS...

Ok, so the method I would use is this:

1) Create a dataset that retrieves the user's TimeZone from the database.

2) Create a hidden parameter that takes its default value from...

I'm struggling to understand how you can convert a date to Local Time to display it, but not calculate UTC from Local Time to use in a query, could you...

ChrisM@Work (5/18/2015)

---

Compare the estimated plans for the following statements:

SELECT i.*

FROM @invoice i

WHERE i.org_id in (select item from dbo.DelimitedSplit8K(@org_list,','))

SELECT i.*

FROM @invoice i

INNER JOIN dbo.DelimitedSplit8K(@org_list,',') d ON d.item = i.org_id

In the first...

It would be great if that post had some links for further reading 🙂

Jeff Moden (5/16/2015)

---

TomThomson (5/14/2015)

---

Jeff Moden (5/13/2015)

---

TomThomson (5/13/2015)

---

Jeff Moden (5/11/2015)

---

MS has to do one very important thing... they need to slow down and do service packs 100% correct. SPs are...

You haven't said anything about your level of programming skills, so it's pretty hard for anyone to give decent advice.

For complete novices, I would suggest taking a look at Visual...

Just add a second query to the dataset/procedure (You are using Stored Procedures?)

SELECT resultid , resultvalue from ACTIONRESULT where actionid = @actionid;

IF @@ROWCOUNT=0

SELECT resultid , resultvalue from ACTIONRESULT...

Do you mean Tasks...Generate Scripts?

If so, (and even if not), you can tell that not to script triggers in the Advanced Scripting Options.

There you go - this time with RowVisibility, which is a better way for your needs.