Hi Amira,

In Query Analyzer, go to -> Tools -> Options -> Hit the Connection Properties tab.

Then check the 'Set quoted identifier' box on your machine and apply it.

You should all...

Hi,

Example with your existing code:-

Update ViewWeeklyFormUpdate

Declare @sql nvarchar(4000),

        @RandomisedNumber decimal

 Set Form =

   SET @sql = N'SET @RandomisedNumber = rand() * 2'

   EXEC sp_executesql @sql, N'@RandomisedNumber decimal OUTPUT', @RandomisedNumber...

Hi Guys,

I know there will be loads of abuse for this but had to do it.........

You can make rand work on multiple occaisions in one sp - by using a bit...

My mind is in the twighlight zone.

Another one of those friday feelings... This is what happens when 'they' swop you over from 2 months...

Yep,

Ran perfectly first time.

Results in message window:

(4 row(s) affected)

(4 row(s) affected)

Guys, guys, guys,

Pls take a look at the data, then re-create it. A normal, simple ORDER BY works perfectly well when I run it.

Results (as posted earlier):

RKA10

RKA100

RKA11

RMX10

RMX100

RMX11

RSA12

RSA120

RSA139

RSBH01

As you and I...

Hi Frank,

I dont think the UDF is necessary here - just look at the order the data is being sorted into.

If you replicate the ORDER BY with the same data, you...

Hi Sunny,

Could you pls drop an example of your code in. Must be a bit of a weird one this - I put your data into a varchar field in...

Sunny,

Hate to be pedantic but........

A normal ORDER BY statement such as:

SELECT * FROM tblNames ORDER BY NameFirst ASC

Will select in the order 1st character, 1st and 2nd character, 1st, 2nd...

Give us a clue, what order do you want - Numerical, Alphabetical or something completely obscure.....?

Tyson,

I take it you meant - Right Click 'Query Analyser', then left click 'Properties'.

Just for those of you wondering why you keep getting Query Analyser up.........

Hi,

Sorry, don't get the full idea of what you are trying to achieve with this - could you please expand a little further.....

Sorry matey,

This is a Sequel Server forum - if it works in Sequel 7 - its good enough for me........

Have fun

Without looking into it too deeply (only 'cos I havent got the time at the mo') - I think you need to use the attachments collection of the CDO object library to...

Hi,

You cant access an existing password protected Excel file as it is encrypted.

You will be able to get around this by using an activeX script task to create the file, then pass...