Jonas,

Looks like we where both typing at the same time.......

Have fun

Jonas,

You are actually getting 2 messages there, one generated by Sequel Server and your own printed immediately afterwards.

Working in Query Analyser, I dont think there is any way of turning...

Hi Jonas, David,

I don't see why it isnt working either but one easy workaround would be to do some form of a count within the dynamic SQL and return both:-

Execute sp_executesql...

Helen,

There was definatley no intention to insult or offend. It was just Friday and wind down.....

Frank, David - I think it must be me

Have...

Nice one Frank,

I will use that one on my kids.......

Have a good weekend.

Best Regards

Hi,

Looks like you have unicode data that you are passing into a binary field. Using an explicit CAST or CONVERT should cure the problem.

Have fun.

Hi Gents,

And its not even a Dynamic SQL question.......

Hi Helen,

Does a straight WHERE clause not fulfill your requirements.

SELECT PK, StartDate FROM DateTest

WHERE StartDate > CAST('01/05/2004' as datetime)

Have fun

Hi Rachel,

Sorry its been a while since you posted....

Came across this whilst looking for something completely different and just thought of your post.

http://www.sqlservercentral.com/scripts/contributions/611.asp

Hope it helps.

Have fun

Hi Again,

Seeing i'd never used CONTAINS before, thought I would set up a table and have a play with it.

I found it easier to build the string seperately, and just...

Hi Harry,

If what youv'e posted is exactly the same as your query, youv'e just missed a couple of quotes:-

SELECT *

FROM Customers

WHERE CONTAINS(*, '"@CustVar + *"')

GO

Yep,

If sp_executesql would accept the table variable as a parameter, you would be out the tunnel.

Unfortunately it only accepts parameters that are Unicode or can be explicitly converted to...

Hi,

Lam is right, you need to set @CurrentRow to its initial value immediately prior to the WHILE loop and then set it's next value as the last thing you do...

Hi Harry,

Used very little .Net but if this was straight VB6 you seem to have got carried away with the double quotes.....

Dim strSQL As String

Dim strInput As String

strInput = "Roger"

strSQL...