I still don't know what to put in the events section - how embarrasing! 🙁

I only want to run the profiler for a section of the VB code - is that possible?

What do I put in the events section?

Sorry JCB - do you have time to do a quick run through of how I link SQL Server profiler to visual studio 2010?

To answer your question John - it works fine in VB. But ideally I wanted to turn the code to a Stored Procedure.

can anyone give me some example working T-SQL2005 code that will work for the functionality I'm trying to achieve (search or filter on particular fields on a web page) ?

Regards

So there is no way of converting vb code to SQL and nobody knows what I should do? 🙁

The 'Don't worry about it too much' wasn't for you John - still need your help!

Errors are the following:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '<'.

Msg 103, Level 15, State 4, Line 12

The identifier that starts with ' saamfilter.Reference, saamfilter.Title, saamfilter.FirstName AS...

Dont worry too much about it!

Does anybody know of there is a tool to turn vba code into a sql statement? U seem to be able to do it the...

I'm still trying to achieve the same search and filter functionality on a webpage, full code is:

<WebMethod()>-

<XmlInclude(GetType(SAAMSubFilter))> _

Public Function GetSubscribersFilter(ByVal fromSearch As...

My programmer boss gave it to me...Considering he has 20 years of experience I was hoping it would work! http://www.sqlservercentral.com/Forums/Skins%5CClassic%5CImages/MessageIcons/Crazy.gif

I'm really just asking is there a way of...

Is there a way I can change minimal things without having to completely rewrite the query?

Admittedly I am - what should I do?

Clearly you didnt get the query as I didn't send it accross:

/****** Object: Table [dbo].[Subscriberstest] Script Date: 02/01/2012 13:26:04 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE...