Lowell:

Gave it a few places but had no luck

SELECT BulkColumn

INTO #temp

FROM OPENROWSET (BULK 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\api.json', SINGLE_CLOB) as j

Msg 4860, Level 16, State 1, Line 1

Cannot bulk load. The...

SELECT BulkColumn

INTO #temp

FROM OPENROWSET (BULK 'H:\api.json', SINGLE_CLOB) as j

--I moved the file to a NETWORK SHARE.

gives this error.....

Msg 4861, Level 16, State 1, Line 1

Cannot bulk load because the file...

John:

Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1

SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security...

Quite unusual but our as400 system stores dates as integer.

Anyhow my solution works for the time being

No need to respond.. I found my own solution.

(

CONVERT(DATE, Getdate())

NOT BETWEEN

CASE WHEN ISDATE(monthbegindate) = 1 THEN

Cast( Cast( monthbegindate AS VARCHAR ) AS DATETIME)

ELSE

GETDATE() - 2

END

AND

CASE...

select * from Address where Referral_Note1 like '[0-9]'

That did it!

NO NEED TO REPLY TO THIS POST , AMEN!

Sue_H:

I know how to do the XL Query stuff.

Unfortunately that still leaves us having to do further scanning to get the name of the table etc.

I have pasted a section...

Select name FROM ReportServer.dbo.Catalog where type = 2

--This gives you the list of all the SSRS reports in your Reporting Server. Agree ?

-- I am looking forqward to expanding...

A picture pf the text ( a portion of it ) is attached ( I can not give you the entire file due to security reasons )

As for getting...

cool

Eirikur Eiriksson:

Sorry, but the first 2 entries in your solution should not be there. The output that I wanted will have exactly 3 "\" characters included.

I will go with the...

Cool!

That worked.

They had given me permission to a folder well below the HOME folder.

I asked them to start with the "HOME" folder and that settled the matter.

Cool and Thanks

btw - I did login as an administrator ( Press SHIFT key and Right Click on IE ICON and select "RUN as ADMINISTRATOR" )

I only see 3 links on the...

Good Morning:

Take a close look at the picture I sent. Do you see any folders ?

Can you explain in clear steps please ?

Thanks LUIS, That Worked!