thank you both  .. yes xp_cmdshell is allowed

Had to change initial query to this.

SELECT distinct substring(ImageName,1,8) as HitName from Image_Measurement_Data(nolock) where ImageName like '202405%' order by hitname OPTION (MAXDOP 0).

Now 2nd qry needs to use HitName against...

# Define your SQL Server instance and database
$ServerInstance = '(local)'
$Database = 'cb_compare'


# Define your query to read data from your source table
$Query = "SELECT distinct ImageName from...

since its using the like instead of = to for hit dates would that still work?

Thanks.

Thanks for response, would you be able to mock up an example of how that can be achieve? I just need an easy way to crank out files based off...

Jeffery and thoughts based on how the query gets data to the file to break it by day?

THanks.

Was there an issue with creating solution locally before deploy?

Yes,

$Server = "(local)"

On my physical laptop ... just testing the process before using Network share.

I was able to use CAST(textDate AS DATE) into a #temp table and do the date logic from there.

Thanks for all responses.

thanks, what I mean by hit would be each time a NEW date is found then create a new output file. If I ran this query against table this is...

okay thanks... I think problem is when I try to do a where clause against the CAST(textDate AS DATE) .

where CAST(textDate AS DATE) > mm/dd/yy

I get this

Msg 206, Level 16,...

error

Msg 206, Level 16, State 2, Line 1

Operand type clash: date is incompatible with int

Thanks for replies..

I started backup right after a server down\up ...

The backup for the past month was working fine... just started this issue a few days ago.

I'm going to try a local...

• This reply was modified 9 months, 1 week ago by Bruin.