Buddy, can you be more specific with your requirement?? i mean, why do u wnat to compare the InvoiceDate and StartDate and then again using the same combination to filter...

Hey Gerald, as promised , here is mini-version of the dynamic update query.. It is just a starter, you will have to build up on the start and customize it...

Lynn Pettis (4/26/2010)

---

Looks just as easy with a CTE:

with GroupData as (

SELECT

Key1,

MAX(VAL1) as MAX1,

SUM(VAL2) as SUM2

FROM

...

Happy to help you , though the help was very little 🙂

George i already have coded a piece of dynamic update stored procedure.. now that am at home, i will give u the code tomorrow, so spare another 12 hrs for...

Your version of SQL Server is 2005 or 2000? You have posted your query in SQL 2005 section but post says "2k"??

That being said, in 2005 you have some thing...

Happy to have helped you buddy 🙂

Hi Buddy,how about you going through this following article and helping us help you?? 🙂

CLICK HERE FOR FORUM POSTING ETIQUETTES - JEFF MODEN[/url]

When u do so, i am sure a...

Then u can create a SQL-CLR procedure, use it inside the TRIGGER definition... inside the CLR, write some code that will relay the messages through LAN..

I can only get you...

Developer, MSDN link for sp_send_dbmail says that it is possible to send one single mail to multiple users , as in [ , [ @recipients = ] 'recipients [ ;...

This can be done in 2 ways (as far as i know)

Solution 1:

1. Use OPENROWSET to first read-out all the data from text log file and use it as a...

You will have to make use of Insert Triggers.. to know more about trigger, go through the following like

TRIGGERS - MSDN - Click Here

MOre specifically , look...

Ummmm.. I dont think we can acheive this without CTE or Subquery...

Also i have another gift for you 😛

I slightly altered the pivot values in the query and i have got another well looking output.. This may be of some help...

Hi Gerald... I would suggest you to look thro the first link in the signature line of Lutz.. that will make the volunteers here address your request easily and give...