Search results for query: *

Yes, we tried the standard method for an access data project, putting parameters in the report properties, but it didn't like it and wouldn't do what we wanted, so this was the solution we got to work. This is my whole procedure. I didn't mention earlier that it also has input parameters...

Yes, only specific columns I would test for nulls.

I have sprocs that execute sql statements stored as a string, i.e.: CREATE PROCEDURE dbo.SprocName AS set nocount on declare @SQL as varchar (2000) set @SQL = 'SELECT yada yada etc.' exec(@SQL) Using the above procedure, I need to be able to check for null values the query may be returning...

Excellent. I had to add additional single quotes to use this inside the @SQL string, but it works. Set @SQL = 'SELECT Stuff(Stuff(FieldName, 5, 0, ''-''), 3, 0, ''-'') AliasName' etc Thanks!

Well, I got around the problem by splitting the field into three pieces in the query and inserting the dashes in the application layer instead. Nevertheless, if it would be helpful to know how to do this in the query for future reference if anyone knows how. Thanks!

Thanks George, but I actually do have a space there in my actual sproc. It just didn't make it into my example above. Good catch, but without the concatenation, the whole thing runs fine.

I need to concatenate into a string used as a select statement that creates a view, and I'm finding it doesn't like the syntax I am using. I already use the same syntax in a case when construct with no problem. Declare @SQL as varchar(2000) Set @SQL = 'Select FieldName From...' etc Declare...

Thanks for your valuable help!

Thanks for the good info. I am runnig SQL2K, but I don't have any need to manipulate or search through the text in any way, so it sounds like Text is the only viable option. It sounds like each text field takes up only 16 of the 8060 bytes available per row (only storing a pointer) while a...

If I'm understanding correctly, using text fields is the way to go. Am I to understand that if the total datalength yielded by the query you give is less than 8060, there's no problem?

Among other fields, there are seven in my table that could potentially contain 8,000 characters each and I am concerned about the memory size that any given row will take. I don't want to go over the memory limit. I understand that the Text datatype actually uses multiple data pages in the...

Excellent. "Datalength" does the trick. Thanks!

How do I query a text field to determine the maximum number of characters entered into it among all the records? Does SQL have an equivalent for a VBA Len() function? Thanks!

"I would like the report to print everyone with a total other than £0.00 in any of those four fields." It sounds like you're just looking for a where clause that says WHERE field1 <>0 OR field2 <>0 OR field3 <>0 etc. Am I understanding your need correctly?

How do I get a pass through query to accept input parameters? I have no problem using the syntax below in regular SQL queries and it prompts the user for the information, but it isn't liking this in a pass through for some reason. --Input Parameters @Value1 varchar(500), @Value2 varchar(2) AS...

That works. I really need to keep it in Excel, though, not Notepad. I'll have to play with it. Thanks!

I need to make a standard CSV file out of a spreadsheet. The spreadsheet is nothing but basic row-headers with values going down. Nothing unusual. I go to file - save as - CSV... it gives me a couple messages I click through, then... the file extension is changed to .csv, but nothing else...

Thanks both for your thoughts. There is no problem opening a multitude of other reports and having them open at the same time; just these three for some reason, which is what led me to suspect some memory in the code is not being deallocated and is clogging up the RAM. The recordset is tiny...

I've learned that releasing object variables may or may not actually deallocate the memory used by them and I seem to be having a problem with too much memory being used up (even though I've closed recordsets and set things equal to nothing). When the segment of code below runs, the reports all...

I'm trying to use a sproc for a report, but it isn't working. The procedure runs, but gives me a message "The stored procedure executed successfully but did not return records" and, therefore, when the report is based on it, it gives me a message saying "Provider command for child rowset does...