Sean Lange (7/24/2012)

---

I understand you there and I am trying to help you protect...

Make sure you take not one, but several backups (or at least make several copies of the backup file) of the database before you run your script. You want...

Lynn Pettis (7/24/2012)

---

Ajdba (7/24/2012)

---

Right function is not getting the data; in the table it is datetime but I converted to varchar(10) in the view like this...

CONVERT(VARCHAR(10),I.DateOfIncidentDte, 110 ) as...

Duplicate post. How about posting all future responses here.

Be careful...

There are several things that can be done when it comes to the reporting vs updaing conflicts. One is move reporting to a another server or at least another...

Sean Lange (7/24/2012)

---

lokeshvij (7/24/2012)

---

My Friend, point here is that SQL Optimizer will not be able to use an index if the query is sargable. It will literally try to evaluate...

Keep the...

rhythmk (7/24/2012)

---

I am currently having below table and sample rows.

CREATE TABLE ORDERS (Year int, Month int, ORDER_COUNT int, ORDER_TOTAL int)

INSERT INTO ORDERS

SELECT 2010,4,8,29381 UNION

SELECT 2010, 5, 8, 28289 UNION

SELECT...

Sorry, not quite sure what you are asking here.

Also, I thought I'd show you another way to write your sql dynamically, not the it is needed since...

Check your sql logs as well.

avishwithu (7/24/2012)

---

I tried the run the query that you have posted ..

these are the steps :

CREATE TABLE VW_RPT_DATA (county varchar(100), rt varchar(100),incident_date datetime)

INSERT INTO VW_RPT_DATA values('a','b',GETDATE()),('a','b',GETDATE()-400)

CREATE TABLE VW_HIST_DATA (Rt varchar(100),rtnum...

We really do need to know the exact error message(s) you are getting in regards to your failed backups. Can't help you figure out what is wrong when we...

rodjkidd (7/24/2012)

---

ooo, thanks Brandi!

Just stick me in the corner of the tent so I can go wibble...

Always seem to come the party (a question I can answer) far too late.

Personally...