Search results for query: *

that works :D ... thanks very much, I just couldn't wrap my head around this one this morning.

There will never be two different brokers for the same customer on the same day. but there will be multiple brokers for different customers on the same day ie: inv_nbr cm_nbr brk_nbr inv_date 1 cust1 brk1 10/31/2006 2 cust2 brk1 10/31/2006 3...

that doesn't seem to work ... because I have a lot of different customers being invoiced on the same day all with different brokers. (if that even makes sense)

I'm having a problem trying to update a customer master table with the latest broker to be invoiced. my table structure is: customer master (cm_mstr) cm_nbr cm_name cm_cur_brk AFFAMA0 some customer <blank> invoice table inv_nbr cm_nbr brk_nbr inv_date 1 AFFAMA0...

I set it too 800x600 480p, and the picture is ok (although it cuts most of my screen off). But when I do 480p the desktop background looks crystal clear (I have a half life 2 background, w TONS of colors in it) but whenever I pull over a window or any application everything (but the background...

I'm not 100% sure on the termonology to use but, I have a geforce 5200 that connects via dvi to my philips 55" hdtv using 1080i display. The problem is that my picture on the tv is shaky. I have the resolution set to 1920 X 1080 with the refreh set at 60mhz. If I drop the resolution down to...

I figured it out using: EXEC sp_addlinkedsrvlogin 'server1', 'false', NULL, 'user', 'test'

Sorry I thought I was on the SQL Server 2000 forum, this post can be deleted.

I have a two sql servers that have been sucessfully linked, using sp_addlinkedserver. The problem is server1 has a blank 'sa' password and server2 has a 'sa' password. When ever I try to run a linked query: SELECT Distinct PONumber, OrderNumber, LoadNumber, CarrierID from tblOrderMasterfile...

I have a two sql servers that have been sucessfully linked, using sp_addlinkedserver. The problem is server1 has a blank 'sa' password and server2 has a 'sa' password. When ever I try to run a linked query: SELECT Distinct PONumber, OrderNumber, LoadNumber, CarrierID from tblOrderMasterfile...

thanks for the insight ... you would think there would be a way to do that, but there isn't .. thanks again.

I'm trying to create a simple check contraint in access without going into access's table designer. basically in sql server 2000 I would do this .... CREATE TABLE tblCHECKtest ( item_code char(4) CONSTRAINT CK_tblCHECKtest CHECK (item_code = '0000') ) how can I do the above in access via a...

AH! that last one worked!!! thanks I can finally see what's its trying to do and it makes sense... sorry about the 'COMPLETE' thing...Iwas actually testing against 'READY' but either way it works... thanks again a star coming right up :)

all the above code still returns nothing, I've been messing around with them and I still can't get anything. so far they all return 0 records back, I've gone through the data and verified that is all correct and if I filter down by line='W99' and status='COMPLETE' it should return 2, but I just...

I'm having a difficult time figuring out how I can find out the first gap in a numeric col. I tried the faq and I just can't get it to work with my data. I have a table set up like this schedID (bigint id), lineID (varchar), schedStatus (varchar), prodSeq (int) I need to find the first gap...