mastersql (12/2/2015)

---

Hi

I’m trying to copy a SQL table schema and data from Server A to Server B. The SQL table is just a reference table which hasn’t populated for some...

That is because it...

cory.bullard76 (12/2/2015)

---

It maybe a datetime....but, I'd like to take that field and run the prior days data. Could I do that with a field that displays data in that...

If it...

Seems that you can't or shouldn't depending on which link and/or version you are using. As always we need to assume the most current version but the documentation is contradictory...

PJ_SQL (12/2/2015)

---

Can I do join inside trigger?If I had to join inserted with other table from different database is it possible?

CREATE TRIGGER TRG_A

ON _A

AFTER INSERT, UPDATE

AS

insert into _B

SELECT...

snomadj (12/2/2015)

---

Thanks Sean, appreciate the response. Understand what you're saying about dev help. Looking mostly for a starting point I guess. I'm principally a DBA but happy...

Do you REALLY need a cursor here? I see why you are using dynamic sql but /*DO STUFF*/ sounds like it is doing DML "stuff" which is almost always possible...

snomadj (12/2/2015)

---

Not sure how to phrase this question for google so please bear with:

I have an access backend on a standalone. Want to migrate it to a SQL backend...

Jacob Wilkins (12/1/2015)

---

In addition to what Sean said, the execution plans for the queries would be good to have as well.

Beginning in SQL Server 2005, the optimizer converts IF (SELECT...

Gagne (12/1/2015)

---

Hello all,

I ran into the strangest thing this morning. Users reported that something that has been running in less than 1 minute for years is now taking...

Jacob's examples are great. Just for grins here is another approach. This should be about the same for performance but is a bit simpler to understand in my opinion.

select p.PatientName

from...

Let's look at your last query. Reworking this a little bit to make it easier to see it would be something like this.

SELECT *

FROM #Patient P

INNER JOIN #Test pot ON...

yakko_Warner (12/1/2015)

---

I just migrated to a couple new sql servers and I am getting some alerts in a system I didn't setup.

It's called Idera something . . . It's...

Which values do you want? All columns or just column c? If you are not willing to put in some...