take a look at the function DATEDIFF in BOL or Google, it will get the difference between two datetime fields which you can then say is the amount of time...

tt-615680 (3/26/2012)

---

Thank you for your reply!

The report result should look like the following:

City ...

and far away

logshipping monitor node? other than that i would put it down to a rename of SQL and the rename hasnt taken effect properly

if the primary instance is BOM-TEST, so I am guessing the the other name is the secondary node where you are shipping the logs to

SQL_Helper (3/26/2012)

---

Hi;

I have a active passive cluster (2 node)

Now I want to create a seprate active/active cluster (2 node)

Appreciate if anyone help me to resolve my following query

1 - how...

what if you wrap the whole expression in ()

other than that, would need to see the data to figure out whats happening

whats the definition of the bulk insert task and can you provide a sample of the excel file that needs to be imported?

is that the exact text which is in the expression? if it is your missing a )

common cause is that the agent hasnt started

thats where you need the loop so that it send the email 1 by 1

DECLARE @Name NVARCHAR(100), @Email NVARCHAR(100), @Message NVARCHAR(MAX), @It INT, @Num INT

SELECT @It = COUNT(*) FROM todayBday

SET...

only problem would be the text as you have sun's you will need to contatinate in a char(39) to avoid using ' and terminating the string

sun'+char(39)+'s

and as always...

its the steps you need to take to get the task done.

first point of call would be to google sp_send_dbmail and see what parameters it needs to work, then google...

you will need to build some kind of loop, (while loop, cursor) then pass in the email and other data into parameters which are passed into sp_send_dbmail

pesudo code would be...

Jerry came up with the quickest soution, ask the other side if it is possible in their citrix environment to mount local machine drives on connection to citrix, if not...