Hello,

Why not create a unique combo index?

For example:

RefType EngCode EngDesc

----------------------------------------

FeeType Hand ...

Hello,

Also use the USE command.

Like

USE SALES

or

USE MASTER

The USE command points the query to to a specific data set.

.dbo = data base owner and is a default for owner of...

Hello,

The TOP can go to the right of the assignment too.

like

select @variable = ( select TOP 1 salesAmount from sales )

Regards,

Terry

Hello,

The Select statement returns the output to the output screen.

'Assuming' you want to get the XML output to the operating system, you can load a table with the...

Well Done! Clear and great examples. Thanks for another arrow in the quiver.

[font="Arial"]

Hello,

There is a wild card character which is the percent sign. ie %

select field

from table

where field like '%bike%'

order by field.

If you don't put a % sign...

[font="Arial"]

There should be a tool that let's you see what the select statement is that the Report is going to use.

That's what I mean by SQL view port.

Regards,

Terry

[/font]

[font="Arial"]

Hello,

If the two data bases are both MSSQL 2000, just add the destination server as a linked server.

Then you can do distributed transaction processing between the two servers and or...

[font="Arial"]

Hello,

We feed data from several MSSQL databases to the MAS90 data base. We use data extracted in defined structures and then feed it to MAS90 via it's import facilities....

[font="Arial"]

Hello,

Another way is to create a .bat file that calls osql which in turn will execute your stored procedure.

This .bat can be added to a scheduler software that will execute...

[font="Arial"]Hello,

There shouldn't be a problem due to their not being foreign keys on the tables. The where clause is how SQL joined tables together before Microsoft promoted the use...

[font="Arial"]Hello,

I haven't experimented with it but since the text is managed by a pointer, setting it to NULL should reset the field to the minimum length just like a ltrim(rtrim())...

[font="Arial"]Hello,

To see the table definitions you can use SQL Analyzer or the freeware version of TOAD. Either of these tools will show you what the keys are, if they...

[font="Arial"]

Hello,

How about :

select people_number,web_role

into #temp1

from tableName

where web_role in ( 3, 8 )

order by people_number, web_role

Regards,

Terry

[/font]

[font="Arial"]Hello,

Question: Do you NULL the text column first to reset the text pointer?

Regards,

Terry

[/font]