Why are you pulling my leg........

Sorry Lynn had made a mistake............Thanks a lot for the help

No my date datatype is "datetime"

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 more...

Jeff,

Table:

Create TABLE SomeTable1

(

Date datetime,

teacher varchar(5),

student varchar(3),

class char(1) )

Data:

INSERT INTO SomeTable1

(Date, teacher, student, class)

SELECT '2009/1/1', 'mary', 'a.d','a' UNION ALL

SELECT '2009/1/11',...

No Florian its just that i couldn't solves alex's problem so i thought i will make it mine............since i didn't see many people viewing this post........

A "migration" generally refers to data movement, like migrating to Oracle from SQL Server.

An "upgrade" generally refers to an enhanced version of the software.

Check out:

http://msdn.microsoft.com/en-us/library/ms144267(SQL.90).aspx

http://www.sqlservercentral.com/articles/Administration/installingandupgradingtosqlserver2005/1943/%5B/url%5D

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&displaylang=en

alex_pangcats (7/1/2009)

---

Hi everyone,

Another table (Teacher_Student_Classes) that contains dayId,teacher_name,student_name,date & classes(subject).

ex. Teacher1 handle many classes(subjects)

ex. Every class have many students.

Now i want to create a query that shows how many...

check out:

http://www.angelosp.com/blog/post/T-SQL---Turning-rows-into-columns.aspx

can we append the backup of both tran logs and restore to one single log.

panna D'cruz...........

guess no where........:doze:

Are you running multiple instances of SQL Server, If you have multiple instances, it may be possible that dynamic port allocation changed the port of the named instances around,...

Ok jinu

I know that i can solve the issue by installing sp2........

I want to know the root cause of the issue...........

.

hi_abhay78 (6/29/2009)

---

all logins , users, roles will be restored from the pervious master backup .In case you more logins/users created after the last master backup , then you need to...