Search results for query: *

Hello, we have a program running on a windows 2000 server. This programs loads data from excel files into a database. The program needs an excel addin to work properly. This addin in enabled in Excel and the addin is located in the user profile (lets call it X) which is used to start the...

Hi, as long as the valus are distinct this should also work. Then at least the order of the numbers should not matter. select * from (select top 5 * from #teaser union all select top 4 * from #teaser) x group by id having count(*) = 1 Atomic Wedgie i also tried select top 5 * from #teaser...

Damn, doesn't that work anymore in SQL 2005, that sucks. I totally find it impossible to read the ansi syntax. Well maybe the code was better then but the prinicpal idea of using aliasses was the clue. Regards, Atomic Wedgie

Gee, just because Crowley16 rewrites my solution in ansi syntax he gets credits and me not :-(

select * from players as playes1 , players as players2 , games where players1.id = games.player1_id and players2.id = games.player2_id

Thanks GlennUK, works great Atomic Wedgie

Hello, I have a graph which has a formula (IF) as input. However if the formula returns no value it is still represented as a 0 value in the chart. If the formula returns no result the item should also not be shown in the graph. Can anybody tell me how to fix this. Thatnks in advance, Atomic...

Hi, I have some SQL statements that were developped by someone else and I am having a very hard time in understanding what the syntax does. Could anybody enlighten me? UPDATE Table_X SET Field1 = (SELECT avg(FIELD1) FROM Table_B WHERE Table_A.FIELD2 =...

Hi, tried it but doesn't seem to work. Thanks anyway

Hello, I have a result from a query which I want to load into an excel file. The problem is that in my result I have an 18-digit number. Excel reads this as a number (1.9098090920-E09 or something) but it should regard it as text. Is it possible to create the query in such a way that Excel...

select datediff(yyyy,[date of birth], getdate())

SELECT N.ANSOS_ID,N.NURS_NAME, S1.STAFF_SHIFT AS 'SHIFT1' , S1.START_TIME AS 'START1' , S2.STAFF_SHIFT AS 'SHIFT2' , S2.START_TIME AS 'START2' , S3.STAFF_SHIFT AS 'SHIFT3' , S3.START_TIME AS 'START3' , <==problem right there FROM NURS N...

Hi SQLDenis, your solution: select 4*(5+6/3) is indeed interesting considering the allowed values are 2,3,4 and 5 Regards, Atomic Wedgie

select distinct code, account, amount from ( select CodeMaster.code, BCM.Account, Fund.fundID as procureID, 'Cntr&ObjCdFcAmt'=Convert(nvarchar(20), ((select Sum (amount) from Fund FC join CodeMaster COM on COM.coaID = FC.debitCOAID join...

how about this select ((5*2)-3)*4 Regards, atomic wedgie

Hi, maybe a bit dirty but I think this should also work select line, dept, pr, et from table where et is null union select line, dept, pr, max(et) from table where line & dept & pr (if you have id, replace with id) not in (select distinct line & dept & pr from table where et is null) group by...

'4','15','22','23','26','28','32','39'

Hello, look at Workflow (On completion, On Success, On Failure). Regards, Atomic Wedgie

Hi, what if you put the HAVING cb.CurrentBalance <> [balance] in the WHERE/AND AND cb.CurrentBalance <> [balance] AND cb.CurrentBalance <> 0.00 and then reomove the having completely Regards, Atomic Wedgie

Hi, maybe you will be more succesfull with your question when posting in the Setup and Administration forum? Regards, AW