Hello,

Here is a string parsing routine in case you've never done one in TSql.

declare @tStr varchar(4000),

@strLen int,

@flag int,

@target varchar(10),

@tIntint,

@pos int

set @tStr = '1234,5678,9012,3456,444444'

set @strLen = len(@tStr)

set @flag = 1

while (...

Hello,

I think your where clause is not filtering the records you intended.

WHERE CHECKSUM( I.Start_date) <> CHECKSUM(D.Start_date)

The checksum of I.Start_date may match several records in Inserted.

The checksum of...

Please also take a look at Hibernate. There are several tutorials on how to use it and it really aids in simplifying the GUI development.

Regards,

Terry

Hello,

You could also use the parsename function.

It will allow you to parse full names into a max of 4 components.

Regards,

Terry

Hello,

One way would be to declare a bigString varchar(4000) and then concatenate the individual strings together in to that bigString variable and use it for the return value.

That seems so...

Hello,

Another way to have a row number is to use the alter table command and add a rowId int identity field to the table ( unless it already has an...

Hello,

Both Excel and Access can export data in a comma delimited format. Also known as a .csv file. They can also export data in a plain text file...

The price/performance issue is really part of being a good crafsperson ( PC huh!). You write the best code you can within the limits of the dead line imparatives....

Hello,

bcp does use text files but loads data faster than DTS. DTS can reformat data though.

I use bcp to load about a 1/2 million records to 20 data bases....

Hello,

If the UI is written in a language like C# or Java or VBasic, you can call a .bat script and execute it.

You can have the UI take the file...

Hello,

Your wording of what you are after is a puzzel.

But here's a stab at what I think you want:

select NamEmotion, count(*)

from Positivity

group by NamEmotion

order by Nam Emotion

That should...

Hello,

Some comments:

It's better to truncate and have the index already defined when you insert data.

It's cleaner to drop and recreate the tables and indexes before you bcp in data but...

Hello,

While it's true the "non-standard' outer joins are depreciated, they do work and will work quite some time into the future. Microsoft depreciated announcements do not mean the code...

Brute force solution... no extra charge.. 😉

create table tlb_one

( order_no varchar(10) null,

description varchar(20) null )

insert tlb_one

select null, 'ABC'

union all

select null, 'ACC'

union all

select 'K12', 'ACD'

union all

select 'K13',...

This is more of a shot gun approach.

insert CustPriceList

(CustID, Prdcode, Price)

select c.CustId,

i.PrdCode,

i.Price

from Customer c,

itemPL i

where c.CustID not in ( select CustId from CustPriceList )

I agree the CustPriceList is redundant unless...