Joe-420121 (9/19/2015)

---

Hello Livingston, thanks for your reply, the table should look like as below data,

-----------------------------------------------------------------------------------------------------

(1, 'Col1', 1, 'ILove' ...

Ed Wagner (9/22/2015)

---

Alvin Ramard (9/22/2015)

---

Lynn Pettis (9/22/2015)

---

Alvin Ramard (9/22/2015)

---

Lynn Pettis (9/22/2015)

---

Alvin Ramard (9/22/2015)

---

Grant Fritchey (9/22/2015)

---

jasona.work (9/22/2015)

---

I think I need an intervention...

I keep going back to the "Jet" topic, it's like...

Lynn Pettis (9/22/2015)

---

Looks like I am going to get thrown into the deep end on some blocking issues with our main product. Having been working in relatively stable environments...

BOR15K (9/22/2015)

---

Sorry for a bit confusing topic, but need your advise, please.

I have old good stored procedure, doing quite complex SELECT FOR XML and all is perfect.

that SELECT has rows,...

squvi.87 (9/22/2015)

---

create table #t1 (id int)

create table #t2 (id int)

insert into #t1 values (1)

insert into #t1 values (2)

insert into #t1 values (3)

insert into #t2 values (1)

insert into #t2 values (2)...

pietlinden (9/21/2015)

---

Eric,

I go to the user group meetings the vast majority of the time. Hard to argue with free training where you can ask questions. =)

Maybe my problem is that...

tanitelle (9/21/2015)

---

Update:

I've found that when SELECTing the table with the non-printable character, the reason why it returns results from another table, is that during parsing, SQL Server removes the...

Anyone good with...

tanitelle (9/21/2015)

---

Hi, Lowell. Thanks for replying.

Unfortunately, this table cannot be found on sys.tables. Given this, I wondered if it in fact was a view or a synonym, but cannot...

I just tested this out... since you can copy it into NotePad++, try the DDL as:

DROP TABLE [<table name copied from NotePad++>];

The key here is to quote the names with...

Care to share your solution so that others can learn?

Kristen-173977 (9/20/2015)

---

We...

Everything that Gail has said is correct (naturally). If you're seeing the databases from another instance, you are connected to it.

Have you tried running these to see what you are...

Sean Lange (9/17/2015)

---

I can't change the table at all. It will violate our support contract. Not to mention it would be possible to get trashed with an update at some...

Luis Cazares (9/18/2015)

---

Alvin Ramard (9/18/2015)

---

Jack Corbett (9/18/2015)

---

Okay, I'm going to give the instructor the benefit of the doubt. Maybe lesson 1 is cursor and lesson 2 is...