I would take a look at Merge Replication.

Hmm... I'm kind of confused. Is there an application accessing the data? Where did you create the ODBC connection? Are you dropping Access once SQL Server is added or...

slimjen (5/22/2012)

---

Hi All, I created a odbc source for a sql database back end I am upsizing an access database. When I created the connection; where it ask "How should...

SQL Kiwi (5/22/2012)

---

This doesn't compute someone's age. It needs a formula like:

Age =

CASE

WHEN DATEPART(DAY, dbo.b_ENROLLMENT.MEMBER_DOB_DATE) > DATEPART(DAY,...

It will be hard for me to describe it here in a forum. Please look at this link (http://agilebi.com/jjames/2010/09/10/how-to-pivot-data-in-ssrs/) or google matrix columns SSRS.

Beginner2012 (5/22/2012)

---

SQLKnowItAll (5/22/2012)

---

You would take the column name that you want (Code) and drag it into the...

Try this:

Select

dbo.b_ENROLLMENT.MEMBER_DOB_DATE,

dbo.b_ENROLLMENT.EFF_DATE,

dbo.b_ENROLLMENT.MED_ID,

dbo.b_ENROLLMENT.PLAN_CODE as aid1,

dbo.p_DMAS_MEDICAL_TRANSITION.recip as recipno,

dbo.p_DMAS_MEDICAL_TRANSITION.SEX as sex,

CASE

WHEN dbo.p_DMAS_MEDICAL_TRANSITION.SEX = 'M' THEN 1

WHEN dbo.p_DMAS_MEDICAL_TRANSITION.SEX = 'F' THEN 0

END AS MALE,

CASE

WHEN dbo.b_ENROLLMENT.PLAN_CODE = '450' OR dbo.b_ENROLLMENT.PLAN_CODE =...

chalbert (5/22/2012)

---

Thanks...but I keep getting the errors:

Msg 207, Level 16, State 1, Line 22

Invalid column name 'aid'.

Msg 207, Level 16, State 1, Line 22

Invalid column name 'aid'.

Msg 207, Level 16,...

You would take the column name that you want (Code) and drag it into the Column section...

Holy parentheses Batman! I cleaned this up a bit and bolded the problem section.

Select

dbo.b_ENROLLMENT.MEMBER_DOB_DATE,

dbo.b_ENROLLMENT.EFF_DATE,

dbo.b_ENROLLMENT.MED_ID,

dbo.b_ENROLLMENT.PLAN_CODE as aid,

dbo.p_DMAS_MEDICAL_TRANSITION.recip as recipno,

dbo.p_DMAS_MEDICAL_TRANSITION.SEX as sex,

CASE

WHEN dbo.p_DMAS_MEDICAL_TRANSITION.SEX = 'M' THEN 1

WHEN dbo.p_DMAS_MEDICAL_TRANSITION.SEX = 'F' THEN 0

END...

Here is the link I use: http://msdn.microsoft.com/en-us/library/ms191516.aspx

andersg98 (5/22/2012)

---

Yes. The concept is called 'partition elimination'. Especially when scanning the table for a date range, the optimizer will realize it only has to scan the current...

Can you run a server-side trace for a bit and see what it comes up with?

Cadavre (5/22/2012)

---

Bit of a guess: -

SELECT Num,

((SELECT bits

FROM (SELECT SUBSTRING(CAST(Num AS VARCHAR(19)),n,1),

Num

FROM...

Cadavre (5/22/2012)

---

Bit of a guess: -

SELECT Num,

((SELECT bits

FROM (SELECT SUBSTRING(CAST(Num AS VARCHAR(19)),n,1),

Num

FROM...