sorry something wrong with formatting..

WITH Daylight AS

(

SELECT *

FROM

(VALUES

('2022', '2022-03-27 02:00:00', '2022-10-30 03:00:00', '2022-03-13 02:00:00', '2022-11-06 02:00:00'),

('2023', '2023-03-26 02:00:00', '2023-10-29 03:00:00', '2023-03-12 02:00:00', '2023-11-05 02:00:00'),

('2024', '2024-03-31 02:00:00', '2024-10-27 03:00:00', '2024-03-10 02:00:00', '2024-11-03 02:00:00'),

('2025',...

Could a function be created where I pass in my date and it outputs my desired date

okay so if I dump what ED B has for DST into a table .. what's next steps?

THx.

If I was SQL 2016 then...

JobStarted AT TIME ZONE 'Eastern Standard Time' AT TIME ZONE 'Central European Standard Time' AS JobStarted_TimeZoneCET

That server will be moving to 2016 but need solution...

How could I use the table from ED B. and perform the function I'm trying to accomplish?

Thanks.

Looks like I could do this:

switchoffset (CONVERT(datetimeoffset, jobstarted), '+04:00')

But how can I get just date\time and automate the offset based on fall\winter DST

Thanks.

Is there a table I could build to pass in my date and convert, or a function I could use...

My query s writing to a table that I need to...

So write after the

ForEach($String in $Strings)

I have been displaying variables to see which one holds my data that I want to dump to export-csv...

Any ideas how I can capture the actual line for the string capture and where to place inside of script.. I know about export-csv, but can't seem to get the...

Thanks Jeff... have tried a few display in script to see where I could inject the export-csv but not pulling the info from serach

Thx.

used in forensics to determine nightly load record processing... research... not going to load it into another backend...

Just a quick way to review...

I have used export-csv before but not sure where to insert that into the code?

Thanks Jeff,,

I have been using the formula:

if ($Average_Fragmentation -gt 40.00)

{

Write-Host -ForegroundColor Red "$Index_Name is more than 40% fragmented and will be rebuilt.";

$index.Rebuild();

Write-Host -ForegroundColor Green "$Index_Name has been rebuilt.";

}

elseif($Average_Fragmentation -ge...

This would be helpful... Thanks