Thanks! I'd never seen that before! That'll save me several lines of code next time.

Hi,

No worries, if you want to show the 1900 dates as a blank you could always convert the date back to a varchar using the appropriate style and then do...

Run a report on table size, that may give you a clue on where the space is being taken up. If you compare this report now to later on you'll...

Hi,

This will turn those dates to NULLs

CREATE TABLE #TextSample ( Event VARCHAR(50), Date VARCHAR(8))

INSERTINTO #TextSample

SELECT'Event1' Event, '12/12/12' Date UNION ALL

SELECT'Event2', '01/12/12' UNION ALL

SELECT'Event3', '' UNION ALL

SELECT'Event4', '20/11/12' UNION ALL

SELECT'Event5', ''...

Hi,

The fact that you have more records in the second query would seem to suggest that you have many CETSH.CETSHNumber to INVOICE.TarrifHeadNumber's.

You really should be specifying a join predicate rather...

Hmmm... in that case i'm not sure.

Maybe try a repair install of Visual Studio. That may fix it. Other than that, someone else may have some other suggestions.

Thanks,

Simon

Can you execute other tasks or is it just the script task that won't run?

Nice article Steve. I simply couldn't agree more with this. Managers should have faith in their staff and trust that they know what they're doing.

I have sometimes found that...

Hi,

If you have several instances running on one machine ensure that your SQL Browser Service is running, if it's not then this may be your problem.

Thanks,

Simon

Hi,

As a further update to this... It turns out that the reason my actions were not appearing on my cells was because i had a filter on my excel report...

Hi,

As an update to this. It seems that this action does work but not on pivot tables that have previously been created. If i create a new table then the...

No problem. If you want to make our lives easier to help you in the future you should create a script something like Lowell and I did. That way more...

Hi,

It's because you've not selected the RowID... See below.

DECLARE @cte TABLE

(

RowID INT,

Region VARCHAR(50),

Factor VARCHAR(50)

)

INSERT INTO @cte

SELECT 1, 'Capitol', 'Text1'

UNION ALL SELECT 2,'Capitol', 'Text2'

UNION ALL SELECT 3,'Capitol', 'Text3'

UNION ALL SELECT 1,'Central',...

Hi,

I'm also of the understanding that "cost" is just an arbitrary no.

This link seems to back that up.

Thanks,

Simon

Hi,

From what you've described, if I were you I'd uninstall SQL Server completely and then reinstall it from fresh with all the features you want.

If you run into problems after...