Viewing 15 posts - 481 through 495 (of 621 total)
Jeff Moden (1/3/2008)
Yes... must it be a function or can you use a stored procedure to do the concatenation?
I did not know you could do that. Functions are still...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 4, 2008 at 6:55 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 3, 2008 at 1:06 pm
Kris, search Books Online for "cross-tab reports". The example is exactly what you need to do.
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 28, 2007 at 11:01 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 17, 2007 at 1:52 pm
Mike Levan (12/17/2007)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 17, 2007 at 1:37 pm
I was afraid of that, but thanks for the reply
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 29, 2007 at 7:56 pm
Thank you Steve, that led me right to the suspect view.
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 29, 2007 at 12:41 pm
Greg Snidow (11/15/2007)
Ok, try changing s3.Stage1Id to s1.Stage1Id in the select statement
Sorry, I meant to say SELECT DISTINCT s1.Stage1ID...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 15, 2007 at 11:19 am
Ok, try changing s3.Stage1Id to s1.Stage1Id in the select statement
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 15, 2007 at 9:33 am
Steve, I think this will do what you want.
SELECT
s3.Stage1Id,
s3.ClosedBy,
s1.Contact1Id,
...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 15, 2007 at 6:25 am
Joe Barbian (11/14/2007)
This time I thought I'd check with the experts first.Thanks again,
Joe
Joe
I just want to make one thing perfectly clear. I am not to be included with the...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 14, 2007 at 3:57 pm
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. ...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 14, 2007 at 2:19 pm
ilhuhtin (11/14/2007)
How do you trigger the mail / how do you assign, for example, the To field with Access? I bet the commands are quite similar.
For most of the emails...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 14, 2007 at 11:05 am
karthikeyan (11/14/2007)
Please tell me how to delete when no primary key..
...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 14, 2007 at 9:42 am
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,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 14, 2007 at 5:49 am
Viewing 15 posts - 481 through 495 (of 621 total)