SP will return same pattern always

Thanks John,

But no link is attached.

Thanks,

But the thing is it works for only current year and the input date can be last year date.

for example input date '2010-07-06'(6th July 2010) then output should be 30.06.2010.

Thanks,Can I get better link for the same?

Yes I tried,and it doesn't worked for me as the domain of the development server differs.

How to create UNC Path?

Thanks,Could you please guide me with an example,it will be grateful to me.

Code is not much complex just concatenating the big string thats it.

maga i have taken some example and produce the result.if any clarification call me

create table Employee

(

UserId BIGINT IDENTITY(1,1),

Name NVARCHAR(300),

Salary INT,

[Year] INT

)

INSERT INTO Employee(Name,Salary,[Year])

SELECT 'Raj',3000,2008

UNION ALL

SELECT 'Raj',5000,2009

UNION ALL

SELECT 'Raj',15000,2010

UNION ALL

SELECT...

What is spatial index?

Hi Craig Farrell,

We have done all the indexing and query optimization at the best,So thought of asynchronous processing.Could you please help on this?

Hi,

I didn't found any scripts that you have mentioned.It will be helpful if you please elaborate taking our requirement

Hi,

we have stored procedure which process the responses from student once the student submit the test,And this stored procedure consuming time and hence hindering the concurrency.

So thought of moving to...

I Unzipped 7za465.Zip to C:\Utils folder as suggested by you.After that i just went to zip the file manually but it didn't happened.From download i was having 7z465.exe ,I installed...

ya I copied the command and executed in cmd prompt there also i received same error.

And the exe is in C drive only where SQL server resides.

Can u send out...