antonio.collins (1/16/2008)

---

re: Samuel Vella

that query does not seem to only consider sellers who have sold at least 3 items in each of the past 3 months. have i misinterpreted...

We just tried "trustworthy" option which seems to apply to stored procedures NOT VIEWS - we need to access data by VIEWS.  My understanding is that we...

Thanks.  Will the transactional replication can resolve the permission issue?

Issue:=>The permissions for the log shipped copy of the database are inherited from the primary database and cannot be changed without...

Thank you.  I've figured it out.  I shouldn't put measure_name in the join.

here's my finals.

 

SELECT  CASE WHEN LEFT(D.Location_2, 1) = 's' THEN substring(D.Location_2, 5, 5) WHEN LEFT(D.Location_2, 1) = 'D'...

The data is all there, before I joined the 2 tables, I ran the query and the result is correct:

SELECT  D.Location_2,

        D.Location_1,

        CASE WHEN D.PY = 0 THEN NULL ELSE...

Thank you so much.  Both queries work perfectly.

Thank you thank you thank you! 

Thank you for your quick response.  It works great except there's one employee's name is "John Del Valle Kalble", the last name is Del Valle Kalble, first name is John.

The...

an Instance (In Oracle term).  a group a databases. not logins or roles.

In the same server.

What about detach and attach the database?  Is it required to bring the database offline for detach? 

I thought detach and attach would be faster than backup/restore method.  The database...

super!  Thanks a million!

Yes I checked the datatypes for those joined columns, they are the same.

I have indexes on both jobs table and applicants table.

And I got same result :8 seconds , from both...

The code is neat and great, but now I am running into performance issue.  The result returns in average 8 seconds, and all the tables are less than 70 rows. ...

Perfect!  THANK YOU THANK YOU THANK YOU! THANK YOU SO MUCH!