You can help us help you by reading the first article I have linked in my signature block below that regarding asking for assistance.

So, what don't you like about T-SQL? I find it quite easy to work with and haven't had any problem moving from a 3GL language (COBOL) to it.

The paradigm...

After stopping your code (still hadn't finished after 55 minutes), I reran the code I showed above and here are the results.

My code:

SQL Server Execution Times:

CPU time...

Now, you may be askiing "Why?" Check the second article (Running Totals and its variations) I have linked below in my signature block. If it has been republished...

Manju (3/13/2009)

---

I completely agree with your assesment of my query. I thought I had made that some what clear myself when I said "with the sample dataset"; but I should've...

Manju (3/13/2009)

---

Just tried the following for academic reasons -

With the sample dataset, the execution plan seemed far simpler - you may want to give this a try too.

update t set

...

Since this is a school project, it is best if you do your initial research first. As you find the various answers to your initial questions and need clarification...

ramadesai108 (3/13/2009)

---

The output should be intID and ClientID. Take out the intID in the order by statement because that was a mistake. As seen by one of the responder, the...

ramadesai108 (3/13/2009)

---

Hi,

The index is on the intID column. here is the script to create table and add data

create table Clients

(

intID INT,

...

Please post the DDL for your table, sample data (as INSERT statements that can be cut and paste into SSMS and run) including both numeric and non-nummeric client ids, and...

Milan Sadil (3/12/2009)

---

Table1 - personID, firstName, lastName

Table2 - personID, badgeID, validFrom, validUntil

I would need to create a query that would result in the folowing:

firstName, lastName, badgeID

whereas:

- only valid badgeID (understand...

Nope, not too harsh in my opinion.

Unfortunately what you have does not work. Try it with the other criteria you stated earlier, it still returns 1.99.

Also, unfortunately, I don't have time right now to look...

Richard Briggs (3/13/2009)

---

Richard Briggs (3/13/2009)

---

Comrades,

as regards my own post on creating a CALCULATED PERSISTED column containing 'Age'.

I have discovered that actually because GetDate() is non-deterministic such a column cannot be...

Oh Boy! Double Posted Interview Questions that OP couldn't answer, here, and here

Really makes you want to jump right and help, don't it? 😛