sounds to me that this would a question for those who made this database. It's hard to ascertain what capabilities might have been built into a tool like that.

One...

BTW a question I have asked several times with no replies as yet - how do you ensure that the output of a query is now and for ever correct...

The thing that bugs me here is that BOL states that that very format SHOULD work. It's style #127. Is BOL just lying or is there something escaping...

Assuming you're on 2000 - unfortunately Andras' answer will NOT work (XML PATH is a 2005 feature...)

Also - since you're touching something in the clustered index - if you plan on doing a "walking update", do it from the Back to the front. Meaning -walk...

Considering the total lack of detail of info given, I guess the answer is - "yes - under the right conditions - that certainly is possible". You should probably...

Sure - using the "old-style" pivotting syntax:

Select user, datepart(yyyy,datein) as Yr,

sum(case when datepart(mm,datein) =1 then 1 else 0 end) as Jan,...

I'd have to agree that you'd probably be better off just telling it to recompile each time. In a case like this, unless your usage is very biased towards...

Andrew (2/25/2008)

Hence my simple poll. BTW is it possible to complete my multi-choice poll and where can I see the results? !

It is now 20:45 in the UK and time...

All right. Starting with the basics:

- does IIS show that those directories are there?

- did you run through the Reporting Service Configuration tool (and set up all...

I'm not sure how you're getting here - but the results of the poll are being displayed graphically above the posts (in IE at least.) Currently 18 different folks...

(Not disagreeing with any ofthe above posts - just modulating the answer)

Just keep in mind that sorting at the client should be restricted to SMALL datasets, especially if the sorting...

MySchif -

a few things:

- your error must be a typo. It should be @PrevGrpBal and not @PreGrpBal (notice that there's a letter missing).

- you're correct about...

Again - Andrew - what would you advocate as "the correct way" for handling the age issue from above? What do you see as the correct answer? How...

From what I understand - unless you specifically SET ANSI_NULLS during a given session (which could include in the odbc/ole settings to start up said connection), then the database setting...