RBarryYoung (5/13/2009)

---

nabeelmukhtar (5/13/2009)

---

Just found out that both sys.dm_exec_sessions and sys.dm_exec_requests return incorrect total_elapsed_time for parallel queries (requests with parallel execution plans). Is this a defect or a misunderstanding on my...

calibar2k (5/13/2009)

---

Hi

I created a dtsx package for bulkload, it is a huge data more than a million records in the text file. After loading 200000

there showing following error:

Data conversion...

Well I'm a pretty good guesser but I'm afraid that you'll...

Rich96 (5/13/2009)

---

RBarryYoung (5/13/2009)

---

That will remove all of the zero characters from [Account] if account is a string. Is that what you wanted to do?

If your intent was to change all...

Heh, I've been there too John. 🙂 Besides, really...

SOP on this would be SSIS, though there are some other ways to go.

Replication does not seem like a good choice as what you really need to do is to...

Anjana (5/13/2009)

---

i tried this,,,,

Insert Into tPM_Cmptc_Cat_Skill_Codes (compcatidno, skillcodeidno, fromeffectdate, toeffectdate)

select '-10001', a.skillcodedomainidno, a.skillcodefromeffectdate, a.skillcodetoeffectdate

From tskill_codes a

Where a.skillcodeidno in (Select *

from tskill_codes a

Where a.skillcodeidno not in...

More to the point, you need to get management backing on this. Big time. In fact, you need to get a manager to champion it because this is...

Actually I had assumed that since this is the SSIS forum. In any event, that...

Try this

LIKE '%3'

You have to have wildcards on any unanchored sides. Also, the LIKE wildcards are "%" and "_", not "*" and "?" as you would use for filenames.

That will remove all of the zero characters from [Account] if account is a string. Is that what you wanted to do?

If your intent was to change all of the...

Of course if you're lazy like me, you can just do this:

create procedure ....

@codes varchar(50)

select *

from myTable

where Charindex(','+myTable.code+',', ','+@codes+',') > 0

True, this pretty much forces a table scan, but...

Nish (5/13/2009)

---

I've heard that views are...

Nish (5/13/2009)

---

Sorry for not explaining properly,

To sort on Jobcount , i have to write "(ORDER BY j.JobCount)" , but as you said datatable does not know the table prifix, same...

The issue isn't just the possible sensitivity of the production data, it's also the fact that you cannot do regression testing on data sets that are not fixed.