is it a system generated number ? or enter by users

u mean SP calling itself ?

you can do this in t-sql using Format function.

Declare @tbl table ( id int, assignment decimal(11,8))

insert into @tbl

select 1, 10.00 union all

select 1, 8.55 union all

select 1, 0.55

select id,...

When you fill the FACT Table, how you are making Source,

Like a T_SQL staging table joining with dimensions to get the dimension id.

or u r using Lookups? because there...

are you using SSIS or T-SQL to load the dimension/Fact table?

and did you tried to disable your index before loading data ?

its look like a cross tab report to me, you can do it with 2 ways

1) create a cross tab report, doing so you can have 'N' number of...

+1000 :hehe:

feroz_tt (4/16/2014)

---

Hi All,

I'm getting some problem here

;with Numbers (Number) as

(select row_number() over (order by object_id)

from sys.all_objects)

select dateadd(month, number, '2014-09-01')

from Numbers

where number <= datediff(month, '2014-09-01', '2016-03-31')

Low no of months.

Select datediff(month,...

i have tested this script before sharing. It should return 1 row.

Following is the result set

ID ...

Changed the column Name from 'maturnity' to 'maturity'.

Declare @Table1 table

(

ID int

, Age int

, gender varchar(10)

)

Declare @Table2 table

(

ID int

, maturity varchar(10)

, gender varchar(10)

)

insert into @Table1 (ID, Age, gender)

select 1,...

ashalatha.cse76 (4/16/2014)

---

it is correct but while getting the data from data base according to the id from the first table if the age is less than 18 we should get...

Ok, as per your answer you donot need...

i also cant understand what u r saying, still i tried the following:

Declare @Table1 table

(

ID int

, Age int

, gender varchar(10)

)

Declare @Table2 table

(

ID int

,...

you should read the following

How to post data/code on a forum to get the best help[/url]

Give your question a chance of being answered correctly.

It can be done in dynamic sql but 1st i need to know, is there any limit of there will always be Price1, Price2 & Price3 etc columns, or you...