Thanks , I have used 1st method!!

Thanks for your reply.

I applied below syntax to get the result:

dateAdd(hour,(datediff(hour, getdate(),getutcdate())-1), getdate())

I also wanted to get UTC today's midnight datetime ...How do i get that??

What is your requirement and expected result ??

Sean, yes ,SQL shows Error conversion... Instead of this, is there any possible way to display user-defined msg??

or If the above is feasible from reporting end (SSRS)....??

Can someone tell me how to validate the input paramater from SSRS reporting ??

try this..

where (Commodity like '%' + @Commoditylike + '%') or (Commodity Is NULL)

Here is an example of what im expecting..

CREATE PROCEDURE sp_test

(

@number float

)

AS

------Do Pre-Check if valid parameter-------

SELECT * FROM Works where number =@number

GO

=========================

If i execute the above SP something like: ...

Hi,

One of the cause i could think may be many users (doing transaction/accessing)hitting that particular table at the same time would lead to slow performance...

Does both the instance(PROD and STG)...

Thank you all!!

Many Thanks frfernan!!

I have changed my function as advised... The output return within secs..Cheers!!

ALTER FUNCTION CountDocumentFunction

(

@ID float

)

RETURNS INT

AS

BEGIN

DECLARE @Out int

SELECT @Out = COUNT(DISTINCT B2.ITID) FROM MainProjects B1

INNER JOIN ITEMS B2 ON B1.id = B2.id WHERE B1.TID = @ID

RETURN @Out

END

Can anyone help me on this?

It will be great if you provide an example...

Hmmmm... i just want to print the output in a text file 🙁 ....any alternative way u could suggest??

Thanks 🙂 ..