Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Insert space char into results
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))+'... -
Insert space char into results
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'... -
Insert space char into results
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. -
Find the first result of a given day
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! -
Find the first result of a given day
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. -
Find the first result of a given day
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. -
Find the first result of a given day
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...
