Hi

I'm using this data for reporting purpose and in my final report I only need few columns. I was using Excel before to do that and now I'm just starting...

Hi

Thanks Jeff. Ill try to do it this way.

@steve-2 ...Actually I have a lot of data clean up to do. So if I import my data into...

Hi

This is how my Table Looks like with 3 weeks of data on daily basis for two CP Codes:

I have data for 30 such Codes.

CP CodeDateTotal Pageviews

510142010-06-272623221

510142010-06-281985718

510142010-06-291815712

510142010-06-302126104

510142010-07-011702672

510142010-07-021666468

510142010-07-032019123

510142010-07-041783373

510142010-07-051890672

510142010-07-062424314

510142010-07-072197743

510142010-07-082097884

510142010-07-092029226

510142010-07-101989296

510142010-07-111833109

510142010-07-122398424

510142010-07-132365550

510142010-07-141810926

510142010-07-152483211

510142010-07-162327007

510142010-07-171758154

530372010-06-276059

530372010-06-286310

530372010-06-296394

530372010-06-304627

530372010-07-013402

530372010-07-023115

530372010-07-033032

530372010-07-042995

530372010-07-053122

530372010-07-073040

530372010-07-083638

530372010-07-093767

530372010-07-103745

530372010-07-113576

530372010-07-123860

530372010-07-133123

530372010-07-143458

530372010-07-153516

530372010-07-163233

530372010-07-173176

After converting this data...

I get data daily for same code, so its repeating and I have 30 such codes which means that I have 30 codes with same date. So no Column has...

Hi

When I Run this query As:

CREATE VIEW WeeklyData

AS

WITH CTE AS

(

select [CP Code],

StartDate = DateAdd(day, -DatePart(weekday, [Date])+1, [Date]),

...

Hi

First of all Thankyou very much guys for ur help. Looks like its working.

Actually I'm importing data from a CSV file with BULK INSERT and the problem is that the...

I'm posting new question regarding this.

Hi

Yes, I don't have any column with unique values. But my report works. So is it safe to ignore this warning?

Thanks

Ill try to be more clear in my future posts. Still Learning .............

Thank you all for ur help.

Thankyou very much guys ..... got it to work ..... You all were a great help.

Hi

Thankyou very much.

Hi

1. Its "SQL_Latin1_General_CP1_CI_AS" and not "SQL Lat..." . I just cut it short while posting.

2. The 35th column is the IDENTITY Column that I'm trying to ignore.Can you give me...

Hi,

My data file does not have IDENTITY Column. I created IDENTITY Column in a table to use it as a primary key. So now when I want to import data...

Thank You Very Much

My Table has about 25 Columns. Its originally a csv file, but I preformat it and save it as tab delimited text file. Then I use BULK INSERT to import...