Thanks Luis, Appreciated.

Hi Jeff,

I gone through each step to understand this hygienic code. Really leaned new formula's. I know about tally table concept even you advised me to learn about this in...

Below my working example,

DECLARE @users TABLE (

UserID INT

,NAME VARCHAR(50)

);

INSERT INTO @users

SELECT 1

,'Member1'

UNION ALL

SELECT 2

,'Member2'

UNION ALL

SELECT 3

,'Member3'

UNION ALL

SELECT 4

,'Member4'

UNION ALL

SELECT 5

,'Member5'

UNION ALL

SELECT 6

,'Member6';

DECLARE @cols AS NVARCHAR(MAX),

@query ...

Hi Lyn,

this is what i hav etried, but getting wrong reult

DECLARE @users TABLE(UserID int, Name varchar(50))

insert into @Users

select 1,'Member1' union all

select 2,'Member2' union all

select 3,'Member3' union all

select 4,'Member4' union all

select...

Hi Jee,

Thanks for your reply and your understanding is correct. it's round robin basis.

i ran your query and sorry it gives wrong result, if i have my start date as...

if still not clear, below are the sample with rows/columns

2/2/2015 - 2/8/2015 member1

2/9/2015 - 2/15/2015 member2

2/16/2015 - 2/22/2015 member3

2/23/2015-3/01/2015 member4

3/02/2015 - 3/08/2015 member5

3/09/2015 - 3/15/2015 member6

3/16/2015 - 3/22/2015 member1

3/23/2015 - 3/29/2015 member2

.

.

.

.

.

also i need to bring the data...

Hi Lynn,

thanks for your reply and basically in am trying to build a on call maintenance calender. the start date of the call should be as input to the ...

Hi Jeff,

I totally agree your logic and will follow that. yes of course, knowledge can only be developed when we try.

you are great mentor. thank you.

Hi Jeff,

I apologize for extending the thread and your time. I did try to browse through articles before i post in this forum. even i tried some sample as...

Hi Jeff,

One final question about exception. In my sample logic i am suing try catch to get the exception and transaction to rollback if any exception found. Also...

Hi Jeff,

Thank you so much for mentoring me. After reading changes you made on my sample and after i executed the procedure against the test data, it executed in 4...

Hi jeff,

Here how i generated the record

;;WITH x AS

(

SELECT TOP (2300) [object_id] FROM sys.all_objects

)

SELECT d.*

INTO Test_Balance

FROM (

...

Hi Jeff,

Finally i am able to create 500000 mock records as test data and i did test. it took 20 seconds. hope this is quick result. Any comments or suggestions...

Got it. yes it's happening. we have every one hour backup.

Is it possible to create dummy test data to check this scenario?

SELECT d.*

INTO #Users

FROM...

Hi Jeff,

thanks for the reply,

Also it is possible to generate 60000 + dynamic data for testing with the schema i provided? any help please

What is point in time database...