you do not have to do it in a view or specific sql statement if you are using crystal, you can base the report on a stored procedure.

However, If...

no problem, to be honest, I looked at the three part identifier and I asked myself if you were referencing two different databases. Not sure why I didnt say...

The statements appear to be ok, the error is definitely not related to the return code. I would try the following

Check the foreign key just to make sure the referencing...

can you post the stored procedure CUSTOMERS_PKG$SAVE

i am not sure if using Select Top 1 is getting you the results you expect. Before trying to use the variable in the exec statement why dont you...

to display nulls and Y then use

where (a.History_YN is null or a.History_YN = 'Y')

SELECT a.Contact_info

,b.MEMBER_NUMBER

,c.CLIENT_NUMBER

,a.CONTACT_TYPE_ID

,a.history_YN

FROM FRATERNAL.CONTACTS a

inner join FRATERNAL.CLIENT_CONTACTS a1 on a.CONTACT_ID = a1.CONTACT_ID

inner join FRATERNAL.MEMBER b on a1.CLIENT_ID = b.CLIENT_ID

inner join FRATERNAL.CLIENT c on a1.CLIENT_ID = c.CLIENT_ID

WHERE a.CONTACT_TYPE_ID in ('Email1')

AND b.MEMBER_NUMBER...

you can use the ISNUMERIC function to determine if the string is a valid number and do the processing on those and create exceptions for the ones that are not...

There is a default collation for the server.

There is a default collation for the database (which defaults to the collation for the server)

The default collation for the database will be...

Do you really need to have different collations for the columns, that may have been an error when setting up the tables. look at the table structures and it...

You may be able to alias the table name in the update statement in Oracle but

The table name in the UPDATE can't be aliased in T-SQL or in Standard SQL.

here you go

table testids has two fields

id,newfield

WITH CTE ( ID, List, field, length )

AS ( SELECT ID, CAST(...

not sure where your expired field is, so you will need to add to the appropriate where clause. This query will count the Properties available for a specific LUMunicipality.MainMun,...

I believe you are referring to column aliases and if so you can do it with single quotes,double quotes, or brackets, there is no performance impact.

However, if there are no...

This seems to work for me.

;WITH ROWSCTE(VAL1,VAL2,VAL3,RECORDNUMBER,ROWNUMBER,PAGENUMBER) AS

(SELECT *,ROW_NUMBER() OVER(ORDER BY VAL1,VAL2,VAL3) as recordnumber,ROW_NUMBER() OVER(PARTITION BY VAL1,VAL2 ORDER BY VAL1, VAL2, VAL3) AS RowNumber,

case when...