Like David said, it depends on the volume of data. If the total size of all the fields in your query concatenated together is less than ~8kb, then you...

It's because you have a typo. The line

InSightAmKgODS.micros.date_table.bus_date=InSightAmKgODS.micros.opeartions.bus_date

should be

InSightAmKgODS.micros.date_table.bus_date=InSightAmKgODS.micros.operations.bus_date

(opeartions vs operations)

This is where it is wise to use a table alias instead of repeatly typing long table names, especially...

You need to use case instead of cast.

Is at2 a character field or a number field? I'm assuming it's a character field since you're comparing it to '6'. ...

If you use SQL logins, not NT trusted security, then you don't have to be on a domain at all. As long as you have TCP/IP connectivity (with DNS,...

I also sometimes use Excel or Access to "engineer" a solution when I can't think of an easy, quick way to do it in SQL. But in this case,...

Cool! I have been trying to use binary_checksum to do this, with varying results. Never thought about converting to varbinary.

Thanks!

Jay Madren

IF they will always be one-to-one, then it would be better to combine them all into one table.

If you want to make it work the way it is, you need...

You need to insert parent record(s) first, then insert child record(s) using the PK of the parent record. We probably need the schemas of these tables to be sure,...

I think you'll find the following is faster than the self join method:

SELECT FirstName, LastName, Company, <PK> FROM tblname

WHERE FirstName In (SELECT FirstName FROM tblname...

There's a great freeware utility in the Products section, called "Bill Wunder's DDL Archive Utility". It is a standalone program that basically performs the same functions that EM does...

Do you have to do it from a SQL query? If not, the easiest way is use the script generation facility in Enterprise Manager. And it's easy to...

In Enterprise Manager, select the server, then from the Tools menu choose Replication -> Generate SQL Script. Do this on both the publisher and the subscriber.

Jay Madren

Your friendly developer forgot to initialize @retVal in the function. When delcared, its value is NULL, and concatenating anything with NULL always yields NULL. So add the following...

quote:

---

when you install the server by default you

get the replication monitor shown in the EM

even though you have not create any replication.