I did not know you could do that. Functions are still...

Ok, I think I don't need the xp_cmdshell thing to make a text file(would still like to know how to do, though) I figured out that I can indeed...

Kris, search Books Online for "cross-tab reports". The example is exactly what you need to do.

Greg

I am not sure if the express edition has it, but in Enterprize Manager, there is a button on the tool bar called 'Save change script', that looks like a...

Mike Levan (12/17/2007)

---

yeah my Fromdate is a varchar as i told you and now i tried doing cast(fromdate as datetime) i get hte result set ok but with an error...

I was afraid of that, but thanks for the reply

Greg

Thank you Steve, that led me right to the suspect view.

Greg

Sorry, I meant to say SELECT DISTINCT s1.Stage1ID...

Ok, try changing s3.Stage1Id to s1.Stage1Id in the select statement

Steve, I think this will do what you want.

SELECT

s3.Stage1Id,

s3.ClosedBy,

s1.Contact1Id,

...

Joe

I just want to make one thing perfectly clear. I am not to be included with the...

Thats pretty slick Lowell. I did not know about REVERSE. I also got

SELECT SUBSTRING(@filename,1,LEN(@filename)-(CHARINDEX('\',REVERSE(@filename))-1)) AS Path

to work for path. I guess you learn something new everyday. ...

For most of the emails...

karthikeyan (11/14/2007)

---

Hi

Please tell me how to delete when no primary key..

...

I don't know about ASP, but with Access I can use VB to enter my parameters and execute my mail procedure from a form. I use one called send_cdosysmail,...