:-D:hehe:

Divine Flame (5/9/2012)

---

Sony Francis @EY (5/9/2012)

---

Our company has used Linked server to get the other db server data . Now we are trying to replace the linked server with SSIS...

ASA :-P:-D

Jeff Moden (5/8/2012)

---

Do you really mean that all you want to see is things that have other than 0-9 or A-Z or embedded spaces in them?

If so, you can use...

Are you implying that you need a Trigger?

here is something that I worked up. Hope it helps:

--Creating Tables

Create Table Ex

(id int not null primary key Identity(1,1), ...

Please provide DDL of the table and some readily consumable Sample Data to go with it so that people can understand your requirement a little better.

kirkm 55368 (5/8/2012)

---

Hi Vinu

I will certainly do so, and update with better if I can.

Try it and you'll see that the people on this Forum are so freakin' smart that...

I haven't worked with SAP enough to tell you about Joining tables from SQL server with SAP tables. But you can import data from SAP into SQL Server USING SSMS...

Please use universal Names. Search Google what you are looking for, find what it is Universally called and then post.

Otherwise,...

Thanks for the link Suresh. It was very INFORMATIVE. :-D:hehe::-D:hehe:

Btw Sudha,

Index Scan: Index scan scans all rows of the table...

sudha.kotapati (5/8/2012)

---

Hi,

When ever we are using report parameters(SSRS),we find the 3 options

1.visible parameter

...

Have you tried this??

kirkm 55368 (5/8/2012)

---

But for the next part, tblAAA, tblBBB, tblCCC all have a Prefix field (which is contained in qryUC.Serial)

I want to include data from some fields in those into...

toddasd (5/8/2012)

---

Your table DDL and insert statements columns don't match, but it looks like you simply need something like this in the WHERE clause:

WHERE (origin_code = @origin_code OR origin_code =...

I agree with Drew.

Since you have got some time...