This is awesome. worked great. you made my day Jeff. Always big fan of you.. 🙂

yes Jason. The string always in numerical ascending order. and every string will have exact 5 numbers in production.

wow, i did not thought string_agg can come handy here.Great Jeff.

1. Sorry for ID1 had 6 twice, thats a typo.
2. But Id1=3 was not expected in the output. Though there...

• This reply was modified 4 years, 1 month ago by  Jus.

Worked like a champ. Thanks jeff.

I tried using loops  which I know not a better way. Is there any solution with direct sql query to get required output.

ColdCoffee...You rock..........thats what i was exactly looking for...your code works great after removing the line

AND [YEAR] = (SELECT DISTINCT [YEAR] FROM [tblPeriod] WHERE PERIODID = @intPeriodID)

Thanks for the responses..

sample data..

insert into [dbo].[tblPeriod]

select 2008,'March',17,21

union all

select 2008,'Apr',18,24

union all

select 2008,'May',19,25

union all

select 2008,'Jun',20,22

union all

select 2008,'July',19,28

union all

select 2008,'Aug',17,21

union all

select 2008,'Sep',18,24

union all

select 2008,'Oct',19,25

union all

select 2008,'Nov',20,17

union all

select 2008,'Dec',19,15

union all

select 2008,'Jan',20,16

union all

select...

Try below code..you need to have tally table built in your database to run this..

SET NOCOUNT ON

if object_id('tempdb..#Category') IS NOT NULL DROP TABLE #Category

if object_id('tempdb..#Category1') IS NOT NULL DROP...

GUys:

I have upsized the access 2003 to ADP (upsized the db to SQL Server 2005). application and reports working as expected.

But now, am unable to set security in ADP file...

It Rocks...Cool dude...thanks a lot...

Thats really cool..thanks a lot Nabha..

Bru...by seeing your last name, I guess, you are from Hyd'bad...ami right??

Let me do this time for you...

create TABLE [Department9](

[DepartmentID] [smallint] NOT NULL,

[Name] varchar(1000) NOT NULL

)

create TABLE [EmpDept9](

[DepartmentID] [smallint] NOT NULL,

[empname] varchar(1000) NOT NULL

)

insert into department9...

Check the response from GilaMonster and post the ready to consume DDL and DML scripts....

sorry..not done intentionally..because of slow system response, i would have clicked 3 times and hence 3 replies....is this the problem with this application?