Search results

ok will get back to you on that . thats exactly the. question am asking the Project owners that why are we comparing to '0' when the data values in the field are archer data types e.g Green, Red, N/A etc

Hi Minty what would you suggest the solution to this issue please. here's an example of the data values in the CapFuture and Capnow Columns Capfuture Green Red Green Green N/A Thank you

Thanks very much

arrh thanks thats probably why . yes the CapNow and Capfuture have values "N/A" in them and they are varchar datatype but its funny the access code worked in access though

quick question please this code works very well but I have a slight error message probably to do with the data . any help will be much appreciated Error Conversion failed when converting the varchar value 'N/A' to data type INT Troubleshooting when I comment out the line below I dont get the...

I know your very right . its like going round the blocks in circles when their is a straight line option too.probably why I couldn't get my head round it anyway code was inherited from access database . thanks anyway for your help

thank you for responding so quickly 1.true suggesting the WHERE doesnt need the CASE . I will test this code and see. Many Thanks 2.Oops thanks you are right the first case is wrong its typo meant to be WHEN [Capnow] = '0' THEN NULL ELSE [Capnow]

hi Could someone please help. this is an access query with IIF's statements , as you can see I have translated to CASE WHEN but am having trouble translating the WHERE part of this clause .Thanks SELECT Capability_Q.IDQ, Capability_Q.Capability, Capability_Q.OtherDesc...

ssis transformation task?am confused do you mean SSIS transformation task can convert that VB code I included in my previous post ? still need to use a programming language wont we. so what will be the difference between script task and SSIS transformation task Thanks

thank you but when you say correct permission to connect . I have db_owner permission on the database . in the past ive always developed on the Server with SSIS installed and BIDS/SSDT with SA rights on my server . OK I will try it out . just wanted to know if anyone done this before

am trying to design SSIS for ETL from access/excel sheets to SQL Server and will require transformation with script task in VB. the SQL Database in question is on a Shared server and cant get SA permission on the virtual box. the suggestion from the 3rd line support team is to create and...

Thanks I should know that myself. Fantastic this is great. ignorance is really bad . I was going to do long winded and start creating 200 columns with data types etc . Phew . I will now do insert the other bits - truncate etc and let you know .

ive now put the 3rd step in the correct section in the sp .( it was not correct before)so am running the query as above but getting incorrect syntax near keyword select

Thanks a lot but am not clear about this bit SELECT * INTO YourNewTableName FROM..........??? not sure what to put in there .I understand the syntax of select into new table from old table but OLD table doesnt exist . the table am trying to create is meant to be from the results of the...

thanks Minty. if you remember this is the whole code to create the sp here below the reason I need a permanent table is for users accessing via tableau so they can access the table and select columns as they want rather than executing the stored proc anyway the answer is NO I haven't created a...

Hi All does anyone have any idea how to turn this stored procedure into a table please i.e would like the columns produced by this stored proc made into a permanent table in SQL Server . if you recall ,the reason this stored proc was required in the first place is to join 3 views together...

The answer to Isaac is No. the tool consist of up to 16 Excel worksheets and the code copied above is only one worksheet . so a lot of code. and ur correct . the reason why SSIS came to mind is the job scheduling etc I suppose my question is advise or suggestion on the best solution to...

oh this is only the code for one of the worksheets out of several (30) .its about but Yes you are correct .their is code written for every worksheet that makes up the Collection Tool which is kind of a repetition of this code posted here but for different Worksheets. so in a nutshell the...

Thanks for the prompt response. Please elaborate on your advise as am only a DBA and have no idea of VB . ive never done this sort of formatting before . was only asked if this is possible with SSIS otherwise how else do u think this can be done as the excel spreadsheets need this kind of...

Hi I am trying too build SSIS package for ETL with an access database after migration . A Collection tool was written that gets the data from excel and transforms / formats , then loads into access. Ive put here the part of the VBA code used in the tool . Task at hand: I need to be able to...