Can't monitor that.  The only you can do something remotely close is to make an audit table.  Then code the inserts in the sp to the audit table.

I owe my new nickname to Jeff. I'll let him explain it .

How do you perform the date operation without reconverting back (which renders any indexing useless)?

Even if you just do Select * ...

The key columns on which you join will be duplicates since a.id = b.id.  Only 1 of them needs to be returned.  Also...

Try this.

SELECT UsersID, COUNT(SDDField) AS SDDField, COUNT(ETField) AS ETField, SUM(CASE WHEN CMPField = "Hello" THEN 1 ELSE 0 END) AS CMPField

FROM MyTable

GROUP BY UsersID

What do you need to monitor exactly?

Can you use having!!!

Why can't you use where or case in this particular statement?

Not exactly sure of what you are asking but here's one answer.

Performance wise you should always lessen the load of the server and network.  So return as little data as...

There's no time datatype on sql server.  I would strongly suggest you keep both the data and time 99% of the time depending on the requirements. 

Also the fact is...

With what application are you going to show the report?

This is not how the data needs to be modeled...  unless this is for some special report???

It should be like

XYZ1234, First

XYZ1234, Second

XYZ1234, Third

UUU3333, Hello

UUU3333, How

UUU3333, Are

UUU3333, You?

How are you going...

This does not solve the column mapping problem.

I have already coded something like this but I don't have it with me.  I'll look into it tonight.

No the concatenation becomes this :

SELECT * FROM [Login] where [User] = 'Ninja''s_RGR''us';

If this may be more helpfull.  I think you'd be better off to do that client side.  It's a very basic loop inside another loop.

Can you do this client side? ...

The only way I ever found that was doing somewhat of a good jobs was to manually alter all the objects (must be a way to automate this but I...