Hi!

To do this you need to use the SP_HELP_REVLOGIN script. It is a stored procedure which (once installed) upon running generates a complete list of logins with (for sql authenticated...

Hi!

Happy to take a look but before I do can I confirm you are using MS-SQL as, in your sample, you use a natural join which to the best of...

Hi!

Three solutions which I hope cover all possibilities you may need.

James

-- Used a temporary table for demonstration purposes

CREATE TABLE #attendance

(

CalDate datetime,-- Changed name slightly to avoid using DATE as a...

Hi!

Just off out for a bit - will look into a reply for you later. One thing, do you wish the query to set the spend time in the table...

Hi!

Hope this provides some help with your query. Comments are in the SQL

James

-- Used a temporary table for demonstration purposes

CREATE TABLE #attendance

(

CalDate datetime,-- Changed name slightly to avoid using DATE...

Hi!

Happy to help on this one however, in order to do this, can you provide details of the columns in the table(s) containing the data you wish to process.

There...

Hi!

First option, you could change the column type to varchar(max) [text is, from my reading on here, to be depreciated].

As that might be a bit drastic, you can...

Hi!

From a quick look (and unless I have missed something) I think you need only to change SELECT to SELECT DISTINCT in your query to solve the problem.

James