Like I said too, if you have identity columns and those values are referenced in other tables....how can you maintain a script of that? Let's say you have tablea with...

Do you have any large tables? The size of the scripts are going to become unwieldy as the amount of data increases. What happens when somebody accidentally removes some inserts...

That seems like a recipe for disaster to me. Not to mention deployments could take hours instead of minutes when all objects and data have to be scripted. That seems...

Ever done any programming? A stored procedure is just a method. It takes in some parameters (optionally), performs some work, and returns something (optional). Any books I would have used...

Count() and Group By

daninmanchester (1/3/2012)

---

Great, a calendar table is a good idea.

So lets assume I've plugged the date gaps using a calendar table.

If I do something like this :

SELECT tbl_Calendar.Date, Min(tbl_Report.MyValue) as MyVal

FROM...

This would do it too. 😉

Something like this?

select cast(ROUND(col1 + .005, 2) as decimal(9,2)), * from #MyTable

Of course rounding up is not actually rounding....

Then I will assume you want...

Sean Grebey-262535 (1/3/2012)

---

Yeah, it puts 4 digits in. That seems a bit silly. How can you have $96.1538? I need it to represent actual money payments. Any thoughts on how...

Your post raises more questions to those of us wanting to help that we could answer. It is unclear if your table has records for all the dates but the...

They really aren't that different than procedures in Oracle. There are a few syntax differences but the concepts are 100% the same.

Sean Grebey-262535 (1/3/2012)

---

I am trying to divide a column by 26 and cast the result as Money for an Update/Select SQL Query. I'm just figuring out the select part first,...

Search this site for islands. There are several great articles and tons of forum posts on the topic.

If you have access to modify the dll you could probably make some value be your null/default. Something like -42 or some other value that is not possible during normal...