Sorry, in SSIS, you have to use regular (double) quotes around strings, not single-quotes. Forgot about that.

I tried this out, and I had to also have a derived column...

Basically agree with you DonaldW.

One experience I had, though, makes me put at least this warning on that idea.

I had a query that joined a table, through a many-to-many table,...

ALZDBA (1/18/2008)

---

I wonder how intelligent SQL2005 would handle a this

create view V_myLanguages

as

select 'English' as Language, Base, Text

from tbEnglish

select 'French' , Base, Text

from tbFrench

select 'Chinese' , Base, Text

from tbChinese

go

Select ...

from...

There are two ways I know of to do this efficiently:

select Base, Text

from tbEnglish

where @Lang = 'English'

union all

select Base, Chinese

from tbChinese

where @Lang = 'Chinese'

...(rest of tables)...

if @Lang = 'English'

select Base,...

select convert(varchar(20), cast(datefield as datetime), 101)

from dbo.table

That should do the trick for you. Just replace "datefield" with the actual column name and "dbo.table" with the actual schema and table.

If...

Actually, that's probably an even better...

43,000 is only 6 iterations through at 8,000/iteration. It's not elegant, it's even ugly, but it shouldn't take too awefully long to accomplish.

Good luck and let us know how...

kirk (1/17/2008)

---

GSquared

I understand your explanation. Makes perfect sense. The problem I have had when working with DISTINCT is that all columns in the select list are engaged in the...

You don't need parentheses around the select in the insert statement at the end of your script.

insert into #ALLQ

SELECT 'T'+ T334.C2 + RIGHT(T334.C1,7) -- error message point to here

+...

My ProofOfConcept database rarely has any consistency from day to day. Usually, I throw together whatever tables I need in order to have just enough to test the exact...

Get a copy of SQL Dev Edition, or at least a copy of SQL Express, and start playing with it at home. Build some databases for your own use.

I...

we7313 (1/15/2008)

---

We are runinng Sql 2k5, and are considering going through the effort of referencing all objectowners before the object name. Is it really adventageous to do this? ...

On a production server with multiple users, I'd stop the SQL service first, just to be sure that Windows doesn't force a shutdown in the middle of a long-running transaction.

Select Distinct on dbo.MyTable should give you what you want.

Using "Select Distinct" in a subquery for an "in" clause doesn't actually do anything except make more work for the server.

Think...

jkurtis (1/17/2008)

---

I've used both writetext and updatetext, however they expect a varchar value as the last parameter. What i really want to do is use updatetext, but instead of...