Hi John,

will the following query allow me search on any of the fields in the table?

DECLARE

@SubId int,

@CustId int,

@Reference varchar(50),

@CustOrderNo varchar(50),

@Title varchar(50),

@FirstName varchar(50),

@MiddleInitial varchar(50),

@Surname varchar(50),

@Suffix varchar(10),

@JobTitleDescription...

Hi John, sory for the last reply,

Here's my query (with the create table etc)

it appears to work now but I would appreciate it if you could have a look?

Best Regards

Hi everone,

I created the select statement that John advides but when I ran it i recieved the following results (after query):

DECLARE

@SubId int,

@CustId int,

@Reference varchar(50),

@CustOrderNo varchar(50),

@Title varchar(50),

@FirstName varchar(50),

@MiddleInitial varchar(50),

@Surname varchar(50),

@Suffix varchar(10),

@JobTitleDescription...

I forgot to mention there is other data in the table - it starts at 1 and increments by 1!

Ignore that last statement - I got it working, but I ran the following query and it gave me the following results:

DECLARE

@SubId int,

@CustId int,

@Reference varchar(50),

@CustOrderNo...

Hi John,

I ran the select with the following query:

SELECT SubId,

CustId,

Reference,

...

I managed to eplain that completey wrong - how embarrasing!

Here's a better explanation:

Adobe Flex is a software development kit (SDK) released by Adobe Systems for the development and deployment of...

Programming the Website that is - it pulls the data from the DB i'm creating.

So as a (very simple) select, could I create a stored proc using a select satement such as the following without using Dynamic SQL (i've read up on the risks...

Thanks John! 🙂

Thanks for everyone's help - it's certainly solved a lot of problems!

I'm now getting the message 'command(s) completed succesfully which I feel is a good start!! 😀

In response to...

That's fine - I'm just glad I'm getting such quick responses from you! 😀

I'm recieving the following error when I run the SQL:

Msg 102, Level 15, State 1, Line 10

Incorrect...

I did go in yesterday and try a different method and declared the following (below) to use as @parameters i.e SubId = @SubIdParamter but no luck there either:

@SubId int,

@CustId int,

@Reference...

Sorry I'm kind of new to Forums (first post) - I haven't tried the sp on 2008 so I wouldn't know.