GilaMonster (1/6/2010)

---

Why are there so many 'if you don't help me I'll lose my job' posts all over the place? I just got one by PM. Frankly, seeing that in...

CirquedeSQLeil (1/5/2010)

---

GSquared (1/5/2010)

---

CirquedeSQLeil (1/5/2010)

---

Hey Gus, I have an urgent need for a stored proc. It needs to join an Oracle, DB2, and SQL table and be heterogeneous.

I need it...

There can be valid reasons for a sexual disparity in work, but they all pretty much boil down to physical morphology. Because of the effects of testosterone on skeleto-muscular...

CirquedeSQLeil (1/5/2010)

---

Hey Gus, I have an urgent need for a stored proc. It needs to join an Oracle, DB2, and SQL table and be heterogeneous.

I need it done 3...

Of course he will. If he can't write something as simple as what I...

You haven't posted enough details for me to be sure this is correct, but here's what I can come up with:

;

WITH CTE

...

(Looks like a test/homework problem to me.)

Are you familiar with the string functions in T-SQL? Looks to me like you could resolve this with Len, Right, and a simple...

I just popped open the view designer, dragged a table into it, and then ran a separate query on a separate connection (different SPID), and it wasn't blocked. Not...

Are you asking about a schema lock or a data lock?

If you use the GUI query designer, it probably does issue a schema lock while you're building the query. ...

river1 (1/5/2010)

---

didn't undestand your answer.

I was asking if i can restore a dabase in SQL Server 2000 with a backup of a database in compatibility level (80) and try...

Take a look at "Restore HeaderOnly" in Books Online. It will give you the information you are looking for (as well as a lot of other useful information about...

Add "a.*" to your Select clause, and put the Where clause at the end exactly as you have written it.

Are you trying to get a count as your final output, or something else?

If it's a count, then it might look something like this:

select count(*)

from schema.table1

inner join schema.table2

on table1.column =...

I'll agree with most of what's been posted already. Do what you're doing when you're doing it. If your job is to manage, then learn to manage well....

tosscrosby-60625 (1/4/2010)

---

GSquared (1/4/2010)

---

tosscrosby-60625 (1/4/2010)

---

CirquedeSQLeil (1/4/2010)

---

GSquared (1/4/2010)

---

Well, while we're adding pictures: For a potentially limited time only, the goofy looking guy in the picture on my posts is indeed me. ...