Jeff Moden (12/29/2015)

---

I consider that to be a major failure on the part of Microsoft. I'll never understand why...

Your client may be limiting the number of characters returned. It may limit either the total returned or the amount returned per column. For instance, SSMS limits output...

Just...

titsiros (12/26/2015)

---

The reason why I am asking for such a tool is because I m sure combining client databases of the same schema must be somewhat of a common task...

I hope you have some references to back this up. To the best of my knowledge,...

Just as an FYI, the AUTO and RAW options for XML give you very little flexibility. If you need your XML in a specific format, you are usually best...

You really should add a PARTITION BY clause to the query unless your database is limited to exactly one player. Once you have more than one player, all of your...

stevennjuki (12/22/2015)

---

Okay here is an example

The column cl_a has values (1,2,3,4,5,6)

And for simplicity let's say the total rows to be fetched when computing the sums is only 3 and not...

ChrisM@Work (12/22/2015)

---

Something along these lines should do the trick, however I'd recommend you don't do it. If the number you are storing with the date of the visit is of...

Perhaps this is too obvious, but does removing "FETCH NEXT 10 ROWS ONLY" give you the results that you want?

Drew

I'm guessing that the actual issue is that he was inadvertently using integer division, since COUNT returns an integer.

Drew

It looks like you're trying to recreate the windowed functions that already exist in T-SQL. Try the following instead:

SELECT STDEVP(basis) OVER(ORDER BY basis ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT...

Unfortunately that doesn't fit the format that we both posted a link to. In fact, I'm beginning to think that this is homework, because you have used the number...

You don't say whether the items are in a separate table. (They probably should be, but that doesn't mean that they are.) It would help if you followed Forum...

drooten (12/3/2015)

---

Excellent suggestion Mike01!

After all, testing with a date such as 01/01/2015 is useless if you want to be...