Thanks Jeff,

I will consider this:

"If you have the new user execute stored procedures as part of the query that creates an attachment, you might want to create a "db_Executor" role...

Hi Jeff,
Thanks for the help. After doing few experiments I managed to fix the issue. The issue wasn't in the mail profile and this is what I have done.

I have...

I changed the query to like this: (@exclude_query_output = 0)

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'TestMailProfile',
@recipients = '<valid_email>',
@subject = 'Email Attachement Check',
@body = 'Sample Body...

There's a workaround for this issue.

1. Close all the SSMS enviorenments.

2. Open the registry editor and locate the key '\HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\Find'.

3. Change the value of 'HitReplaced' to...

Cadavre (2/9/2012)

---

manjuke (2/9/2012)

---

Well you could try something like this..

DECLARE @xml AS XML = (

SELECT @id AS '@id',@name AS '@name',@onclick AS '@onclick',(

SELECT TOP 100 PERCENT A.* FROM(

SELECT '0' AS '@value',...

Well you could try something like this..

DECLARE @xml AS XML = (

SELECT @id AS '@id',@name AS '@name',@onclick AS '@onclick',(

SELECT TOP 100 PERCENT A.* FROM(

SELECT '0' AS '@value', NULL AS...

Hi Paul,

It would have been nicer if you could provide some sample data and the schema of your table. Anyway looking at your select query I created a sample table....

Hi,

You can use the dense_rank to get the desired results. Please check the following sample..

--===== Create Sample Data ======

declare @sample as table(

InvoiceIDint,

ClientIDvarchar(1),

ProviderID varchar(1)

)

insert into @sample (InvoiceID, ClientID, ProviderID)

select 100,'a','e' union

select...

Hi,

Please provide the following information in order to provide a better solution.

1. Does the value which represent the letter is same for the column only ?

2. According to the Sample...

meelan (1/20/2012)

---

I have a query which uses a CASE WHEN to calculate some value. Inside CAS..END, I have used some fields (eg: 'Commission Per' from a joined table which are...

Hi,

This may not be the best way, but you can do something like this :

--Populate Test Data

declare @OrderMissing as table(

KeyNoteint,

Qtyint

)

insert into @OrderMissing (KeyNote, Qty)

select 1234,3 union

select 1235,23 union

select 1783,5

declare @OrderHeaderMissing...

Hi,

This is possible using the SQL MERGE. You can do something like this :

--Test Data

declare @SampleTable as table(

Account varchar(10)

,Organization varchar(20)

,Period varchar(2)

,[Year] int

,Amount money

)

insert into @SampleTable

...

Anyway assuming you have the following table structures I have done 2 samples. One using pivot and another without using pivot.

--Sample Tables

declare @address as table(

id int

,[address] varchar(100)

,postcode int

)

declare @billing as...

Hi,

Will you be able to provide the structures of your source tables ?

Well then as 'Lutz' mentioned, you can do it using the PIVOT. Please see the code below. I took the sample code that Lutz had mentioned in his post.

declare @table1...