Database

jadughar wrote:

I would like to know how to create a view in Access???

jadughar wrote:

In SqlServer there is a folder "Views" where u can create views in a very simple way.

jadughar wrote:

Searching with google i found that in access are used sql queries instead of views, but didn't understand well.

SELECT * from table where subpart_id IN (SELECT subpart_id FROM parts_table where part_id='1001')

Hiren Solanki wrote:

Your question is not quite clear on what you want to exactly achieve.

liquid_ wrote:

Is it possible at all?

USE [AdventureWorks]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER function [dbo].[fn_Join](@managerID int)
returns varchar(max)
AS
BEGIN
DEclare @ret varchar(max)
SELECT @ret = SUBSTRING(
(SELECT ',' + s.Title
FROM HumanResources.Employee s
WHERE ManagerID = @managerID
FOR XML PATH('')),2,200000)
RETURN(@ret)
END

select distinct ManagerID,dbo.fn_Join(ManagerID)
from HumanResources.Employee
WHERE ManagerID is not null

liquid_ wrote:

There is no straight way to create function or procedure or I don't know about it.

WHERE Land_use_code LIKE '%R%'

new SQLCommand("...WHERE (Land_use_code LIKE '%" + Landusecode1 + "%'");

WHERE Land_use_code LIKE '%@Landusecode1%'

Land_use_code LIKE '%' + @Landusecode1 + '%

Joe Stansfield wrote:

From the look of it, the original
Land_use_code LIKE '%' + @Landusecode1 + '%
is the correct way.

SELECT File_Name, PID, Address_1, Address_2, Locality, Municipality, Postcode, Sale_date, Sale_price, Total, Capital_value, Land_area, Land_use_code, Room_count, Building_area, Construction_year, Wall_construction_code, Roof_construction_code, Land, Rate_1, Val_Ref, Source FROM vSaleSearch 
WHERE (Municipality = @Municiaplity1 OR Municipality = @Municipality2)
AND (Locality LIKE @Locality + '%' OR Locality = @Locality1 OR Locality = @Locality2) 
AND (Land_use_code LIKE '%' + @Landusecode1 + '%')
AND (Sale_price >= @Sale_Price1 )
AND ( Sale_price <= @Sale_Price2) 
AND (Sale_date >= @Sale_Date1) 
ORDER BY Sale_price

Joe Stansfield wrote:

If I enter R%%, I will get all records.

Joe Stansfield wrote:

I am using C# Visual Studio 2008 and the dataset query designer.