Try adding a couple more statements:

switch (name) {

case "Job1": this.DTDQC.Src = Page.ResolveClientUrl(imagename);

break;

case "Job2": this.XMEDPTX.Src = Page.ResolveClientUrl(imagename);

break;

default:

MessageBox.Show("hello, how are you");

break;

...

So something like

MessageBox.Show("Here is the message");

is highlighted as an error? It should work. Could there be an error on the preceding line?

Are there any triggers on any of the target tables?

So do the replace first, then the split.

That would not help either. I would have to do one join on the update for the transactions found, a delete for transactions not found followed by an insert of...

You could break your string into its individual words, using something like Jeff Moden's splitter[/url] and then match those against your bad words table. That should run fairly quickly.

I have never seen all of this written out so concisely before, thank you for the hard work that's gone into this.

m_swetz (3/10/2015)

---

There is a stored procedure that merges the ship, order, and load tables that does computations and concatenations of fields. This procedure also attempts to retain the identity...

How are the auditing values generated?

sunder.bugatha (3/10/2015)

---

DECLARE @I VARCHAR(10)

SET @I = '0745'

IF( SUBSTRING(@I,1,1)= 0)

SET @I = '0'+ CAST((CAST(@I AS INT)+15) AS VARCHAR(10))

ELSE

SET @I = CAST((CAST(@I AS INT)+15) AS VARCHAR(10))

IF( SUBSTRING(@I,1,1)= 0)

SELECT CASE WHEN SUBSTRING(@I,3,2)='60'...

Priya004 (3/10/2015)

---

I have created a package using Odata source as connection manager.I ran well in SSDT.I am trying to execute th e same package from Sql server agent job in...

Not as far...

VS2013 works fine with SQL 2014 – can you describe your problem?

VS2014 does not exist. There is only VS2013 and VS2015. Please double-check your question.

suresh0534 (3/9/2015)

---

Hi,

I got the Solution.

Below is the Solution.

DECLARE @str VARCHAR(400)

--Add your specialcharacters here

DECLARE @specialchars VARCHAR(50) = '%[~,@,#,$,%,&,*,(,),.,!^?:]%'

SET @str = 'KRA!NTHI@#KUMAR, KU%^?MAR GO~()$U.:D'

WHILE PATINDEX( @specialchars, @str ) > 0

---Remove special...