Hi Guys,

If the City's are grouped (which is how I am reading this) say by Region - something like that. Wouldn't it be as easy to use two key columns...

Did I miss the Sequel Server TSQL bit of this thread?

Have fun

Hi Guys,

I think you will find the reason for the dynamic sql error was that @usr_id is numeric. You will need to CAST / CONVERT it before adding it...

Hi,

You want all the users to be presented vertically?

Yeah, only users associated with those specific EventIDs and FieldIDs...

Are you looking at throwing 0 - n EventIDs and 0 - n FieldIDs at this one query and returning the data the same as in Carls last post e.g:

1 Item          ...

Hi Sahana,

In your original post you asked about selecting the result of a dynamic query into a variable. Here is an example using sp_executesql

DECLARE @no1 INT

SET @SQL =...

Hi,

It should be easy to create a stored procedure that accepts a parameter from your script.

If you post the full script, i'm sure we can point you in the...

You could simplify:-

SELECT  TOP 1 *

FROM Contact C

INNER JOIN ContactPoint CP ON C.ContactID = CP.ContactPointID

But, just out of interest - why would you want to only return 1 row when...

That will kill this thread - it will take us mere mortals two weeks to decipher it

Might seem a silly question but - you go live and you have your neatly ordered, no gapped PK's.

Say you have PK's 1...

Hi Gordon,

Two threads with similar topics.....

I have achieved the same thing on numerous occaisions using a sproc I found on here many moons ago. Just create the sproc, give it...

Hi,

Two threads with very similar topics......

You can also use a string with delimiters. I found this on here about a year ago and have used it for allsorts ever since......

Just...

Hi Delpiero,

Are you sure your errors aren't coming from not cast / converting @Prod_ID? You shouldn't have too many problems adding double quotes...

Hi David,

Yes there are limitations and 'quirks' involved with sequels encryption functionality. I haven't yet found a way to decrypt......

Rather than maintaining two different procedures, would it not be easier...

Forgot to mention - these are  "undocumented"  features. Use at your own risk.......