Hi

Just tried and works on my system:

DECLARE @t TABLE (Ip VARCHAR(20), Txt VARCHAR(30))

INSERT INTO @t

SELECT '10.1.30.48', '3GPM'

...

... http://www.sqlservercentral.com/Forums/Topic709217-149-1.aspx?Update=1

!!!

Hi

Counter question: Why don't you just try?

Greets

Flo

DECLARE @post VARCHAR(512)

SELECT @post = 'Hi, we have some asp code right now that transfers contents of three tables from one server to another. Here is how it works right...

Hi David

Basically it is as simple as you thought. But you have to remember:

* The storage size of the columns grows to twice size

* If you have indexes on the...

Hi

I'm not sure what's the specific question? 😉

Greets

Flo

Hi JL

Try this:

-- Some sample calls

DECLARE @calls TABLE (Id INT, StartDate DATETIME, EndDate DATETIME, Department VARCHAR(10))

INSERT INTO @calls

...

Hi

I misunderstood your initial post. I just tried and can reproduce the same error. Sorry I have no other suggestions. Maybe somebody else can help.

Best wishes

Flo

Hi

Could you please just copy/paste my query without any manipulations and tell me if it works?

As Mark already wrote, if you still get errors, please provide the exact error message...

Glad that I could help! 🙂

Hi

Try this. Use a Tally table to build up your time table and CROSS APPLY to get the current active calls.

-- Some sample calls

DECLARE @calls TABLE (Id INT, StartDate DATETIME,...

Hi

Just tried and works:

DECLARE @t TABLE

(

Id INT NOT NULL IDENTITY,

Country NVARCHAR(100),

PRIMARY KEY CLUSTERED

(Id)

)

INSERT INTO @t

...

Hi Rock

Try this:

DECLARE @t TABLE (name VARCHAR(100), first_name VARCHAR(50), last_name VARCHAR(50))

INSERT INTO @t (name)

SELECT 'hello+world'

...

Hi

It depends on how your inner procedure returns that something was not successfully. Your inner procedure can return a return code which can be handled in your outer procedure.

Greets

Flo

Hi

I'm not sure if I got you, but try this:

CREATE PROCEDURE usp_TestPrint

@text NVARCHAR(128)

AS

PRINT @text

GO

DECLARE @sql NVARCHAR(MAX)

SELECT TOP(10)

@sql =...