GSquared (7/25/2011)

---

pwalter83 (7/25/2011)

---

GSquared (7/25/2011)

---

I'll give you an even simpler answer:

Don't do this.

Triggers will block transactions till they complete. Running an SSIS package for this is a really, really bad...

GSquared (7/25/2011)

---

pwalter83 (7/25/2011)

---

GSquared (7/25/2011)

---

I'll give you an even simpler answer:

Don't do this.

Triggers will block transactions till they complete. Running an SSIS package for this is a really, really bad...

GSquared (7/25/2011)

---

I'll give you an even simpler answer:

Don't do this.

Triggers will block transactions till they complete. Running an SSIS package for this is a really, really bad idea.

Queue the...

Lowell (7/25/2011)

---

there's only two ways i can think of:

1. use synonyms, and dynamically change the synonym defintion.

the problem with that is the synonym must point to an OBJECt, like a...

Yeah, that could be another way...but before giving a one liner for an answer, you need to at least read the...

Mike Menser (7/21/2011)

---

The + symbol means you are adding to the string which you are building. We are doing 2 different case statements both outputting to the same string. So...

Hi,

Thanks for your reply. I just needed one clarification- What does '+' signify in the syntax that you have mentioned ?

case when ARRIVAL_SCHEDULE_DT = DATEADD (month, 3, getdate()) and PORT_CD...

GSquared (7/18/2011)

---

This line is removing spaces from your options:

SET @tempItemList = REPLACE (@tempItemList, ' ', '')

However, rather than fixing that, I recommend replacing the whole function. Here's an article...

Thanks for your reply, please find the code below:

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

CREATE FUNCTION [dbo].[Split](@ItemList [nvarchar](4000), @delimiter [char](1))

RETURNS @IDTable TABLE (

[Item] [varchar](50) NULL

) WITH EXECUTE...

Ninja's_RGR'us (7/12/2011)

---

CREATE TABLE #test

( id INT NULL)

CREATE CLUSTERED INDEX #CIX ON #test (id)

INSERT INTO #test (id) VALUES (null)

INSERT INTO #test (id) VALUES (1)

INSERT INTO #test (id) VALUES (2)

INSERT INTO #test...

Ninja's_RGR'us (7/11/2011)

---

Can't be both. This is where intimate knowledge of how the data is used is critical.

Do you have access to the reportserver database and are you logging the...

Ninja's_RGR'us (7/8/2011)

---

pwalter83 (7/8/2011)

---

Ninja's_RGR'us (7/7/2011)

---

The missing clustered index is the best path for improvement at this point.

The 7 nc index would only slow down the import of the data (assuming it's...

Ninja's_RGR'us (7/7/2011)

---

The missing clustered index is the best path for improvement at this point.

The 7 nc index would only slow down the import of the data (assuming it's a massive...

Ninja's_RGR'us (7/7/2011)

---

pwalter83 (7/7/2011)

---

Ninja's_RGR'us (7/7/2011)

---

I was refferring more to the dynamic sql section. I just wanted you to have an exemple on how to build it.

With 17 optional parameters, the...

Ninja's_RGR'us (7/7/2011)

---

I was refferring more to the dynamic sql section. I just wanted you to have an exemple on how to build it.

With 17 optional parameters, the only valid...