Search results for query: *

Hi, One of my SP's parameter's text spans into multiple lines. But the SP adds the text of the first line only and ignores rest of it. The following SP inserts only the text 'Arithmetic' and NOT 'Arithmetic operation resulted in an overflow.' for the first field of the table in the database...

Hi, Can we write a recursive SQL query? I have a User table. It has ID (primary key), UserType and ManagerID apart from many other fields. I have 4 user types. 1. Admin 2. EBSM 3. Broker 4. Assistant These user types follow hierarchy i.e. an Assistant belongs to a Broker, a Broker belongs to...

Hi, I am curious to know 1. Would it be faster to run a query which accesses multiple tables spanned across multiple databases or the same query which accesses same tables which are all in one single database? 2. What are the various factors that needed to be considered to create multiple...

Hi, SQL Server 7.0 returns 256 characters of a table field with NVarChar 4000 length. Does anyone know why? Here is the sample code: ****************************Code begins*************** CREATE PROCEDURE SQLLengthTest AS DECLARE @STRtEST NVARCHAR(4000) SET @STRtEST =...

Hi, I have 12 picture objects in a sub report. I need to display only of them at a time based on a condition. I am instantiating the report in a VB designer form. I am trying to use the section format event. But couldn't figure out how to access subreport fields from the main report. Does...

Hi, I am calling a crystal report from Visual Basic 6.0. I call a Stored Procedure to get data in a record set. I am able to get the data from the database. But I get error "Unable to Access first record" when I am trying to export the record set data to a file. Does anyone know why I...