Hi All,

Been off for a week.......

Is this thread still live?

Have fun

Hi Ann,

Could you please post the CAST and CONVERT statements that are actually giving you the error.

Have fun

Hi Sansan,

A little more information would be required before most people in here would cast an opinion.

Databases on same servers? Tables and structures, information required from each, key values,...

My vote goes with Paul, this kind of task is what DTS thrives on.

Have fun

Hi Remi,

This has been great reading. I didn't execute the first code snippet as you said (though I did paste it into QA, seperate and comment it all so I could...

Hi Farrel,

Still working with the dynamic stuff then, good man.

A bit late in this thread I know but......

It's always well worth just doing a PRINT LEN(@DodgyVariable) just to double check...

Hi All,

Is this not a silly date comparison issue?

Have you tried CASTing or CONVERTing both dates in your WHERE clause?

Just a thought, haven't tried it yet.....

Have fun

Hi,

Have you checked the settings of the linked server in Enterprise Manager under Security -> Linked Servers.

If any of the settings in here goes out, it affects all Linked...

Hi,

I am about 99.9% certain it isn't possible.

Could you give us an idea of the problem you are trying to solve here.

You need to do a lot of research...

Hi Guys,

As a simple solution, would it not have been easier to just use a DTS package to pump the data into excel - sorting through it in small bits on...

Have you not looked at using DTS for this task? Seems like it's exactly what DTS was made for.......

Have Fun

Hi Gihan,

If you find you have no other options than to step through using a loop and nested loops. You are better off not using cursors.

Example of a cursorless...

May be of some use:-

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarsqlsg/html/msdn_interntl.asp

Excellent - here to help matey

Have fun

Hi Mark,

Your Dynamic SQL looks fine in the main.

Only problem I can see is:-

It handles @iProvinceID > 0 AND @iPatientFilter >= 0 perfectly.

Any other result will cause it to...