Jeff Moden (8/30/2012)

Materializing the view as an indexed view may be the best bet for such a thing. Using a pivot or a Cross Tab to create the view...

Evil Kraig F (8/30/2012)

---

Lokesh Vij (8/30/2012)

---

What according to you would be the best way to query data. Every time I increase one attribute in my select clause, I need to...

An easy one to end this week. Thanks 🙂

Great!

What a co-incidence, I also...

Here is the corrected version:

CREATE PROCEDURE [ENREGISTRERREJET]

-- Add the parameters for the stored procedure here

@RejID UNIQUEIDENTIFIER = '00000000-0000-0000-0000-000000000000' OUTPUT,

...

Greate question Wayne..got to learn something new today 🙂

Raghavendra Mudugal (8/27/2012)

---

Thank you Lokesh-ji, Nice question.

(So simple and yet it keeps us thinking..., to be honest I selected E,E and then seeing 2nd one's datatype as varchar, but...

kaspencer (8/28/2012)

---

As a matter of fact, SQL Server 2005 copes with this very well, provided that the data type is changed to DATETIME.

It would seem that in SQL Server 2005...

Kenneth.Fisher (8/27/2012)

---

demonfox (8/27/2012)

---

nice question ;

one more observation :

-- t1(id int,data varchar(50)) ; t6 table doesn't exist

create procedure usp_testing

as

select a.id,a.testing from t1 a

inner join t6 b

on b.id = a.id

go

this...

bitbucket-25253 (8/26/2012)

---

Nice basic question to start the week... Thanks

Am suprised / astonished at the number of individuals who missed this fundamental question.

Correct answers: 27% (4)

Incorrect answers:...

Raghavendra Mudugal (8/24/2012)

---

Good question, thank you Lokesh-ji.

Initially I checked the cb-3 box where it stores the poor query details - considering the trace tables from the server-wide catalog tables, but...

Alan Kwan (8/22/2012)

---

haha sorry I know this will be a stupid question. How do I create the view into a specific database?

Originally I had,

CREATE VIEW aggTest as...

Then I managed...

If you...

I knew there is a limit of 1000 records. But got it wrong 🙁

Overlooked the question: Inserts start from 0 that makes the first statement to exceed this limit as...

l.narasimha (8/22/2012)

---

Hi,

Thanks for your reply.

I tried to hold the lock on a table using sp_getapplock.

But after placing lock, it still allowing to perform INSERT or UPDATE operaion on table.

I...