Viewing 15 posts - 1 through 15 (of 81 total)
Error
---2146827284 - Microsoft Excel cannot access the file 'C:\temp\Book2.xls'. There are several possible reasons: • The file name or path does not exist. --• The file is being used...
June 17, 2022 at 3:55 pm
Thanks for the reply. How about the views, how we can audit that info?
November 12, 2021 at 1:35 pm
i checked the slowness is coming from auditLog table. Its a big table as it stores audit records.
November 5, 2021 at 2:34 pm
Any idea on how to do that?
September 2, 2021 at 2:20 pm
Ok Thanks. Actually i am on SQL Server 2005. i was not able to locate 2005 forum.
February 20, 2020 at 2:04 pm
allocation should exclude weekends and hoildays.
If Jan Budget is $200 and working days in Jan is 20 , So daily budget for each working day should be $10 and for...
February 20, 2020 at 1:51 pm
Trying to create a folder on the network. But even my command says xp_cmdshell 'dir c:\', it errors out with insert fail.
July 31, 2018 at 8:38 am
I would like to have it at database level. Depending on what database is getting accessed, I would like to set parameters.
Let me give some background.
We use...
April 10, 2018 at 9:21 am
Thanks for the reply. The problem is the output of the stored procedure is a dataset and it could have multiple demand. If there a one demand for a supplyid...
August 29, 2017 at 2:56 pm
I don't know the DB detail. The Stored procedure gives the list of demand for the supplied SupplierID. We just keep looping thru until we don't find Demand for the...
August 29, 2017 at 11:12 am
Here is the Example
Customer Order Line :
ORD00001 - 1
--JOB- JOB0001
----JOB-JOB0002
------JOB-JOB0003
--------JOB-JOB0004
----------MATERIAL-Matl01
ORD09999 - 1
--JOB-...
August 29, 2017 at 9:52 am
This does not build the hierarchy.
I am expecting these records to show (has parent id of 56)
March 3, 2017 at 12:29 pm
Viewing 15 posts - 1 through 15 (of 81 total)