OK, off-hand, here is how I would do it (not tested):

use [a]

go

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

CREATE PROCEDURE [dbo].[CrTr]

AS

BEGIN

SET NOCOUNT ON;

declare @cmd1 nvarchar(1000)

set...

CrazyMan (8/28/2008)

---

Thanks mate, this will store some other characters, if i select from the database then i get some other characters instead of actual greek characters, is it possible to...

Helmut Nielsen (8/28/2008)

---

Could you tell me a littel bit more in detail how I can set up thsi parallell execution (for example through SQL Agent jobs)...can I really simulate many...

"GO" is NOT a SQL Server command. It is a client flag/command. In this case it is a flag to SSMA's...

Not unless you have a startup Job or Proc to do it.

Jim (8/27/2008)

---

That works a treat! I just had all the guys in the office standing around watching how awesome that is! Untill we cast the string back to an Nvarchar!...

Tomm Carr (8/27/2008)The only difference is that we are associating the number of mussels shucked during each period with the row that begins the period and you want to associate...

Glad I could help.

Jeff Moden (8/27/2008)

---

rbarryyoung (8/26/2008)

---

Jeff, dude:

Jeff Moden (8/26/2008)

---

SELECT ROW_NUMBER() OVER (PARTITION BY ShiftID, TableID, StationID, EmployeeID, DATEADD(dd,DATEDIFF(dd,0,CounterDateTimeStamp),0)

...

Here's an example of how to generate the hex string:

Declare @cmds Nvarchar(MAX)

Declare @obfoo varbinary(MAX)

Set @cmds = '

PRINT ''This binary string will execute "SELECT * FROM SYS.OBJECTS":''

SELECT * FROM SYS.OBJECTS

'

Set @obfoo...

It's safe, it just does a PRINT and Selects from SYS.OBJECTS.

I'll post how to make in a minute...

Jaya: can you post your code?

Thanks

First there is the ENCRYPTION option for CREATE PROCEDURE.

Secondly, you can take a page from the Injection hackers,

try this:

declare @_ as varbinary(max)

set @_ =0x0D000A005000520049004E0054002000270054006800690073002000620069006E00610072007900200073007400720069006E0067002000770069006C006C002000650078006500630075007400650020002200530045004C0045004300540020002A002000460052004F004D0020005300590053002E004F0042004A00450043005400530022003A0027000D000A00530045004C0045004300540020002A002000460052004F004D0020005300590053002E004F0042004A0045004300540053000D000A00

exec (@_)

I agree Sergiy. Even though I was too late, it is a real pleasure to work on a question or problem that is prepared this well and it is...

SELECT Albums.AlbumID, Albums.AlbumName, Albums.PostedDate, Albums.Views, Resimler.ResimId, Resimler.AlbumID AS Expr1,

...