If I try sqlcmd -S SERVER\Instance I receive a login failure 'The server is in single user mode. Only one administrator can connect at this time...

Same error for...

Hi. I have taken a look at the commands. I thought I was attempting the correct syntax but I keep hitting a brick wall.

I am currently logged...

Hi. What is the correct syntax to use sqlcmd -E to connect to instance UPC? I am now logged in using a local admin account and the server is in...

Hi. The application log reports an informational message 'Login failed for user 'user'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]

Thanks,
Phil.

Hi. I must be missing a trick, my issue is connecting using my admin account.

C:\Windows\system32>sqlcmd -S SERVER_NAME\UPC -U 'Domain\MyAccount'
Password: Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL...

Hi. Yes I was aware of that. The account I am logged into the server with is in the local administrators group. Can you confirm the sqlcmd I should use...

Hi. Unfortunately the accounts I added are on the default instance, not the named instance! 
Latest effort:
C:\Windows\system32>sqlcmd /E /S SERVER\UPC
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server...

Good spot John. The query now runs. Time to test the logic 🙂

Many thanks to everyone who has taken time to view this post.

Phil.

Helow again. SQL reports incorrect syntax near second WHEN.

WHERE GLItems.GLYearPeriod =

CASE

WHEN MyCal.AccountingPeriod = 1 THEN ((MyCal.AccountingYear * 100 -1) + (MyCal.AccountingPeriod + 11)

WHEN GLItems.GLYearPeriod <> 1 THEN ...

Hi. I have tried adding CASE to WHERE clause.

WHERE

GLItems.GLYearPeriod =

CASE

WHEN MyCal.AccountingPeriod = 1 THEN ((MyCal.AccountingYear * 100 -1) + MyCal.AccountingPeriod + 11)

ELSE GLItems.GLYearPeriod = (MyCal.AccountingYear * 100)...

Hi Sean.

Sounds to me like a view is not what you need because you need the ability to pass in parameters. Or figure out some rules to determine which period...

Hi Chris. Thanks for the re-write. Your code still requires a parameter to be passed at time of execution.

Many Thanks,

Phil.

Hi Luis/Sean. I confirm I DO NOT wantt to use the parameters hence the re-write to enable VIEW creation.

Luis I did re-write as inline table function but I was still...

I will re-post question regards 'Table Valued Function' as this question was regards access.

Many Thanks,

Phil.

Many thanks for such swift and detailed responses.

Phil