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...

I would use Dynamic Update query in this context... But we must also write that dynamic query to neglect SQL-Injections... But when the number of columns to be updated is...

This would work for u!

;WITH CTE (Key1,MAX1,SUM2)

AS

( SELECT Key1, MAX(VAL1) as MAX1, SUM(VAL2) as SUM2 FROM @TableVar

GROUP BY KEY1

)

SELECT TAB.Key1 , TAB.VAL1 MAX1 , CTE.SUM2, TAB.SOMEVALUE

FROM CTE CTE

JOIN @TableVar...

Spot On, John..

And Nabha's...