Interesting - if you're dropping and recreating the view in this sproc, then everything else which references the view must do the same - otherwise, the view definition is unknown...

karthikeyan (3/6/2009)

---

Thanks a lot to all.

I just wanted to know what about my solution? won't it be a god solution? I think 'YES'. Becuase i have used UPPER function. Right?...

If you were to write a SELECT against these two tables which returned just the rows you want to update from the target table, along with the target column and...

Mushy peas! Yum! Mushed ballistically!

Jeff Moden (3/5/2009)

---

Heh... I absolutely love it... let...

They're cool,...

Putts (3/5/2009)

---

Sorry for a bit of confusion, Derek, but have brought up a new query that is doing something very similar here on page 4....

Hey, thanks for going the extra mile, Putts. Can we have some table row counts as well, please? Off the top of your head is fine so long as they're...

Plenty, make yourself comfortable. You might want...

Hey Grant, your chum's back in town. I'm in the bleachers with a couple of beers.

Putts (3/5/2009)

---

As mentioned later in my post, it's a view.

I've read the Forum Etiquette but not sure how that applies to my question ..... unless you just always paste that...

Is IREP_V_POSITION_STANDARDS a table or a view?

peter.marshall (3/5/2009)

---

Ah - nevermind, thanks for the help but I've just found a solution! 🙂

I wrote a function which steps through the days of the month until it hits the...

Interesting...have a look at this...

SELECT u.[Last run], t.LastRunField

FROM [SQLSERVER\SQLINSTANCE].[Database].dbo.[UploadStatus] u

INNER JOIN [Table] t ON t.CashDesk = u.CashDesk and t.UploadJob = u.UploadJob and t.Store = u.Store

WHERE u.[Upload job] = @UploadJob

AND...

The usual suspects here are the backslash in the server name and the setting of quoted_identifiers... what does...