Ian C0ckcroft (2/18/2013)

---

Hi guys, I am trying to calculate the diffs between to days as a decimal. The hours will an easier wayybe in decimal.

i can do it in...

Thanks Jeff. I'll keep an eye out for it

stephen.poulitsis (8/8/2012)

---

Dear Gabriel

Your article is outstanding!

I would like to ask how the code would need to be altered if instead of one security, the table contained data for many securities.

This...

K. Brian Kelley (4/24/2012)

---

You're saying through ownership chaining the user has appropriate access.

As far as tying to a particular owner, no.

When you create a schema you should create the...

Sorry guys I appreciate your help, but I actually extremely simplified the query quite a bit. Due to confidentiality and privacy concerns I can't give out the exact dml, so...

I've read Gail's post but it only deals single parameter variables for each value. In this case, there are multiple inputs. Even if I code this in dynamic sql, it...

There's two tables, one is the main profile data (contains...

Michael Valentine Jones (12/6/2011)

---

This doesn't sound like a very good plan if you are just going to update the partition column, since it would force the data to move physically...

The dba wants to use 2 different disks - 1 for current data and one for historical data. So I'd either have to partition or create two separate tables.

If anyone cares, I found out the problem.

SSMS Menu -> Tools -> Options

In the left window click on the SQL Server Object Explorer branch > Scripting

In the list on the...

Ninja's_RGR'us (9/15/2011)

---

I'm 85% sure you guys are not talking about the same template concept.

1 talks about scripting and the other one talks about user made scripts you can edit with...

actually no luck. even when i change the template it still just encapsulates the SP in sp_executesql

USE [DB]

GO

/****** Object: StoredProcedure [dbo].[proc] Script Date: 09/15/2011 11:04:18 ******/

SET...

Jared you're the man!

Interesting article on the non clustered indexes. Thanks

I am visually trying to figure what...