I'd have to say - it comes down to how you plan on using the field. In the case you seem to be describing - you're looking to pass...

You sure you looking only at SQL server and not a visual basic reference as well?

Keep...

Have you tried installing .NET framework 2.0 SP 2

http://www.microsoft.com/downloads/details.aspx?FamilyID=5b2c0358-915b-4eb5-9b1d-10e506da9d0f&displaylang=en

Also - making sure the full Windows authentication is on, IIS is installed, and you run the install in Admin mode (as...

check for triggers. You might have something failiing a validation somewhere and getting rolled back.

Have you considered using a UNION instead?

....

from

STG_CUSTOMER_INTEG

INNER JOIN mst.CICS_DIM

ON (STG_CUSTOMER_INTEG.CUST_CIS_ID = CICS_DIM.CUST_CICS_ID)

UNION

...

from

STG_CUSTOMER_INTEG

INNER JOIN mst.CICS_DIM

ON (STG_CUSTOMER_INTEG.CUST_CRD_ID = CICS_DIM.CUST_CICS_ID)

UNION

...

from

STG_CUSTOMER_INTEG

INNER JOIN mst.CICS_DIM

ON...

Ivan b (2/13/2009)

---

Thanks for the answer and question Lynn

No, column names are PersonID, PersonName, etc.

A* is criteria for searching data in Access query.

I know that I should create View, select...

I'll believe it when I see the dried ink on paper, but that loophole is supposedly getting closed by Obama. The capping of executives salary @ 500G (supposed to...

I have to say I kind of like it. It sure sounds a lot more like what it really is than the SQL Server name for it (a.k.a NOLOCK)....

jbloes (2/6/2009)

---

So, I did a practice restore on another server and now I have a question.

In the real world, if I did lose the server, would it be best to...

The other thing you want to look at is that the definition of the input columns (in the SSIS package) actually matches the lengths. They default to 50, and...

Roy Ernest (2/5/2009)

---

This is the first time I am hearing that the SSMS changes the syntax of a query.

Yes, there was a mistake on the script. I had two ON...

Lynn Pettis (2/2/2009)

---

noeld (2/2/2009)

---

Lynn Pettis (2/2/2009)

---

Oh, right, the World Cup is the...

Lynn Pettis (2/2/2009)

---

Typical geek, can't stay away. I should know, I do the same thing here, even when away I check...

Michael Valentine Jones (1/27/2009)

---

Going by 120 yards by 50 yards for an American football field (100 yards goal-to-goal plus 2x10 yard end zones by 50 yards wide)

select Football_Fields_per_Million_SQ_Ft =

1000000/(select SQ_Ft_Per_Football_Field...

george sibbald (1/27/2009)

---

first shirt to whoever can tell us how many acres 1 mm sq ft is? and so we can picture it how many football fields that is.

Can I...