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:...
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...
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...
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...
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:...
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...
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....
Hello all, I have a fairly simple question. I have a field, and i only want to pull NON destinct records from it. I only want records which...
Hello all, I have until the end of today to dump the content of a view into a non delimited text file. So what i am looking for is the program and...
Hello all, I am trying to query a table and a view. Basically both the table and view have a foriegn key linking them made up from odds and ends....
Hello all i am looking for a formating function, I have been reading the sql server books online about format_string which claims it has syntax but...
Hello all, im in process of doing data cleansing to the data where i work. I am currently working on client phone number converting it from text...
Hello all i was just wondering if sql2000 server supports optional parameters? For example, i have a stored procedure, an old version of my program...
Hello all, I have a view which is calling a function table. I would like the table function to recieve dynamic parameters but my current code...
Hello all, I have been toiling over an issue i have had for a while now and hope that maybe i can get an answer on a few things that would make my...
Hello all, what i am looking to do is select a few records but only return what would be row 2 or row 5. Is this possible? Here is my selection...
Hello all, i am currently working on a vb.net project that involves 20 odd users. I have a central sql2000 server setup for publishing my database...
Separate names with a comma.
