I'm not sure whether this will help you.. But I'm giving a try,

select id, max(submit_date)

from orders

where id = "xxx"

groupby id

This problem occurs because the service environment does not read the Windows registry to obtain the most recent changes to Windows environment variables.

First check, echo %PATH% in CMD prompt...

Unfortunately, there is no built-in support for arrays in SQL Server's T-SQL.

We cannot create arrays of variables or input parameters or columns in T-SQL.. 😀

Workaround:- Write a proc (dynamic sql)...

thnx 🙂 i got this clear..

thank you jim! nxt time i will create new thread to discuss more..

but is it ok if we keep both mdf/ldf files on one common storage (LUN partition) in SAN storage?

my db size:15 gb

mdf/ldf LUN Size : 200 GB

ldf LUN size: 100...