Hmm try to put the servername, login name and password in correct way, once again!

Don't do double posts! :w00t:

The original is here :

Steve it should be closed!

ps (12/29/2008)

---

Yes you can install more than one instance of SQL Server on a system.. Check maximum capacity specification on the limit of instances BOL... I guess its 50..

To access...

Yes you can run multiple instances in SQL Server Express also in Standard or Enterprise editions!

You should install again the SQL Server and during installation you will installed named instance,...

I see you question is...

No seems but just it is. Also I prefer Camtasia ! have nice work with video recordings! 😎

randall.c.newcomb (12/29/2008)

---

Some solutions and best practices apply irrespective of the version. What about a structure where the version is broken out only if it is significant. For example:

...

logan.techdump (12/22/2008)

---

We have a requirement of migrating cognos reports (around 200) to MS BI reports. Could someone throw us some light on how to migrate cognos reports to ms bi...

Jeff Moden (12/29/2008)

---

Just so you know... storing dates in a database like that is a form of "Death by SQL"... it will bite you sometime in the future.

The only reason...

feodon,

I tested before posting! So, I didn't have any problem on that ...how you are testing I don't know anyway you said that the Jeff solution is ok then enjoy...

yea...today article in SSC from MSSQLTIPS! - Not bad! :hehe:

Steve do you have any information plz!

Sorry for wrong section plz correct and move to the Employers and Employees!

Jeff Moden (12/28/2008)

---

feodon (12/28/2008)

---

Hello All ,

I have 2 questions from you , and I think that these are similar to each other from different aspects

At first

How can we insert a...

Look the bold code, I commented the Update action and I added the Insert action

:w00t:

This is the reason that I told you to post the table structure and soma sample data and little bit scenario what do you want to do!

Anyway, Update and Insert...