Search results for query: *

Hello all, CR 2008, SQL Server 2005 I've pored over the threads on CR looping, have tried the various do/while and reset/accum/displ formula approaches, plus subreports, and nothing is working - and I'm stuck. My data set: publisher, author, title, date, genre. I simply want to loop through...

CR 2008 Hello all, I can't seem to find this covered in another thread & I feel silly asking it, but here goes: I simply want to loop through all the values for a given field before jumping to the group footer. Like so: Value 1 Value 2 Value 3 But it will print Value 1, then the group 2...

I have a mystery on my hands. I need to disable a company-wide System DSN. It's the same DSN on every computer, using the same SQL Server 2005 authentication login account. Initially I thought, I'll just remove the SQL Authentication account used in that DSN entry on all the computers. So I...

Hello CR experts, CRXI MS SQL Server 2005 I've been going round and round on a problem over the last week and am at my wit's end! It must be a simple setting I've overlooked. I simply want to pass a number to a SP, and use that value in a WHERE statement, followed by an INSERT. I have a main...

Hello regex experts, I have text files in which I am conducting a regex search. I want to find all instances of two consecutive strings that end in the number 1, *except* for those that are duplicates. Each string is a 13 character alphanumeric string followed by a DOS line break. It doesn't...

Hello experts, I've got a UDF that should simply count the number of objects in a container. However, I cannot pass the container ID or any container info to it - only the ID of one object. So I want the UDF to do this: Find the container it's currently in, AND do a count of ALL other objects...

Hello all, SQL Server 2005. I have a query where I want to see if any of the values of one field in one table appear ANYWHERE in the field values of one field in another table. Here's what I have so far: select id, idnumber from table1 where cast(description as varchar) in (select sidnumber...

This sounds simple - and perhaps it is - but I cannot seem to wrangle a query around this. I have a table like this: id displayorder --- ------------ 71398 1 81545 1 81545 2 81545 1 71398 2 11620 1 11620 2 11620 3 ...and I simply want to select the rows where a given id has a...

Hello experts, I have a bibliography to produce for a client, using the Chicago Manual of Style. lbass provided an excellent solution I adopted to show multiple authors on a single line (see http://www.tek-tips.com/viewthread.cfm?qid=1210308). However, when a book has a second author, the...

Hi experts, CR 8.5/SQL Server 2000. I thought I knew how to do this but I've been pulling my hair out, I'm stuck! I want to print out basic book information, like so: Author 1 Name Author 2 Name (if exists) Book Title Place Published, Dated The problem is that instead of the above format, I...

CR 8.5 SQL Server 2000 Hello CR experts, I've scanned, searched, dug, and tried to find someone with the same issue but no success. I have a stored proc: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS OFF GO ALTER PROCEDURE myProc AS DECLARE @filepath varchar(250) BEGIN INSERT...

Hello SQL experts, I have a simple task, and despite my forum searches and Google searches I have not yet found a solution that "clicks" for me. I have roughly 1300 rows, which is a subset of a table (items), where one field "itemNumber" (char (42)) needs to be incremented by one for each of...

Hello all, I have a simple query that is just about to drive me nutty. I simply want to select the records in 1 table where the occurrence of a field value is limited to once. This query does NOT work - and I don't know why. It returns all the rows where Ranking isn't only 0 (ranking = 0...