Hi, thanks for the example,

Reason im using nolock is purely because my line manage has said i have to use it, I understand what it does etc iv tried...

Managed to get it to work

select * from

(

SELECT pl.ID, usr.FirstName +' ' + usr.Surname as Createdby, pl.ProspectGuid, pl.MobileNumber as CTN, pl.Firstname + ' ' +...

I need to return all the columns from the ProspectLead (pl) table which are already in the main select statement but i also need to retrieve the additional three columns...

Can any one help me with the above or point me in the right direction to help me resolve this problem.

Hi Thanks for the snippet,

Iv been playing around with the informations iv been trying to get and this is my SQL

DECLARE @DateFrom datetime

DECLARE @DateTo datetime

DECLARE @Count int

Select u.FirstName +...

Brilliant,

Thanks for the information, do you know how i could work out the percentage of orders verified? as i have the total now just curious if that was possible????

sturner (5/7/2012)

---

.Netter (5/7/2012)

---

Its not in the company standard its my line manger which has said its the number 1 rule every SQL person follows, which i did find hard to...

Hi thanks for the information,

Its not in the company standard its my line manger which has said its the number 1 rule every SQL person follows, which i did find...

Thanks for the link ill take a look 😀

Iv spent the past 30 minutes browsing the new trying to find examples of different ways you can do a select statement etc but iv just come across one, its...

I was just curious thats all, because i saw a select statement few months back that had a "in" in it, followed by brackets etc

Purely another way of doing it

Yeah you were right i had it as a string! damn it!

Thanks for the information and snippet!!

Hi thanks the snippet i recently gave didnt work it was moaning about EXISTS but iv stuck with yours and added an additional line to cater for my needs, the...

Hi Thanks for the snippert i was playing around and i think this could work aswell?

Declare @CorrectAnswers int;

set @CorrectAnswers = (

SELECT er.UserID,

SUM(CASE...