Hello all, I am having an issue returning a field from a query and have it be a fixed length of 8000 characters. Here is my code thus far:...
lol, problem solved, didn't realize that i was using UNION and didn't put the replace code in the other UNION'd queries. My bad
Hello Satya, thank you for your reply. I changed my code to the below but it produced an error: REPLACE(cast(notes as varchar(8000)), ' ', ' ')...
hello all, i am exporting the results of a query to a .txt. I am having issues though in removing CRLF from said field. I am currently using the...
thank you for the link, ive read it over a few times but dont know exactly how it works or how i could apply it to my situation. That persons...
hello madduri, i have just finished a large conversion where i had to clean up phone numbers among other things. What i fould usefull was the...
Hello all, i am tasked with taking row data and packing it into one field. So say for example i have a client table with a foreign key to a phone...
I have resolved my issue. Thank you for your time
ok so this is what i have so far, it is giving results but not behaving the way i want it to. Here is my code: declare @Per char(1) set @Per =...
Hello all, I am looking for syntax help on a function. I have a select that returns 2 fields and usually 1-6ish rows. What i want to do is have a...
quote:Originally posted by ndinakar I do it in a similar way..Usually for Updates and Deletes I run the SELECT with the same WHERE condition first...
thank you very much Mohammedu, i will use the transaction code you outlined. As for the database snapshot, i am unfamiliar with what that is. Ill...
luckily i averted a crisis. I luckily just made a backup just before the query. I restored that database and all is good. I am still wondering...
Hello all, i just got myself into a big problem. How do i rollback an update transaction that i just sent? Here was the code i used to update:...
tried it out, worked like a charm. Thanks again!
the fields in question are varchar fields, so i will give this a go and see how it works out. Thanks all!
so this code specifically removes CRLF from any position in a field?
Hello all, I am doing a simple select on a number of fields then exporting to text files. There is one field that randomly has CRLF's throughout it...
would a left outer join be more appropriate than an inner join? If there are extra keys on the key table will that create issues with update using...
Hello all, I have a question about doing an update statment that involves 2 tables; a Key table and the table that is to recieve the key update....
Separate names with a comma.
