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...

bmoynihan way to go for posting the CREATE TABLE and INSERT INTO statements! you are providing a great example for others to emulate! Thank you!

i came late to the party,...

computer forensic investigator KEWL;

obviously I don't need to tell you to only perform work on copies of the mdf and ldf files.

i would definitely grab a trial version of a...

i read the requirement a bit different; that the table in question had to have two specific column names in it to build the sql: I added a where...

this is a very common requirement; what you want to do is search the scripts section for the "split" function, there's several version out there, all can do what you...

i rewrote your query to use the standard INNER JOIN syntax, but I'm confused a bit about the subquery to get the count from LessOrder

take a look at this and...

CREATE TABLE #WHATEVER(

BranchID int,

ClientID int,

ClientActivity varchar(30) )

-------------------------------------

INSERT INTO #WHATEVER

SELECT 1, 135,'Open Account' UNION ALL

SELECT 1, 135,'deposit' ...

each login could connect to your database an unlimited number of timse; as an example, if you've ever had two or more queries going on in SSMS, each "page" has...