Robert,

The source is an OLD DB connection that is running the below sql statement

select [Entry No_]

, ID

, [User ID]

, [Start Date_Time]

, [End Date_Time]

, Status

, ';' AS Delimeter

...

I have as that was the default. I changed a few different options but they did not take effect.

what other way can you create a carriage return?

Phil,

I have the format set at fixed width and the row delimeter is {cr}. I also attached a print screen.

thanks for taking a look.

OPC,

It does work with a non-sysadmin user if they are in the table. I also only tested this at the sql level so I still need to see what...

OPC,

How could I expand on this so that if a login is not in the login table then the login is allowed. Right now if a login is not...

Thanks Jeremy. I will give this a try and see if I am successful.

Something that looks like the below result set. Where we have an aggregate average on the day of the week

DayOfWeek Sunday Monday ...

kwoznica (11/9/2012)

---

Greg,

Thanks. The results came back and provided a count. I see what I was missing as well.

Now I want to get the Average of the count.

When...

Greg,

Thanks. The results came back and provided a count. I see what I was missing as well.

Now I want to get the Average of the count.

When I...

Hello everyone. I was sidetracked with another project but have finally returned to this problem. After a few considerations I believe my dilemma can be solved with the PIVOT operator....

Definately does. I was confused by the additional d and f in the inner and outer queries and thought they were needed for some reason in the...

Thanks for mentioning that...

Thanks Chris. That was very helpful....

Forget it. I found it. sp_spaceused 'tablename'

Mods you may delete this post if you wish.

I'm honored I was able to spur a healthy debate between such knowledgeable sql verterns. Based on everything I just read the best of both suggestions can be achieved. If...