I have been given a new requirement for a database that I have been using
for a long time. I have a Name field that needs to show as FirstName and
LastName for one report. I am having a hard time figuring out how to modify
the query so that it only calls up the first or last names. I can see how to
select a certain character length, but until we can convince everyone to
have names of the same length, I can't see that helping. The names are all
stored with first name, a space, then last name.
Re: a union is always a join! ... What is your definition of mysticism?... Consider the last few exchanges between Brian and Tegiri. ... given that any delta in a database that can be caused by an update can also ... the creation of a new thing in the UofD.... (comp.databases.theory)
Re: a union is always a join! ... What is your definition of mysticism?... Consider the last few exchanges between Brian and Tegiri. ... given that any delta in a database that can be caused by an update can also ... the creation of a new thing in the UofD.... (comp.databases.theory)
Re: Recovery Question ... I tried to explain why backups were not used - there is no point in ...wasting time implementing RAID when this is merely throw away data - I ... There are some people who clearly believe that helping anybody ... Use the ALTER DATABASE...... (comp.databases.oracle.server)
Re: What does it mean to "recover" a database? ...Brian - you need to contact Product Support ... > My purpose for resetting the suspect status was so that I could run a dbcc ... I was hoping that I could fix the errors with that route. ... > the suspect status of a database, especially when the suspect flag is not ... (microsoft.public.sqlserver.server)
