I know this wasn't your main issue, but it is true that OPENQUERY is still limited to a query string that will fit on one page ... so varchar(8000).

Now, I'm...

You wouldn't want the quirky update method for this because it's not needed and therefore the performance hit would be unwarranted. It's a fairly simple join, but there are...

You're already pulling your weeks from a table "time t". Why not just add a fiscalYear column to that table and group on it and/or just add where t.fiscalYear...

brian.cook (7/27/2010)

---

So if I add a subquery to the Select statement that has this;

SELECT TOP 1 [ProjectID]

FROM [BE].[dbo].[2010Projects]

ORDER BY [ProjectID] DESC

That should give me the latest...

Yes, the problem is the lack of single quotes around the dates in the string.

And yes, it is important enough that it's worth repeating: with this methodology you're basically asking...

I made a slight change ... we need something specific to order our items by. Now it may be that you want them in order of the Code value,...

I'm pretty sure there is a more elegant way to code this, but this will do what you're asking:

declare @t_tally table (N int) --hopefully you have a real tally table...

Yes, you can just take that out if you don't need it.

malleswarareddy_m (7/22/2010)

---

I know that but some one of friend told that its take more time to execute.that why i posted if there is another way which executing faster than using...

I saw this same situation you describe recently. When hard coding the date values I got a seek and everything was fine. When I put the same date...

If you're doing a lot of cleanup before you can import, I would suggest that you take a look at SSIS. It's a very handy tool with a lot...

Well, it depends! That would obviously be a problem...

Wayne!

Just for future reference, it helps if you put your data in a usable format like this:

CREATE TABLE #Temp

(

[CP Code] varchar(50),

[Date] date,

[Total Pageviews] bigint,

[Total Volume in MB] decimal(16,4),

)

INSERT INTO #Temp

SELECT...

SELECT sno,

id,

product,

ROW_NUMBER() OVER(PARTITION BY id ORDER BY sno)

FROM yourTable

ORDER BY sno