A SELECT * in a cursor...So that means if a column is added to a table the system uses, the interface breaks at every point where it reads from that...

Thanks. As I'm still on 2008, I don't get to play with LEAD and LAG yet. Looking forward to having one soon, but the hardware hasn't arrived yet.

Celebration

SGT_squeequal (5/14/2015)

---

Hello

I am currently looking to take on a supplier software where the database is SQL server 2014, SQL server will only be accessed by 2 people to administer however...

Lynn's exactly right - We can't know what your table structure is unless you give us the CREATE TABLE statements for them. The mismatched data types in your join...

Canoe

GilaMonster (5/14/2015)

---

Question for the people here...

Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I...

Tenderloin

Can you check your data types? Specifically, check your join columns:

su.SiteID = ul.SiteID

j.SiteID = ul.SiteID

j.UserID = ul.UserID

I'm hoping that each pair have matching data types. If a pair...

Nice question to get the brain moving. I know it sounds trivial and somewhat unrelated, but this is yet another reason why I indent. Of course, I guess...

Nice question. IIRC, there haven't been too many questions about execution plans. Thanks.

g3463420 (5/13/2015)

---

Hi all. Thanks for the replies. VARCHAR is fine. The whole reason I need to cast is because when I output the results to notepad, it...

Hello and welcome to the forums.

What data type do you want to cast it to? You can wrap your column with a CAST function, but why? What are...

So you've validated that database mail is configured correctly by sending yourself a test email and you received it.

Regarding the job email not being delivered, go to the job configuration...

Cowboy