Thanks John,

Will try weitzera's suggestions.

Thanks John.!! For your kind reply.

This problem is not related to just presentation. I wanted to create SP on it, which will work for millions of records. And i m...

Hi buddy,

This error comes because there is problem with your data length.

Whenever you convert data type, please check your max(Len).

Regards,

prashavhad

Please check with following possibilities, I have consider fact and geo tables

1) Cross Join -- It will give you cartesian product of two tables = 1000*5=5000 rows

2) Inner join --It...

Aggregate function error at your subquery.

Remember if you are using group by, you must have all columns in the select clause :-).

You must use DATEADD (datepart , number , date ) function to increment your Date.

See below what i had done.

select getdate()

Select Dateadd(yy,1,getdate())

Create table DateData(EName varchar(20), TDate Datetime)

insert into DateData values('Prashant',getdate())

insert...

While inserting data into a table, you should remove starting and ending brackets between each column data.

Please see below for this.

insert into #Personel values('deneme1','deneme2','deneme3')

insert into #Masa values('Masa1','masa2','masa3')

Cross join results cartesian product of two or more than two tables.

Cross join matches each record from table1 to table2

Eg. if table1 contains 5 records and table2 contains 4 records...

Use Bcp Utility for this,

create your format file without mentioning -t in format file

Thanks & Regards,

Prashant Avhad

You can use Export SSIS tool from Sql-2005 or DTS tool from Sql-2005.

It will surely work to out your table into same data type

Thanks & Regards,

Prashant Avhad