It looks like a simple pivot/crosstab. Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]

Drew

Your XML is incomplete.

I think you have the wrong scope for your CASE/SUM statement. You have your SUM inside your CASE when you probably want your CASE inside your...

Definitely use a VCS. We're using TortoiseSVN.

Drew

Jack Corbett (12/13/2016)

---

Hey, long-time no hear from.

Any chance you could normalize the structure so the Yes/No columns are in a separate or separate table(s). Maybe...

Does any else think that this response borders on being unethical? http://www.sqlservercentral.com/Forums/FindPost1842475.aspx It sounds like she wants to use this approach just to avoid due diligence.

Drew

Part of the reason that bits were introduced was because of the complexity of using bitfields and bitwise computations. You're already seeing some of the issues, in that you...

SQLUSERMAN (12/10/2016)

---

Suppose I want to find customers in the customers table who are not in the US or the UK.

To me the query for the above requirements would be as...

paulo.margarido (12/12/2016)

---

Or ... replace

by

declare @fromDate date,...

You're not excluding the records that you've already processed, so you're processing them over and over again. Try adding the line

WHERE a.load_id <> q.load_id

Drew

padmakumark26 (12/8/2016)

---

We are combining two db into one .Now both have default schema as dbo.

In the New combined DB we will have two user(Hms,EAM) and two schema (HMS,EAM) and...

Peter Brinkhaus (12/8/2016)

---

You have to test it yourself if it performs better, but here's simplified alternative:

SELECT

Q.memid,

Q.EffectiveDate,

Q.termdate,

...

You're seeing the before (deleted.*) and after (inserted.*) picture. You can't do that with a single set of columns. What are you trying to do where this is...

datetime fields do not have a format, because they need to be...

Actually, that's not true. The ORDER BY clause...

CELKO (12/6/2016)

---

No, I get called in every now and then by product developers a lot of different SQL companies to...