Try this purloined bit of SQL and see what your numbers look like.

WITH Waits AS

(SELECT wait_type, wait_time_ms / 1000. AS wait_time_s,

100. * wait_time_ms / SUM(wait_time_ms) OVER() AS pct,

ROW_NUMBER() OVER(ORDER...

Answer to original poster is yes, LCK_M_RIn_NL probably is exactly that.

Sadly the procedure is broken.

a) It does not correctly respect the schema specified in the call when not dbo, thus crashing

b) It does not respect computed columns in the partitioned...

Thanks, adding read right to SQLServerMSASUser$computer_name$instance_name solved the problem!

Thanks. This is the solution.

Thanks very much for this post. This solves the problem exactly.

Deepak.Sharma507 (5/15/2012)

---

GOT IT :hehe: 😎 :w00t: 😛 😀 🙂

Got the tip from this link

http://blog.codefluententities.com/2011/01/20/microsoft-access-database-engine-2010-redistributable/

Installed the "Microsoft Access Database...

Hi did beyonder422 did you ever get a solution to this problem. I am having the exact same problem and can't find any information about it on Google.

Thanks

with this query am getting months only for a single year - 2012 if user selects from

march to dec

i would get

march - 3

april-4

........

till december -...

yessss! for that i have pasted my query above in that am gettiing 2 result set but i dont know how to bind them 2 gther now got it

sorry for everything

SEE THE HAVE A QUERY LIKE

Name....Block.......January(Hours)

Jhon.....ITEBI.......44

I WANT to add more columns now based on this hours called jan(%centage)

Name...Block.... Januar(Hours) jan(%perce)

JhonY...TEBI.......44 ........................24

the formula for...

sorry for everything

SEE THE HAVE A QUERY LIKE

Name Block Januar(Hours)

Ksh IT ...

sry how to remove duplicate posts ?

Am creating a query such that

name block Janurary Feburary

ksh IT 24 ...

but am getting

ISNULL([2012-01-01],0) +

ISNULL([2012-01-01],0) +

ISNULL([2012-01-01],0) +

ISNULL([2012-01-01],0) +

ISNULL([2012-01-01],0) +

MY SP IS

select @col = COALESCE(@col + ',','')+ QUOTENAME(Work_Date)

from form_Details WHERE Work_Date BETWEEN ''+CONVERT(nvarchar(30),@start_Date , 110)...

Used the stored procedure to decrypt another stored procedure of mine. It dropped it.

Caveat emptor.