running profiler to create a trace is resource intensive, but a server side trace has minimal impact, and can help track down your deletes. search for trace on this site,...

still not clear to me either, can you give a non-pseudo code, concrete example of the expected results?

isn't Crystal still client-server based, so you have to install Crystal on every machine that will run a report, vs SSRS which is a web server HTML based reporting system?...

two single quotes in a row are the "escape" sequence to insert into a quote delimited string:

SET @sqlquery = 'UPDATE Allotuser SET ' + QUOTENAME(@accno) + '=''' + @acc +...

a rewrite of your proc to have better error messaging:

ALTER PROCEDURE [dbo].[USP_UpdateAllotUser]

(

@accno NVARCHAR(5),

@acc NVARCHAR(50),

@userid NVARCHAR(50)

)

AS

BEGIN

SET NOCOUNT ON

BEGIN TRY

IF (@accno '' OR...

ahh now i see; it's kind of obvious.

best practice is to always print your sql before you execute it:

this is the SQl statement your code creates:

UPDATE Allotuser SET ([Acc5])=hello where...

oops... researching now...what was the erro message specifically...error numbers not much help.

i just connected to a SQL 2000 instance and ran this code without errors; it returned the expected value; i don't have a SQL7 instance anymore.

select @@version = Microsoft SQL...

also, i'm rewringing the sql to have proper ANSi joins, and I do not see any relationship for the aliased table APMA:

select distinct

[User],

[Transaction],

...

lots of possible improvements i think are possible.

first, you can get rid of the cursor. that will be a massive improvement.

to help, we need a few things to get a...

it sounds like you have two issues;

first issue, if you have trailing spaces that won't go away,

I'm thinking that the table wce_ilr has two columns Student_Forename and Surname with a...

head_contusion (7/23/2009)

---

In your first response, was I reading your code too literally? I was expecting the string splitting funcition to put strings into the IN keyword. Your second...

here is a specific example with a specific version of a Split() function:

note it returns a table.

Declare @MyString varchar(max)

Set @MyString = 'Amanda,Devin,Sydnee,Valery,Gloria,Cecelia,Caroline,Estevan'

select * from dbo.split(@MyString,',')

--another example

select * from firstnames where...

i've been in the same situation that you are in; the lead programmer only believed that the data was right if he KNEW each row was handled.

For the first couple...

it's just syntax; when you need to update and join on a table, you need an alias and an xplicit FROM:

declare @CustomerList varchar(max)

Set @CustomerList='IBM,Dell,Google'

UPDATE MyAlias

SET Delivered= 1

From purchases MyAlias...