converting access query to ms-sql view or stored procedure 
Author Message
 converting access query to ms-sql view or stored procedure
I am new here and have a very elementary question:

I have following an access query:

Select ID Name, Affiliation, iif(Name is not null, Name & ", " &
Affiliation, Affiliation) As NameAffiliation)
From tblAddress

Can I convert this query to ms-sql view? and how?
If not, how to write this in ms-sql stored procedure?

Thanks,

Billy



Sun, 30 Nov 2003 00:59:07 GMT
 converting access query to ms-sql view or stored procedure

see the discussion on thread "Problem with IFF" in this group.
Quote:

> I am new here and have a very elementary question:

> I have following an access query:

> Select ID Name, Affiliation, iif(Name is not null, Name & ", " &
> Affiliation, Affiliation) As NameAffiliation)
> From tblAddress

> Can I convert this query to ms-sql view? and how?
> If not, how to write this in ms-sql stored procedure?

> Thanks,

> Billy



Sun, 30 Nov 2003 05:48:21 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Converting SQL-query from Access to MS-SQL Stored procedure

2. Problems With the Converting MS-Access Queries to SQL-Server Stored Procedures

3. Converting MS Access Query to MS SQL Query

4. Convert Access queries to SQL stored procedures

5. converting Access queries to SQL stored procedures

6. Converting Access 2000 Queries which use vb functions to SQL 7.0 Stored Procedure

7. Convert Access queries to SQL stored procedures

8. Convert Access Query into SQL Server 7 Stored Procedure

9. Please help to convert view on views to stored procedure

10. Please help to convert view on views to stored procedure

11. Converting MS Access Query to SQL server query

12. PROBLEMS CONVERTING ACCESS QUERIES TO A STORED PROCEDURE


 
Powered by phpBB® Forum Software