Transact-SQL | Forum profile

So the quantity of a specific line item as a percentage of the total quantity of items sold?  For instance, if you sold:   Order 1 > Item A > 10 Order 2 > Item B > 10 Order 3 > Item C > 10 Order 4 > Item A > 10   Then the result would be: Order 1 > 25% Order 2 > 25% Order 3 > 25% Order 4 > 25%   Or would it be: Order 1 > 50% Order 2 > 25%...

Hi unlikely, Just another reason why you should let us know the version up front, eh? Change sys.triggers for sysobjects and add another bit on the WHERE clause: sysobjects.type = 'TR' George

  de4ever wrote: Issueid is common primary key for the original table so we can user use issueid  in on clause   But issueid is different for the results you are showing.  There is no logical relation. Mangal Pardeshi. http://www.biconsulting.in

Hi, probably SELECT st . StoreName , st . StoreCountry , si . ItemNumberSK , si . ItemName , sum ( si . Qty )/( select SUM ( sii . Qty ) from SALES_ITEM sii where sii . ItemNumberSK = si . ItemNumberSK ) FROM STORE st , ITEM_PURCHASE ip , SALES_ITEM si WHERE st . StoreNumberSK = ip . StoreNumberSK AND ip . ItemNumberSK = si . ItemNumberSK group by st . StoreName , st . StoreCountry , si . ItemNumberSK , si . ItemName  

  please tell me how to join two rows and then find  the result using pivot function...

Try this. The parmater definitions are sent in using the same string.     EXEC sp_executesql @cmd , N '@FromAge int, @ToAge int' , @FromAge , @ToAge   Ken Simmons

In addition to Jonathan's suggestions, you can also search the stored procedure definitions for a specific keyword like ColumnName in all databases:   Code Snippet sp_MSforeachDB ' USE ? SELECT DB=''?'', o.name , c.text FROM sysobjects o INNER JOIN syscomments c ON o.id = c.id WHERE o.Type= ''P'' and c.text LIKE ''%ColumnName%'' '     With PATINDEX instead of LIKE,...

I have found something very useful to play around date and time. it is having all format. Please see the format below.   http://www.mssqltips.com/tip.asp?tip=1145      

  Aaron Alton wrote: So the quantity of a specific line item as a percentage of the total quantity of items sold?  For instance, if you sold:   Order 1 > Item A > 10 Order 2 > Item B > 10 Order 3 > Item C > 10 Order 4 > Item A > 10   Then the result would be: Order 1 > 25% Order 2 > 25% Order 3 > 25% Order 4 > 25%   Or would it be: Order 1 > 50%...

Hi Sankar,   Thanks for helping me out. My problem was resolved. I think the culprit here is not the SP. Actually the developers are trying to insert the data in that table for unit testing( not through SP) and that time table is getting locked. But yesterday i was able to kill that transaction and release all the locks. So as of now my problem seems to be resolved.   But i'm really curious to know why this happens when we try to do...