The fact that different users will be Inserting data is irrelevant.

All you need to do is encrypt the column/s in question and decrypt when retrieving.

SYMMETRIC ENCRYPTION is your best choice...

I believe your unnescasaryilly compliticating your requirement.

You'll need to choose 1 or the other and not mix the both for the same task at hand.

SYMETRIC ENCRYPTION is by far better...

Hi,

From that link I was able to work out what I needed to do.

This is what I needed, I needed to get the first day of the month of the...

Ok thanks.

If it's just Logon Inforamtion you wish to capture then go for the System Functions.

I don't see the point of EVENTDATA() for your requirement. The System Functions will also perform...

Ahhhhh...

🙂

Of course, the entire query is wrapped around the alias PivotTable not DataTable 🙂

WayneS, thanks so much for your valuable help again.

I have learn't lots from you today.

Cheers.

I don't get it!

I removed DataTable.* with just * and it works

The working query now looks like this,

DECLARE @CurrMonth VARCHAR(20)

DECLARE @CurrYear INT

DECLARE @PivotSQL NVARCHAR(MAX)

DECLARE @PivotColumns NVARCHAR(MAX)

DECLARE @i SMALLINT = -2

SET...

Hi WayneS,

Here is the modified query, but i get an error,

Msg 107, Level 15, State 1, Line 3

The column prefix 'DataTable' does not match with a table name or alias...

Thats doesn't work.

It's not as if you can darg that total and place it onto the chart. Charts don't work that way.

Well done WayneS.

Thanks for your help.

WayneS,

It works. Your modified IN CLAUSE is what the problem was. Thank you.

Just one question though, in this case the parameter is of INTEGER DATATPE and as you pointed out...

WayneS,

Thanks for the reply.

I did what you said and I get the exact same error "Incorrect syntax near ')'

Here is the updated query with the IN CLASUE as you recommended.

="SELECT...

Old Hand is correct! It's not Value Added Tax.

Ok thanks that works but why? Why can't you use 2,2?

Hi Bevan,

Thanks for that. both options work, I will use option 2.

Thanks for that.