You asked almost the same question a couple of weeks ago:

http://www.sqlservercentral.com/Forums/Topic843394-338-1.aspx

Was there a problem with that solution that we can help you with?

BrainDonor.

Would that be because you're not formatting it to either of the formats suggested by Lynn...

Hi Lynn,

I was going to challenge...

This can be caused by the date format in your date control being different from the date format that the database is using. For example today's date can be '20/01/2010'...

He reminds me of one of my kids...

We're happy to help, but need example data and a look at what you've tried already.

For information on how to post sufficient details:http://www.sqlservercentral.com/articles/Best+Practices/61537/

BrainDonor

A dead thread!

Don't you people realise that some of us need this thread - if only as a temporary diversion from the heady excitement that is a working day? Two...

Read this series of articles on indexes:

http://www.sqlservercentral.com/articles/Indexing/68439/

BrainDonor

I recently replaced a Cursor that built a csv string with something along the lines of this:

DECLARE @CSVString VarChar(MAX)

CREATE TABLE #Test(ID int IDENTITY, TestText VarChar(MAX))

INSERT INTO #Test(TestText)

SELECT '1'

UNION

SELECT '2'

UNION...

Hi,

Could you post some sample data, along with the code you've tried so far, so we can help:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

BrainDonor

Edit to use hyperlink.

Hi Jitendra,

There are a couple of errors within this, and no sign of a question.

What is it that you want help with?

BrainDonor.

Have a look at their history - it isn't the first time they've done that.

I don't think some people appreciate the hoops others are prepared to jump through to try...

It's my ball and I'm going home....

This has the smell of homework about it.

What have you tried so far?

BrainDonor.

You were right - AdHocRemoteQueriesEnabled is the option you wanted. To see what the settings are for the various options you can run

SELECT * FROM sys.configurations

ORDER BY name

and you should...