Hi,

When you say you want to add machineID is that so there is a row for each day/machine combination?

If so, you should be able to do something like:

--create our temporary...

That's okay then, the attached file contains a solution using Dynamic-SQL to pivot the data so that the codeIDs from sequences greater than 1 are concatenated. It'll work for up...

Hi,

Is there a defined maximum or a reasonably assumable maximum sequence number?

Brandie,

As a hopeful author myself, I would like to volunteer. The only thing is that I'm away for the next 3 weeks in Canada (I live in th UK), but...

It took me a coffee to work out how 2 and 4 could mean those, and that's all I could come up with! 😀

Lynn,

I believe that the records, 2 and 4, correspond to 1000012...

Any chance of the schema, some sample data, and the query you are running?

Without these noone can really help you.

There are ways to perform SQL injection using hex codes, and in my honest opinion, this where box sounds about as dangerous as it gets.

http://www.webappsec.org/projects/threat/classes/sql_injection.shtml

has some white paper links about...

Hi Ryan,

Allowing free text in to Dynamic SQL; a crazy request!! :crazy:

As soon as you start using Dynamic SQL you open that whole injection can o' worms. The security factor...

Hi guys,

If you wanted to keep this on the SQL Server side, you could use Full Text Search? :crazy:

Try copying the below and see if it works:

Set @sql = 'SELECT a.* FROM OPENROWSET(''SQLOLEDB'',''' + @servername + ''';''NOTREALUSER'';''NOTREALPASSWORD'',''SET FMTONLY OFF;EXEC master.dbo.xp_fixeddrives'')AS a;';

I've tried it using...

It's not about identity, it's specifically about NEWSEQUENTIALID().

http://msdn.microsoft.com/en-us/library/ms189786(SQL.90).aspx

Jabba, can you use PRINT @sql to show a line of code before execution and post that here? I think you need to double up the apostrophes within the string.

You may also need to change your quotes(") to apostrophes (')...

There is a privacy warning in BoL for this function

If privacy is a concern, do not use this function. It is possible to guess the value of the next...