There is no out of the box way to do this.

Have a look here for some ideas.

If you have only a few numbers to consider, there may be a simpler...

omakler (10/8/2014)

---

I was thinking the same thing last night. I will have to give that a try. How would you go about the first case in 2012,...

omakler (10/7/2014)

---

I am trying to create a SSIS package that will create a csv of a dataset for daily events in the database. However there will be days that...

sturner-926343 (10/7/2014)

---

I have 2 tables. Based on the Table1 id which is a column in Table2, I would like the following

Table1

T1_Id

1

2

3

4

Table2

T2_IDT1_ID ...

karthik82.vk (10/7/2014)

---

Hi Chris,

I cannot create rows for the missing dates or change the date as its not a permitted- one. the data comes from another system and adding or changing...

A note to the original poster. This thread is typical of many on this forum where, had you taken the time to write the question in the form suggested in...

Try this

use AA_Helper

go

select extension = AGENT_ID

from dbo.tblEmpData

where agent_ID is not null

union all

select agent_id2

from dbo.tblEmpData

where agent_ID2 is not null

If you want DISTINCT entries only, change UNION ALL to UNION.

I'm not 100% sure of what you are after, but maybe start with this:

SELECT DISTINCT

Extension = isNull(Agent_Id,'') + isNull(Agent_Id2,'')

from [AA_Helper].[dbo].[tblEmpData]

As you did not answer all of my questions, it is difficult to help you.

challakarthik (10/5/2014)

---

Hi ,

I have a scenario like ........I have 6 flat files(Country1,Country2,Country3,.......Country6) in the source and i need to fetch the records of Country1 flat file to Country1 table in...

kevinsql7 (10/3/2014)

---

Thanks Phil. Could you share how to set the security on SQL Server so that the developers do not have the rights to deploy to the sql servers? I...

Well, I'm glad it worked. But the mixture of char data types and arithmetical operations makes me find it difficult to believe that that was what you wanted!

I think I misplaced a bracket. How about this?

update tablename

set lineno = cast((cast(lineno as int) - 12) as char(4)), sysmodified=getdate()

where 1=1

and entry=545554

and type='X'

and cast(lineno as int) >=568

So there's your problem. It's non-numeric. You need something more like this (untested):

update tablename

set...

What's the datatype of LineNo?