Search results for query: *

Thanks I'll try that.

I have a string parameter called PlaceName this works for single value p.Name = '{?PlaceName}' but I want a multi select and this is erroring AND p.Name IN '{?PlaceName}' I've also tried AND p.Name IN ('{?PlaceName}') and it errors too help please Linda

Perfect thank You. if it is not mandatory then we can still do it but not have to race to meet a quick deadline Linda

I've been told I need to bring all my SQL code up to ANSI standard before we move to SQL 2012. Currently most of my joins are defined in a JOIN statement and not the WHERE clause. my question is can I just say TABLE1 JOIN TABLE2 ON .... or must I say TABLE1 INNER JOIN...

At minimum I had to have upgraded tools. My supervisor was told otherwise so I had to try it out. We're in the process of upgrading to 9.1 but in the interim we don't want to be unsupported for 8.9 so we're checking out our options. unfortunately it didn't work.

looks like a good active list - thanks

thanks looks mostly JD Edwards though

We are in the process on upgrading our HRMS system to 9.1 from 8.9 but running into problems so the project is taking much longer than expected. Oracle has said they will stop creating 8.9 tax updates soon and therefore we want to start using the 9.1 tax updates on our 9.1 client. My...

I'm a very newbie PeopleSoft programmer and need to find the Update Plan for Tax Updates. I searched but no luck

A user enters their report format into a derived field. In my SQR I'm trying to determine what they picked but the SQR does not recognize the table name - can I not use derived fields in SQR? My real problem is that the PDF version of the report prints a quarter inch to the left and prints on...

I have a table full of registrations and more are inserted daily. I need to hash the current passwords and the new coming in. I'd like to use the SQL hashbytes function to hash the current records but don't know how to hash the new records thru vb.net I've seen a few methods in vb.net but...

I can't use comma delimited because there is commas in the data. I was able to get my code to work when I created a tab delimited text file and removed the double quotes it added. thanks for your help.

thanks this is my current code [code] BULK INSERT . #morecheques FROM '\\server\path\Test_Subsequent.csv' with ( firstrow = 2, fieldterminator = '\t', rowterminator = '\n' ) [\code] it doesn't error but it tells me 0 rows affected.

I'm trying to use a bulk insert it doesn't error it just says 0 rows affected. when I used SSIS I couldn't find the package in SQL Management Studio. If I saved it to my desktop it errored when trying to run - sorry I don't remember the msg, something about permissions

I need to import external data - daily for about 6 months. I'd like to automate this process. I've tried bulk insert, openqueryrow, ssis --- nothing is working - any ideas.

I have a csv file and am trying to insert it into a table it doesn't error it just says 0 rows affected. I am signed on to SQL with SQL Authentication BULK INSERT database.dbo.table FROM '\\Studebaker\itpmdocs\Business_Proc\Cheque\Test_Subsequent.csv' with ( firstrow = 2, fieldterminator...

thanks

oh okay - you were referring to scheduled jobs. thanks

what is a jobstep? I did determine that I can choose ANSI when saving but I'm trying to automate as much as possible

I need to store the results of a query in a fixed length ANSI text file. I'm using SQL2005. Any ideas ? I know I can do a SaveAs on the file but I need to run this daily for 6 months and am trying to automate as much as possible.