This works perfectly, Thank you all for your responses. 🙂

Select

jc.intJobCardId

,b.vchBarcodeas [Barcode]

,i.dteIncidentDateas [IncidentDate]

,ISNULL(ISNULL(p.nvcDisplayName, p2.nvcDisplayName), '')as [ServiceProvider]

,dteAssignedDateas [AssignedDate]

,dteCompletedDateas [CompletedDate]

,DATEDIFF(Hour, dteAssignedDate,dteCompletedDate) as [TimeToComplete]

,ISNULL(lb.TotalHours, 0)as [TotalHours]

,lb.TotalHours/DATEDIFF(Hour, dteAssignedDate,dteCompletedDate)as [Efficiency]

,''as [Productivity]

,l.vchLocation

,typ.vchType

From dtlIncident i

Inner Join dtlJobCard jc on i.uidId...

Thank you so much, this works perfectly 🙂

@kingston Dhasian, Thank you so much for the script that's returning the dates it works perfectly.

I need something like this but now its not grouping the months properly:

Select

MIN(DATENAME(MONTH, dtePostedToWebsiteDate))as MinMonth

,MIN(Year(dtePostedToWebsiteDate))as MinYear

From dtlVacancyPostAudit

Where bitPostToWebSite = 1

Group By dtePostedToWebsiteDate

Having dtePostedToWebsiteDate between MIN(dtePostedToWebsiteDate) And GETDATE()

This...

Thank you so much, it works perfectly 🙂

Thanks for the link and the example posted above works perfectly. 🙂

It works perfectly! Thank you so much. 🙂

Thank you 🙂

Please show me the BCP example as well.

Thanks

I'd like to do it with the script as the stored proc wold be called from the application.

Thanks so much, I removed the spaces and corrected the syntax. It works perfectly.

🙂

here's the output:

<Data Extract><Graduates><Candidate><FirstName>Shaun</FirstName><LastName>Slabber</LastName></Candidate><Candidate><FirstName>paul</FirstName><LastName>devine</LastName></Candidate></Graduates><ExperiencedHires><Candidate><FirstName>paul</FirstName><LastName>devine</LastName></Candidate><Candidate><FirstName>Meera</FirstName><LastName>Bhana</LastName></Candidate></ExperiencedHires>/<Data Extract>

Thanks I have set the property to True already and it doesn't work, this seems to be working fine in Reporting services only when I export the setting is...

SELECT LEFT(SearchCol, LEN(SearchCol)-CHARINDEX('/',SearchCol)-1) AS LeftMost, RIGHT(SearchCol, LEN(SearchCol)-CHARINDEX('/',SearchCol)+1) AS RightMost

FROM MyTable WHERE CHARINDEX('/',SearchCol) > 0

--------------------------------------------------------------------

Thanks this works as well.