I am wondering whether it would be worth producing properly normalised tables in each of the databases. I'm thinking along the lines of

(CustId, AttId, AttValue)

These three values could form...

Paul Stasny (10/9/2014)

---

Phil,

Thanks for your reply. I'm not clear on what you are suggesting. The only thing that links the two databases is the custid and custcode values. Based on...

Perhaps you can change your approach slightly – how about modifying your queries to run independently and produce lists of row counts, sums, checksums, whatever and then comparing those results?

Never mind your old friend. Your...

Try running this and the answer will become clear:

DECLARE @strdate varchar

SET @strdate = '2004-01-01'

select @strdate

By declaring your variable as Varchar but without a length, SQL Server assumes a length of...

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