Mhlewis (7/12/2012)

---

I would either execute the .NET code that Lowell provided in a SSIS script task. In a prior position I used to do work like this via an...

the funny thing is that yes they are all being used, and they all average 45MB. I have tried to make them all as small as possible, and am...

I really hate to sound needy here, and your post seems like it will take care of what i have going on.

and of course here is my stupid...

I would suggest breaking up the data into the sets actually needed by each set of reports. Indexed views might be a good way to do that, so...

that would be ideal, but i don't receive the data until 8:00 am CST. so I'm working on...

I am working on that with the restructure of the DB. If i do this now with the current structure then it will bog down the DB more so...

I have this figured out, it had to do with my groupings outside of the code i pasted below.

SELECT Survey, Center, AVG(FCR) AS FCR, ROUND(AVG([Total...

this did the trick, thanks once again everyone.

I did find some references online to Ltrim and Rtrim, but i dont really understand the syntax.

edit: nevermind it looks like ltrim and rtrim only remoce spaces not characters.

Sorry guys,

Just changed the problem. Please see the edited table data last two rows. Those exist and cannot be changed as they will be used.. 🙁

but that would be too easy 🙂

can this be done with replace?

JPLeBlanc (1/22/2009)

---

UPDATE dbo.[PCS Data – Details]

SET dbo.[PCS Data – Details].[timestamp] = dbo.[PCS data –...

Awesome, i see where you are going from there, just a quick check that after the conversion is performed, that it is greater than the lowest date possible. ...

:unsure: :Whistling:

thanks guys, on the same note..

If data such as you suggest would return an error, then how could i go about preventing it without explicitly...

Thank you GSquared this was what i needed!