You could probably do the whole thing without any parameters or variables (or maybe one variable for the sum.)

Agree with Gazareth, best to start by simplifying the query.

It looks like you take everything in as a parameter, and then overwrite the value of each parameter...am I missing a...

It's kind of hard to follow what's going on precisely...because of the different schemas, the language (former yugoslavian something!), and all the "noise" i.e. code not related to the actual...

Try changing

select csa.* ,ROW_NUMBER() over (Partition BY csa.customer_number order by

csa.erp_id,csa.ANNUAL_CONTRACT_PRICE desc) as Rank

to

select csa.* ,ROW_NUMBER() over (Partition BY csa.customer_number order by

csa.ANNUAL_CONTRACT_PRICE, csa.erp_id desc) as Rank

So that if...

I think this is because your trying to execute the create table sql from Reporting Services (and not in Management Studio.) Hence the connection type is not the same,...

I agree that the problem's going to be connected to your row_number() and the fact that the field used in the Order by section of the OVER clause i.e. ANNUAL_CONTRACT_PRICE...

already given.....now all you've got to do is read them.

I'm reading between the lines.

----------

The 3rd party has given you an .xsd and asked you to produce an xml extract for them which corresponds to their format.

You suppose that you...

Again, it depends on what you want to do in your transformation.

If you include a reference to your stylesheet (where to find it) in your xml document, you can use...

Not sure if you want guidance on writing an xsl stylesheet or on applying the transformation.

The two articles below should give you some info on both of the above -...

This isn't a stylesheet; it's an xsd schema. A stylesheet would be used to transform your xml (once you have it!) into a different format (xml / html /text...

Take a look at the following article "Linking to the previous row", and perhaps more importantly the subsequent discussion which compares CTE with alternatives for this type of problem.

http://www.sqlservercentral.com/articles/T-SQL/62159/

Regards,

David McKinney.

I agree with the poster in this example. A left join in the other direction might make some sense, but B lj A makes no sense given the direction...

sri.chithu.selva (11/8/2012)

---

I have two dates , thats the week start date and end date . And i needs to know what is the week no for current between those dates...

EITHER the table already exists (it's called Archives),...