Hi

Solved.

Thanks.

Hi

I Modified the Query as :

DECLARE @StartDate DATETIME

DECLARE @EndDate DATETIME

SET @StartDate = '2010-06-27' ...

Hi

Any Help on this Topic Guys.?

Thanks

Hi

Yes, I still need help with this.

Thanks

Hi

Yes I did. But I don't have so much experience in SQL. Also I'm working in weeks. I tried to modify the query but could not get it to work.

Thanks

Hi

I don't want to write a query for every week. I want that the query should recogonise any week like say within a year(or the date range specified).

I just want...

Hi,

Thankyou guys, great help.

@celko .... I can't BULK INSERT from a CSV file into the table if I use the right datatypes. So I have to do all...

Hi

Divyanth,Can you update my query with what you are saying ?

Thanks

Hi

Yes,working with CSV files is really hard. Lot of manual formating has to be done.

SELECT CAST ('6.68E+07' AS FLOAT)

Do I have to do this for every such value? I have...

Hi

Below is My Table:

CREATE TABLE DSA

(

[CP Code] char(5),

[Date] datetime,

[Total Pageviews] int

)

INSERT INTO DSA

SELECT '51014','Jun 27 2010 12:00AM','2623221', UNION ALL

SELECT '51014','Jun 28 2010 12:00AM','1985718', UNION ALL

SELECT '51014','Jun 29 2010 12:00AM','1815712', UNION...

Hi

Thanks Jeff. Ill post it in usable form.:-)

Thank you very much.

Hi

I want to define a date range so that the query automatically picks up weeks from the table and convert then into columns. And for total number of weeks, it...

Hi

I just add new rows to the table.

Thyanks

Hi

Thankyou very much guys.

@torpkev .... I'm importing data from unformated flat file. If I use correct datatypes in my Table, I'm not able to import data which is...