Search results for query: *

Ok after a slight modification of your code it worked perfectly :), never thought of using string functions in SQL, it's actually quite practical. thanx for you help. (upper(left([ADEReport].[dbo].[User].[JID],1))+'...

yeah mikrom that is what I am going for but without having to manually insert the names in the query, I presume by modifying your code slightly I could achieve this. btw guys here is my code: DECLARE @status CHAR(10) SET @DateNow=convert(CHAR(10),getdate(),120) SET @status='online'...

Hi guys, I am trying to find a way to insert a space to seperate the first name and last name in my column when I query the db, currently my data is displayed this way: Abauer Jjones Asmith and I would like it this way: A Bauer J Jones A Smith Is it possible to execute this in a query.

Dear me.... removing ChangeTime from group by solved all my problems. Thank you very much guys, i'll try not to ask such a stupid question next time!

you're right, I just hope that is not solution because I played around with this code so often I can't believe I did'nt try this before. I'll let you know the result.

I don't have access to my code right now but would'nt your solution return me an aggregate function error if I don't include ChangeTime.

Hi all, First time poster needed some help with a query. I have a query which displays the time each of my students logged in on a selected given date, the problem is that sometimes they will change computer and they will have two login times, such as: g smith 20/08/2010 11:00 g smith...