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...

A CLR TVF is the fastest and best, in my opinion. Is that an option for you?

Another option here is to use SSIS, where you have instant access to C# via script tasks.

It has to be said: this is a very weird requirement. I would be interested to know why you are doing things this way – are you able to provide...

davoscollective (3/6/2015)

---

Between is inclusive of the...

I do not understand your point.

BETWEEN...

rolinoberto (3/6/2015)

---

Sorry, I means automatically within an application (Visual Basic 2012)

suppose I have an application, which is used to fill and use the information stored in a database, suppose (after...