Thank you

J

Does anyone who finds a SQL Server Bug get a prize lol, seriously though how do you report this to Microsoft ?

J

This is really odd.

I was doing the SQL in the view creator, and putting in the code you guys supplied resulted in the amounts without any decimal places, not displaying...

Hi,

Sorry but that did not work.

We have some amounts without decimal places, and those have not been given them. I have tried both of the guys examples, and both fail....

Thanks Chaps

J

Thanks Ian

J

Thanks for both of help, it now works.

J

Thanks,

I obviously put on my Homer Simpson head on this morning.

J

Hello,

In my opinion option 1 is a bit complex, I think that you have to program Outlook to attach the file.

Option 2 is easy but if you have more users...

I think the term 'DUH' comes to mind, sorry for wasting your time, and thanks.

J

Thanks Jonathan, thats what I thought

... as well as if that doesn't work an IN / NOT in command.

i.e for the first query that returns all thats linked, slap around it a NOT IN (Select...).

J

...

Dear Paul,

Thank you, that works brilliantly, my solution took about 100X the time

J

Edited by - JulieW on 10/16/2003 04:07:17 AM

Hello,

If you are writing to a text file based upon a SP, why not use DTS, as that can write to a text file automatically.

Incidently if your writing all of...

Hello,

My apologies I meant to put

1 Smith Peter

2 Smith Mary

3 Smith Tony

4 Smith Heather

7 Jones Matt

8 Jones George

9...