Raul,

Would not it be easier just to schedule Crystal Reports? If you don't have email functionality for Crystal then output files as PDF and write a short VBscript that will...

I am a big fan of the Ron Soukup's and Kalen Delaney's book "Inside Microsoft SQL Server 7' (there are later versions of the book out there). I already quoted...

Fred,

SQL Server function Right() does account for the trailing blanks. That is how I was able to catch my blank in the string for the first place.

 - Excel function...

Hi,

I ran both statements with Profiler open. Both the local server and the linked server was the same SQL Server under different names.

In the first example I ran your first...

You may use VBA with ADO (in a module) and create connection object to your SQL Server database and then use CommandType = Text for your Command object

If you need to do it only once or if you don't have performance issues I would use  a cursor

Hi,

depends what you want.

1. If you want to create HTML code from the query results then you have to do something like that. Example is for Pubs database Employee...

Same with address, just tested it on my table:

select address1+address2+state+city+zip

from mytable

group by address1+address2+state+city+zip having count(username)>1)

Or to select all fields for these people:

select * from mytable where address1+address2+state+city+zip IN

(select address1+address2+state+city+zip

from mytable

group by...

I would concatenate firstname and last name in the query to get just one field for grouping, group on it and do having count user name >1 like PW suggested....

There are table-valued functions that combine advantages of SPs and views. They accept parameters and you can select from them.

Theoretically you can. Practically (???) it depends. I had a case just yesterday when I was called after someone who had MSDE working and installed SQL Server 2000 client tools...

Yes, convert works good!

Just yesterday I had to do someting that required date formats not covered by Convert styles and I tried to use Datepart. But because Datepart returns integer...

This is the first of your 2 choices: huge implicit or explicit transactions or DTS packages or bulk insert or something like that. Simple Recovery Model is what you want...

PATINDEX accepts the literal string even with wild characters where CHARINDEX accepts  expressions for the pattern. I would not define expressions as "explicit patterns"

Except for the technical restriction there are business process restrictions, in this case a license agreement, see EULA (end user license agreement) for the Developer Edition.