Viewing 15 posts - 136 through 150 (of 1,124 total)
Can you post some sample data from the file to know how it looks?
May 19, 2009 at 10:03 am
Try executing the query by connecting to server using windows authentication.
And in services, look for "SQL Server (MSSQLSERVER)" (in case of default instance) or "SQL Server ("InstanceName")" (in case of...
May 19, 2009 at 10:01 am
It was my bad!!! This is what happens when you post late in the night:w00t:
Change the expression to
(DT_WSTR,4)YEAR(GETDATE())
+ RIGHT("0" + (DT_WSTR,2)MONTH(GETDATE()), 2)
...
May 19, 2009 at 9:43 am
Are you connecting to sql server using sql or windows authentication?
Which is the service account for sql server service? (Go to Run > services.msc > Goto SQL Server > Properties)
May 19, 2009 at 9:33 am
Can you post the expression you are trying to evaluate?
May 19, 2009 at 9:21 am
uppal.kunal (5/19/2009)
hi Ramesh,i did changes according u
but still showing me same error
here is below the changes i did in my query
Didn't you read my post correctly? ...
May 19, 2009 at 9:06 am
Go to Window Explorer > Right click on directory "P:\TranAssignments\ROCAPData" > Click on Properties > Go to Security > Click Add > Type "Everyone" > Click Check Names (you see...
May 19, 2009 at 8:55 am
Change this part of the procedure
CREATE PROCEDURE [HSI].[usp_MonthlyEPCHazardousSpillReport_2]
@month int,
@year int
To
CREATE PROCEDURE [HSI].[usp_MonthlyEPCHazardousSpillReport_2]
(
@month int,
@year int
)
AS
May 19, 2009 at 8:44 am
Check if the below query works for you.
DELETE
FROM dbo.tblInvoice I
WHERE EXISTS( SELECT * FROM dbo.tblRange R WHERE I.DueDate BETWEEN R.FromDate AND R.ThruDate )
Edit:
You...
May 19, 2009 at 8:36 am
The only way I can think of is using LIKE operator
SELECT *
FROM People p
INNER JOIN [Content] c ON...
May 19, 2009 at 8:31 am
Give the read/write permissions to the directory "P:\TranAssignments\ROCAPData" to SQL Service Account or Everyone (only if security is not an issue).
May 19, 2009 at 8:25 am
Prefix the destination variable with
(DT_WSTR,4)YEAR(@[User::DateTimeVar])
+ RIGHT("0" + (DT_WSTR,2)MONTH(@[User::DateTimeVar]), 2)
+ RIGHT("0" + (DT_WSTR,2)DAY(@[User::DateTimeVar]), 2)
For more sample date-time formats, click here
May 19, 2009 at 8:22 am
How about posting the code of the stored procedure?
May 19, 2009 at 8:16 am
MarkusB (5/19/2009)
May 19, 2009 at 8:14 am
Where is this file "P:\TranAssignments\ROCAPData\ROCAP.xls" located? Is it on your local machine or on the Server (where SQL resides)?
May 19, 2009 at 8:13 am
Viewing 15 posts - 136 through 150 (of 1,124 total)