Search results for query: *

select statement select date1, date2, date1 - date2 from table required result: 28/02/11, 27/02/11, 1

Thanks, just what I wanted John

Hi I have a table: Part Serialno AA X01 AA X02 AA X03 etc want report to show on one line X01, X02, X03, etc Thanks

I need some advice. I require to present table information Table contains BOM parent BOM Child Qty 1234 AAA 1 1234 BBB 3 1234 CCC 6 1235 AAA 2 1235 CCC 2 etc etc etc I need to display this info...

Have have resolved my problem with DateDiff() function by inserting into a varable Thanks

I wish to update a table with an integer showing the difference between two dates. update table set fieldint = date1 - date2 Thanks

Thanks

I have tables containing supppart supp spart sqty 0100 AAA 0 0200 AAA 0 0300 AAA 0 0100 BBB 0 0200 CCC 0 order opart oqty AAA 1 BBB 1 CCC 1 I wish to update first table to show supp spart sqty 0100 AAA 1 0200 AAA 1 0200 AAA 1 0100 BBB 1 0200 CCC 1...

thanks

Hi, I want to create a batch file to copy another it location with a datestamp. Eg From: C:\mydoc\DATA.txt To: C:\mydoc\archive\DATA220610.txt The date stamp (220610) can be in any format. Thanks

Hi, I have two tables Table a contains Part Number A 3 B 1 Table b (transactions) Serial Part Qty 1 A 2 2 C 1 3 A 1 4 B 2 5 A 1 6 A 2 7 A 1 8 B 1 I need to produce a...

It is a memory issue. Old PCs with little memory the report doesnt run at all. New higher spec PCS the report works ok, but after a time and ther apps run it stops working. I was wondering if there are issues with particular versions of Crystal XI?

I have some crystal reports which work sometimes but other times dont and get a microsoft message "Memory could not be Read". Log off PC and it then will load again. This happens on all PCs at various times. Any ideas to the problem?

Thanks, so simple when you know

Normally I would use: DECLARE @today AS datetime SET @today = getdate() select * from table where sdate <= @today This will not work in a view, what is the alternative. Thanks

I would like to overnight send report to users via email. I wish to distribute information from sql 2000. Is there a way of doing this without the purchase of the expensive web server?

Thanks all sorted

This is the insert statement I am trying: There is a serial number field in the table, I dont select it in the insert. insert into mastshed (mastpart,mastdate,mastqty,mastref,mastsale,mastitem,mastord, mastadj, masttype, mastissue, mastshdate, mastcommit, mastissueno) select...

I have a table which contains a quantity value (say 3) table 1 Part Qty AAA 3 I want to insert into table 2 via a trigger Part Value AAA 1 AAA 2 AAA 3 thanks

Thanks nicearms for your help as well