Eswin (7/2/2009)

---

Christopher Stobbs (7/2/2009)

---

Depending on how you system works you might need to make this dynamic as you may get more years creeping in for example 2009/2010/2011 ect.

if you need...

There are only two ways you might be able to accomplish this feat. First, if you running SQL Server 2008 Enterprise Edition, you can use native compression during the...

Really? That's it? How about this:

create TABLE dbo.SomeTable12

(

SchoolYear SMALLINT,

Teacher varchar(5),

Student varchar(3),

Class char(1) );

INSERT INTO dbo.SomeTable12

(SchoolYear, Teacher, Student, Class)

SELECT 2006,...

RBarryYoung (7/2/2009)

---

Lynn Pettis (6/30/2009)

---

Roy Ernest (6/30/2009)

---

David, That was funny... Gail, Grant, Lynn, Jeff, GSquared and all of you the Ghost busters... :hehe:

Lynn, you were posting at break neck speed today.....

What is the exact result you want and is the source date a datetime column?

You also have six correlated subqueries with select distincts. Each of those queries has to be run for each row.

It would help if you could provide use with the...

taurus2050 (7/2/2009)

---

Sorry.

It is a stored procedure, and the input parameters are the source cod01, cod02 and cod03 and the destiny cod01, cod02 and cod03.

The table has these rows as example:

1234...

Krasavita (7/2/2009)

---

Ok, Under File Section under Logs I changed from 2 to 100 MB,then under autogrowth under FileGrowth, also put 100 MB, then under Maximum put Unrestricted and click save,...

SUBRAHMANYA HEDGE (7/2/2009)

---

What happens when you failover? Is it again a SQL restart?

Let's say for eg., one of my job is running in a clustered instance and a failover...

Yes, it will take additional space. This could be a vaild concern. You have to be the judge on this.

Yes, there is the overhead to maintain the index....

Link as coded above doesn't work. Here is a working link: http://www.sqlservercentral.com/Forums/FindPost745975.aspx

Still clear as mud. How are you getting the parameters? Is this a store procedure you are trying to write? what is the expected output from the...

Not totally sure what questions you are answering or...

I agree as well, read BOL (Books Online). It just doesn't make sense for us to copy it here. If you have any specific questions as you are...

There are those out there that will tell you that every table should have a PK. There will even be those who may even advocate that it should be...