I get that, but for my table, I have primary key LocationID, then Location which has:

Johannesburg

Pretoria

East London

Cape Town

Bloemfontein

Rustenburg

Cape Town

Polokwane

Kimberly

Welkom

Now this is what I need...

I'll look at your link thank you

I do have a folder Databases, and even if I try any other folders I still the error:

Directory lookup for the file "path" failed with the operating system error

The thing is when I put them under a folder I still get this error:

Directory lookup for the file "C:\Databases\SQLDevTest.mdf" failed with the operating system error 2(error not found).

Msg 1802,...

Thank I got it, on the path; FILENAME = N'C:\Databases\SQLDevTest.mdf'

I removed Database and left it as FILENAME = N'C:\SQLDevTest.mdf' and it worked.

Now I'm trying to alter it,: ALTER DATABASE [SQLDevTest]...

when I try to create it with SQL Server 2012 I get this error:

Msg 5133, Level 16, State 1, Line 1

Directory lookup for the file "C:\Databases\SQLDevTest.mdf" failed with the operating...

I get error when I run it:

"Cannot use file 'C:\Databases\SQLDevTest.mdf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used....

I don't have a backup

I think I found the answer, it should be

insert into error

select fn.customer_id, fn.customer_name

from final fn

left join staging st

on fn.customer_id = st.customer_id

where exists (select * from staging stg where stg.[status]...

Hi

Yes there is actually nested query:

EGIN TRANSACTION [new_Account]

INSERT CUSTOMER(NAME, CITY, STATE)

VALUES ('Izetta','Greenville', 'AL')

IF EXISTS (SELECT * FROM CUSTOMER WHERE NAME = 'Izetta')

BEGIN

BEGIN TRANSACTION

INSERT BALANCES(AVERAGE_BAL, CURRENT_BAL)

VALUES(1250.76, 1431.26)

END

ELSE ROLLBACK TRANSACTION

COMMIT

BEGIN TRANSACTION

INSERT...

Hi

What I want is a function, that will clean this column, inserting either F or M inplace of AAA and the nulls.

---------

F

M*

M

M*

F

M

M*

Thank you.

Thank you

I actually thought of something else, that I could use NULLIF function then got

CAST(NULLIF([Gross Amount],'NULL') AS DECIMAL(18,2)) [Gross Amount]

with OPTION(MAXRECURSION 0) it just runs forever, I think I have aa circular loop somewhere and need to stop it, I just haven't found out yet how to.

Thank you guys very much. I appreciate all your help a lot.

I have one question, If I input client 1-33, which is Mary, shouldn't I get, in my results...