The following links from MS might be of help...(problems observed if you are using Exchange 2000 or are trying to send open files as attachments via SQL mail)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274330

Hi,

This link might(??) help :

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q296/0/98.ASP&NoWebContent=1

check this link...it has a discussion (and a solution) on something on the same lines...

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=11640&FORUM_ID=8&CAT_ID=1&Topic_Title=hierarchies&Forum_Title=T%2DSQL

This should (hopefully!!) work out for all the consumers...you'll have to alias the outer table so that you can reference it in the sub query...

SELECT MAP.Consumer_ID, MAP.Provider_ID, MAP.Effective_Date AS LastVisit

FROM...

you could use TOP in the select statement of your cursor...

DECLARE CursorName CURSOR FOR

Select Top 13 ......

Hi,

This link

http://www.sql-server-performance.com/stored_procedures.asp

provides some of the general recommendations to optimize stored procedures which might be of help...

and like Frank said - there are many ways to "optimize" stored...

I think GOTO is frowned upon as it makes understanding the code difficult...

However BREAK only breaks out of the innermost WHILE loop so GOTO could be used to break out...

you could also use BREAK

declare @i int

set @i = 0

while @i < 60

begin

set @i = @i + 1

print @i

if @i > 9

begin

Print 'exited while statement'

break

end

end

Is the third argument in the Substring function the length of the text field???...if so this should work :

Substring(Field,3,Datalength(Field))

thanks for that info Jpipes...I'm going to use it for my requirement of getting filenames and dates...this is better than my previous "parsing mechanism"....

Exec master.dbo.xp_cmdshell 'dir d:\MSSQL7 /b'

the '/b' switch should return only the filenames (and subdirectory names) from the directory...

To list only the files

Exec master.dbo.xp_cmdshell 'dir d:\MSSQL7 /b/a-d'

good old DOS commands.......

Hi,

You could use the Convert function to convert the date into the format required...

Convert(Varchar(10),getdate(),111) will convert the date into the yyyy/mm/dd format and you can then use :

SELECT RETUDATE FROM...

Hi Ritch,

I think this is what you need :

Declare @Store Int

SELECT @Store = Sum(Field) from Table

One thing to consider - assuming that Field is of data type int...

How about :

SELECT

isNull(COUNTEDBY,1) as Countedby,

SUM(ISNULL(APPLES,0)),

SUM(ISNULL(ORANGES,0))

FROM #FRUIT

GROUP BY isNull(COUNTEDBY,1)

this seems to be giving the results that you are looking for...I think....

one way would be to use the sp_MSForEachTable stored proc :

exec sp_MSForEachTable 'SELECT * FROM ? where MembId=1234'

this will execute the select statement against all the tables in the...