smtzac (8/7/2014)

---

CREATE TABLE [dbo].[ABCD](

[A] [uniqueidentifier] NULL,

[uniqueidentifier] NULL,

[C] [nvarchar](100) NULL,

[D] [nvarchar](max) NULL,

[E] [nvarchar](max) NULL,

[F] [nvarchar](100) NULL,

[G] [datetime] NULL,

[H] [nvarchar](100) NULL,

[datetime] NULL,

[J] [bit] NULL,

[K] [bit] NULL,

[L] [bit] NULL,

[M] [nvarchar](2) NULL

)...

TomThomson (8/7/2014)

---

Useful question.

I find the documention on this is utterly awful, almost incomprehensible; so getting it right was quite a surprise. I wouldn't have been at all confident if...

You're converting to style 106 (dd mon yy) before applying the MAX, so the MAX is based on string comparison, e.g. '12 Aug 2014' would be less than '30 Jul...

Hi Rob, don't envy you this situation.

As far as I can see, the FK issues are because at no point does the script insert into the sysschedules table, this is...

Roads! And bags with dollar...

No problem.

Just the rdl file I think the data file isn't an allowed file type - you can attach it here in the forum if you're happy for it to...

Hmm, oversimplifying, but...

Problem: Someone left the bank vault door unlocked. Robbers took loot & got away in cars.

Solution: Ban cars!

That's fine, Report Builder is a separate thing to Visual Studio, but if you're using VS then it doesn't matter.

I don't have the 2010 tools (and MS don't let you...

I'm getting short on ideas myself!

I can remember this happening when using visibility toggles with default to not visible, don't think that applies here though.

What version of SSRS, Visual Studio/BIDS/SSDT...

No problem, there's also page break tick boxes in the column & row groups properties at the bottom of the design page, check they're unticked too.

Beyond that, make sure there...

Hi Kurt,

Can't see anything syntactically wrong with the DISTINCT, is it throwing an error or just not returning the results you'd expect?

As for 'run for every month to get a...

Is the 'add a page break after' option ticked in the tablix properties?

Oh, and check your execution setting with Get-ExecutionPolicy if you're running scripts - the default is Restricted which doesn't allow scripts to be executed, including any you've written yourself (you'll...

Or...

Lynn Pettis (8/3/2014)

---

Can I install the SQLPS module and supporting files from SQL Server 2012 on the Windows Server 2008 systems and use them at the OS level (PowerShell 4.0)...