Why? What could you possibly gain from calling a stored proc from within a function? You...

terry999 (3/13/2015)

---

Sorry I forgot, total data movement is about 5GB 90% of this 5GB are 2 tables with the varchar(max) columns.

It takes about >95% of the time to move this...

terry999 (3/13/2015)

---

Hi

I'm archiving some data. In a 2 step process.

1. Copy old data from each table in LiveDB to same table in ArchiveDB.

2. Delete the data from each...

To expand on Gail's recommendation of brackets I am pretty sure you want something more like this.

WHERE

b.field1 LIKE 'ABC'

AND b.field2 BETWEEN GETDATE() - 30...

measterbro (3/12/2015)

---

The values are all hard-coded because that is the only way I can it to run for now. The point of the PIVOTS are to eventually replace the hard-coded...

I am obviously missing something here because making this run as dynamic sql seems a layer of complexity that just isn't needed here. It sort of looks like a dynamic...

Have you evaluated the contents of your dynamic sql? I would do that too. without knowing the exact code you are trying to execute it is difficult to know what...

measterbro (3/12/2015)

---

The errors I get when I use the variable are here. I don't get any errors when I remove the variable.

Msg 102, Level 15, State 1, Line 67

Incorrect syntax...

Brandie Tarvin (3/12/2015)

---

Okay, so I had (before Stephanie posted) reused my code to run a different proc and pull the month end date into my webpage. It worked fine. Now,...

Brandie Tarvin (3/12/2015)

---

Stephanie Giovannini (3/12/2015)

---

I have more C# experience than SQL experience. I prefer a job doing both, but have tended to bounce back and forth because DB Dev and...

thomashohner (3/12/2015)

---

Sean,

Thank you so much. This did work and provided my solution to a very hard to understand table structure and requested query I was dealing with. I have...

measterbro (3/12/2015)

---

I know it is being truncated because I get a syntax error at a point about a third of the way in my SQL which I don't get if...

ZZartin (3/12/2015)

---

Sean Lange (3/12/2015)

---

This thing screams of denormalized data when I see columns like IRSORRES6, IRSORRES7, IRSORRES8. If you can normalize the data you could eliminate the need to have...

This thing screams of denormalized data when I see columns like IRSORRES6, IRSORRES7, IRSORRES8. If you can normalize the data you could eliminate the need to have 3 queries here...

andyscott (3/12/2015)

---

Am I missing something, or aren't all those unions to the same source tables with the same joins and where clauses? The only difference I can see is in...