I have done this myself.

Thanks for reading ....

select

left(substring(QueryString, PATINDEX('%src=%',querystring)+ 4, len(queryString) ),PATINDEX('%&%',substring(QueryString, PATINDEX('%src=%',querystring)+ 4, len(queryString) ))-1) myDesiredValue

from MyTable

Please discard this post as i made the solution, I was making wrong calculation and due to which I was stuck in the query results, it all is about the...

If I separately query for each results it is something like below:

Declare @BillingFrom datetime, @BillingTo datetime

set @BillingFrom = '12-dec-2009 3:45 PM'

set @BillingTo = '25-Feb-2011 4:45 PM'

-- EXEC uspMonthlyBilling @BillingFrom='12-dec-2009...

The fix is giving wrong output as it is same as i had worked on it and sent you the query. Also there was some data issue in Duration Col...

I'm sorry as I was so busy, so I made post like this: Here is the script

-- create sample table of users

CREATE TABLE [dbo].[UserTracking](

...

Thanks, this worked - Great.

With continuation, I have one another table "UserTracking" in which there is duration of users something like below:

Table: UserTracking

Columns: startDateTime, endDateTime, Duration, UserId

The duration col. contains...

Yes i have mentioned that i have used your latest script. I have tested this on SQL Server 2008 EE.

Shamshad Ali.

Hello,

The script you make with efforts are highly appreciated, but the latest script I checked for my case is not perfect and have bugs. All, always verify your script...

NO one is looking into this ?

Shamshad Ali

I have successfully got it working by changing the parameter = ON on both - Thanks, that worked.

No more locks on 100 users, will start testing on more users today.

Shamshad...

My friend, I used following script to create Three non-clustered indexes:

CREATE NONCLUSTERED INDEX [IX_ProgramTracking_ProgramId] ON [dbo].[ProgramTracking]

(

[ProgramId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY...

Thanks for your comments back again. I respect all who are taking interest and helping me out. I really need to solve this issue.

Shamshad Ali.

I am talking about "WITH (TABLOCKX)" - These are called HINT -

Shamshad Ali.

I don't think that HINT will solve my problem, its locking at the first insert statement <Master table>, when it returns the ID then it will be possible to insert...

Here the SP code

Alter PROCEDURE [dbo].[SaveTrackingRecord]

(

@XmlDocument xml, ...