By the way, do we have any solution to improve performance of CTE in case the category tree has depth > 4?

As I knew, if we use CTE to...

Mark-101232 (11/7/2012)

---

DECLARE @Category TABLE(CategoryID int,ParentCategoryID int, Name nvarchar(1000))

INSERT INTO @Category(CategoryID,ParentCategoryID,Name)

VALUES

(1 , NULL, 'A' ),

(2 ,...

Jason-299789 (11/7/2012)

---

You might want to look at this thread as its very similar to what you want to do,

http://www.sqlservercentral.com/Forums/Topic1379719-391-1.aspx

The only difference is the source table and column names and...

Michael Valentine Jones (10/26/2012)

---

DiverKas (10/26/2012)

---

I had a similar requirement, and FTS was the way to go. Only way the performance would get close to being reasonable. A LIKE...

TheGreenShepherd (10/26/2012)

---

Forgive my pessimism and, with all due respect to Gail, I don't think it's really applicable here. OP said that it's the client's requirement that the input string be...

TheGreenShepherd (10/26/2012)

---

There's probably a much better way to do this, but I'll just spitball this idea as something different...what if you created a computed column that contained a concatenation of...

Michael Valentine Jones (10/26/2012)

---

It would be better to have the query do a search for the specific item they are searching for, instead of doing a catch-all search on all...

In case, you want to create a new primary key, you should check existing PK and drop it then create a new.

IF EXISTS (SELECT * FROM sys.indexes WHERE object_id...

Maybe, the spp causes this error. You can excute the spp in your database directly. I saw that error message here: parameters is not null.

In the second package, you must declare the third OELDB connection athought the package doest not use this connection.

This is a disavantage of SSIS 2008 if you use the same...

I assume that you know how to retrieve value for SSIS variable from a store procedure

1- Create new a store procedure to insert SSIS variable into a table

CREATE PROCEDURE InsertValueFromSSISVariable

@SSISVariable...

SQLKnowItAll (6/21/2012)

---

Can you elaborate on the security concerns?...

Both are the same. If you only send email in internal system (your team), you could use the sp_send_dbmail. But if you send email to outside system (your client,...), I...

If you want to receive an output value from a store procedure in SSIS package, you need to select

1- Create a SSIS variable such as MyVariable

2- Drag and drop...

It's an authentication error. When report runs, it will connect to your database and require username/password. You should verify your data source.