Search results for query: *

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

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...

I wish to update a table with an integer showing the difference between two dates. update table set fieldint = date1 - date2 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...

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...

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?

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?

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

i need to seperate out the number and description from a field (not created by me!)Table in MSSQL 2005 example of existing Table Ref id Desc 1234 1 ABCD,ABCD,ABCD 1234 2 CDFD,CDFD i want new table REF id qty Desc 1234 1 3 ABCD 1235 2 2...