Are you using SSMS and selecting edit top 200 rows? That is the only way I can think of where you will see True / False for bit fields. If...

cengland0 (12/16/2010)

---

I did some research on the Mayan calendar and it seems they...

Before somebody decides to correct me, it accepts 1 0 and null. 😛

Well...it actually only accepts 1's and 0's. I assume you are meaning from a front end of some sort?

Good question. Don't worry about the people who are complaining about the question. There are some people who will complain no matter how clear the question is. Given the history...

Yes they do. It's called SQL Search and it is 100% free. It works really well and runs super fast.

Assuming you would use an update trigger you cannot make it not fire conditionally on which row is updated, but you could add some logic in the trigger do not...

Happy to help. 😀

Now you need to go the database you want to allow access to and allow the user to have whatever access you want to the individual db objects. Sounds like...

This get you there?

select RecruiterID , count(distinct Proj.ProjectID) as ProjectCount

from dbo.tblProjects Proj

join dbo.tblProfiles Prof on Proj.ProjectID = Prof.ProjectID

where Proj.Datecreated >= dateadd(mm,-6,getdate())

group by RecruiterID

having...

I believe they are trying to create a sproc that will delete tableA when there are foreign keys????

To do this you would have to either update the children table to...

I guess what i was saying is that if lat and long are important then you will need to include them like you already are. You will either need to...

I guess the question is why is a field like latitude included if the value is not relevant? You either need to leave it in the result with all the...

fawwad (12/13/2010)

---

No, i just sent you piece of my result set.

i retrive this from a query...

select p.id as 'CarID',p.cellnumber as 'Reporting SIM',p.Longitude,p.Latitude,p.statustext as 'Status',

p.assembled as 'Sent Time',p.received as 'Received...

You have to set the permissions for the user and allow them access to the database first. Then you can allow/disallow for each database object. Hope that makes sense.