Yes, you still need to deliberately get rid of  the first character in the first column and the last character in the last column (because they're quotes) but that's...

built a report from an SQL database for a...

The really cool part is that it's been beneficial to us old farts in many ways.  I was the big kid on the block way back when I bought...

I'd also ask what is the purpose for copying the same data to another table but with a new ID?

And, if you use the right measurements, it gives you the actual...

If you look at the following post where the OP finally posted some semblance of the data he's actually trying to filter,...

WHERE SUBSTRING([column],CHARINDEX('^',[column],PATINDEX('%PQ5|1|[0-9]%',[column])),4) = '^^^^'

And now, how to put the brakes on a migration project...

Break your wrist on a bicycle ride so you only have one hand to type with and no immediate...

What was output in the results tab?

What does Select * from [dbo].[TestView] return?

You have an extra double quote, try this

DECLARE @RecallDateTime as datetime
SET @RecallDateTime = GetDate()
DECLARE @FileExtension  varchar(4) = 'ckr'
DECLARE @FileDateTimeStamp varchar(14) = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(23), @RecallDateTime, 120),'-',''),' ',''),':','')

-- working...

queryout  is for queries (sql statements)

out is for tables/views

what was output in the results tab?

fyi

xp_cmdshell returns an errorcode as an integer if you want check if it worked or not

I can't see how it can run at all, what is the purpose of @FileExtension in the first line, if it is to extend the name of the view then...

I have never understood the utility of returning the bit value from a stored procedure execution. It's too abstract of a concept to say "it worked" or "it didn't...

Never used geometry by I suppose some this like this

SELECT N, 
GEOMETRY::STGeomFromText('POLYGON(('+CAST(N as varchar(10))+' 0, 1 1, 0 1, 0 0, 1 0))', 0) 
FROM (VALUES(1)) x...

Sent home from work yesterday AM and now working from home.

Now in isolation with Wife and family, what a bummer.

🙁