If you haven't already, you may also want to read this article[/url].

Please provide the DDL for the base table and the view (CREATE TABLE and CREATE VIEW statements), sample data for the base table in a readily consummable format (one that...

BaldingLoopMan (12/8/2009)

---

so for example. I have the below. Is this the same basic principle as using an into #tablename and then querrying it? Are the CTE's specific to the runtime...

Alvin Ramard (12/8/2009)

---

Bru Medishetty (12/8/2009)

---

Lynn Pettis (12/8/2009)

---

Bru Medishetty (12/8/2009)

---

I am 80 miles from Philadelphia, need to know the...

DECLARE @runDateTime datetime = GETDATE(),

@UserName varchar(100) = system_user

Above is not valid in SQL Server 2005, try:

DECLARE @runDateTime datetime,

...

Bru Medishetty (12/8/2009)

---

I am 80 miles from Philadelphia, need to know the time in order to plan.

Please...

Sounds like parameter sniffing. If you do a google search on this site you should find several threads that discuss the topic.

Using the row_number() function is what I came up with here:

create table dbo.StudentEnrollment (

StudentID int,

EffectiveDate date,

AdmitWithdrawInd char(1)

...

I also figured that yoda talks the way he does in public to confuse people. Catch him behind close doors and he talks just like the rest of us....

doran_doran (12/8/2009)

---

Writing my first trigger. Can anyone verify or fix if I am missing anything? Many thanks in advance...

CREATE TRIGGER [it_Orders_to_OrdersFill]

ON [Orders]

FOR INSERT

AS

BEGIN TRY

INSERT INTO [DB2].[dbo].[OrdersFill]

(OrderID,

LastName,

FirstName,

MiddleName,

Birthday,

Gender,

Class,

Agency,

Race,

Status)

SELECT d.id,

...

hmm, Yoda you hear when mine you read, right?

darth.pathos (12/8/2009)

---

Thanks Lynn! 😀

We don't have many self-joins so I may as well update them all, I was just curious.

Now, *= and =* joins are going to be another...

If you are trying to get a count of the number of items sold for each part, you should sum the qty sold. Is there a qty sold column...

darth.pathos (12/8/2009)

---

Hi All,

We have finally been given the go-ahead to migrate up to SQL Server 2008 (YAH!) and I'm reading the Books Online trying to get a handle on all...

It is what it is. How sysdepends was implemented did not account for recording updates where depentant objects were created later. This has, iirc, been corrected in SQL...