You are the only one who can tell us which is correct. We can't see your data and you really haven't told us what the expected results should look like.

You...

In some cases they give me same result, in some cases, different number. That's why I don't understand and...

Thank you. Of the two queries, which returns the correct result?

Thanks to every reply

Thanks to all replies, I will come back once I am out of some other issues

Thanks, never used pivot before, can you help?

Thanks.

Thank you very much

I am not grouping on the wrong column, each...

mister.magoo (1/16/2015)

---

halifaxdal (1/16/2015)

---

Hello, I have a script to be used to backup a specific table in a weekly basis, here is the approach what I take, if you have a...

Lowell (1/16/2015)

---

to use "be made with the logins security context", the user must be a user on the domain.

if the user was a SQL user, an anonymous connection is made,...

Jeff Moden (1/16/2015)

---

halifaxdal (1/16/2015)

---

no way i know of to ignore errors, you have to explicitly use LEFT functions in the SELECT or something to work around this issue.

based on your...

Lowell (1/16/2015)

---

halifaxdal (1/16/2015)

---

no way i know of to ignore errors, you have to explicitly use LEFT functions in the SELECT or something to work around this issue.

based on your table,...

maybe this is not a good way to back up a specific table.

can anyone share their experience on back up a specific table in a weekly basis (scheduled in a...

no way i know of to ignore errors, you have to explicitly use LEFT functions in the SELECT or something to work around this issue.

based on your table, only columns...