anthony.green (6/15/2012)

---

Thats because the lock isnt tied to an object as I said in the above post, as the lock is at the DB level the DB is not an...

Lynn Pettis (6/15/2012)

---

vinu512 (6/15/2012)

---

Are the two tables related??....If yes then which are the fields which relate Table1 to Table2. You need to provide some more info like this for us...

dwain.c (6/14/2012)

---

I think your friend's suggestion is appropriate.

If you're worried about having 500000 rows in the role/screens table, try only storing the relation if the role is authorized to use...

Here is the link to the Print Screen image that shows the result sets returned by both the queries.

Image[/url]

One more thing I wanted to ask is that sp_lock shows Object_Id...

These two queries don't show the complete results as sp_lock.

When i execute sp_lock I can see a result set consisting of a few rows of results.

But, when I execute your...

This is the query that I tried and is working fine according to the Logic.

--Creating Table

Create table Ex

(TemplateId int,

ItemNAme Varchar(20),

ItemDate Date,

Value int )

--Inserting Sample Data

Insert Into...

I don't think so. I tried it and this was also returning only the Database Ids.

Hi Chris and Dwain.....this is really sweeet. 😀

Kingston Dhasian (6/15/2012)

---

You are over thinking the homework assignment. Plus, having worked in a public school district, if there was a gap in years, I would assume that the...

Are the two tables related??....If yes then which are the fields which relate Table1 to Table2. You need to provide some more info like this for us to understand your...

You can do it as Follows:

--Creating Tables

create table student (studentID varchar(12), Firstname varchar(12), LastName varchar(12))

create table school (scode int, schoolname varchar(12))

create table studentSchoolHistory (studentID varchar(12),scode int, iSchoolYearcode int)

--Inserting Sample Data

insert...

I am really sorry guyz.....I forgot to mention that our server is SQL Server 2005.

I am really sorry to have posted in the wrong Section.

Johan, your solution of CDC was...

Right now it is supposed to be a one time affair but continuous Follow up is also on my mind so that I can double check sometimes and make sure...

Other than Roryp's Solution, there are a no. of ways(including Pivot) you can do this. Here are a few:

--Creating Table

Create Table Ex

(Id int,

Value Char(3) )

--Inserting Sample Data

Insert into...

You can turn on CLIENT STATISTICS which gives the number of bytes returned from the server when a Query/Procedure is executed.

The next best thing to this would be to get...