use vbscript

null (11/3/2007)

It won't. Cast doesn't do anything special to set the size of varchar and varchar defaults

to a length of 30.

Empirical testing shows...

Do you really need the ROWLOCK? try removing it. 8.5M:11M means that a table lock would be appropriate for the operation. That would be a lot faster.

cast(fieldname as varchar) will do.

guys, i'm really loving this. keep them coming. I'm in manila and it's a 4-day weekend here, Nov 1-4. This post should keep the weekend interesting. 🙂

Mathematics is the universal...

create a CHECK CONSTRAINT...

Yep... as I said, no need for the trigger.

Also, if I get it correctly, there may also be no need for the EmailOut table. The EmailOut Table can come as...

Sergiy (10/15/2007)

Lowell (10/15/2007)

i disagree that a trigger is needed; part of the scheduled job should be doing a query like this:

select * from...

Excellent suggestion Lowell!

The EmailOut table is the way to go. You don't need a trigger for this solution.

"--I have a job that runs every night to set the bit fields...

SELECT SSN, COUNT (SSN) AS NumOccurrences

FROM CustomerRecords

GROUP BY SSN

HAVING (COUNT(SSN) > 1)

Any help either show me the TSQL for Select duplicated SSN records into new table or Delete the unique...

"return any DocID in TableA that doesn't have a EmpID row"

SELECT DocID from TableA

where DocID NOT IN (SELECT DocID from TableA where DocType = 'EmpID')

SQL Profiler

Application Role??

Hi Joe,

I'm from Manila. I'm interested and willing to help out. However, we can only do thid via VPN, remote desktop. Is this amicable with you? I'll send you my...

The columns/values you are selecting have exceeded the maximum row size (8094 or 8KB or 1 page) allowed. Try checking the source columns. You may trim the CHAR columns.