Ahhh very nice to know!

Thank You

Hi Eddie

Thanks,  that exactly what I needed.

I just tested it works great is is much faster than the  "Mess" I put together 🙂

Thanks

Actually just tried and it does.....
Honestly I never thought of using a join with a  Date range

There is an admission and discharge date on the table so the pupil would have to fall in that date range....
Sorry for being sloppy, sometimes its in my head...

Thanks for the quick reply
Actually I worded the select wrong
The pupil would be active in  that range could be admitted before the StartDate but still active during

Thank you for the help....
Here is what I finally came up with

DECLARE @startDate DATETIME;
DECLARE @endDate DATETIME;
--DECLARE @dateDiff INT;
SET @startDate = '2018-08-12';
SET @endDate...

Thanks for the quick reply
Actually I worded the select wrong
The pupil would be active in  that range could be admitted before the StartDate but still active during

Yes I just checked agin

Thanks
My idea was  step one moves a file, then 2 runs the ftp script , then if it fails, for some reason, I could get a notice

Hi Sean
Thanks for getting back ..
I do have a dimdate table
would you know of a short example I could follow?

Thanks

Ahhh....

I see my problem, some reports are in sub folders, so if I temporarily move it to the main folder , overwrite it with the new report, then...

So 
I can get the first line with  LEFT(e.field, CHARINDEX(CHAR(10),e.field))

but looking closer at the data

I need the first 5 lines or the first five carraige return

Great Sample..

Thanks you (even understand it..lol )
here is what I came up with 

Thanks Again
Joe

WITH XMLNAMESPACES (DEFAULT 'http://www.any.xsd')
SELECT [Title],[view...

So Maybe I'm close???

SELECT
 [SqlParameters].value('declare namespace ns="http://www.any.com/WebFramework/WorkflowParameters.xsd"; (/ns:Parameters/ns:Addendum2)[1]','varchar(50)') AS TEST
FROM [WorkflowInstances]

but erring on no element found 
Trying to parse Addendum2

Thanks

A "bit" confused, but let me do some googling and I'm sure I'll be back with questions....

Thanks Again