Okay, now I understand. Sorry, it's a little late here 😉

Proposal if the data to be exported are not too much:

* Insert the result of your procedure into a global...

Hi Eric

The NOLOCK may be your problem if there are very much data manipulation while your statement is running. Maybe have a look at:

SET TRANSACTION ISOLATION LEVEL SNAPSHOT

Greets

Flo

Hello J-F

If there is no possibility to request the data existence since procedure execution you may have to use the SQLCMD. It's just a little command line SQL tool which...

Hi

Here a little example:

[font="Courier New"]DECLARE @lookup TABLE (id INT, code VARCHAR(100))

DECLARE @facts TABLE (code VARCHAR(100), lookup_id INT)

INSERT INTO @lookup VALUES (1, 'a')

INSERT INTO @lookup VALUES (2, 'a')

INSERT INTO @lookup VALUES...

Hi

You have had too less quotes after the SUBSTRING. Now it should work:

execute ('

DECLARE @object sysname,@sql varchar(100)

SET @object = ''P_adv_person''

set @sql...

Hello J-F

Maybe use sp_executesql to get information dynamically if there are any values within the table:

[font="Courier New"]

-- =============================================

-- Author:      Jean-François Bergeron

-- Create date: 2009-02-20

-- Description: This procedure is used to...

Thanks for the feedback!

You're welcome 😉

Lowell (3/11/2009)

SQL server does not natively have a rollback after x seconds functionality. because a database needs to preserve ATOM-ocity, it's an all-or-nothing scenario, whether it takes sub-one second...

Hi GSquared

Thank you for your feedback!

Currently I'm using the single INSERT syntax. The main main benefit of the UNION syntax sure is the fact that all data become inserted or...

Hi Christopher

That also was my first suggestion, but if you have a look he needs exactly the opposite like a of "fn_varbintohexstr" like a "fn_hexstrtovarbin" 🙂 . But this is...

What's the data type of the destination column?

Game, set and match to Michael!

🙂

Greets

Flo

Hello

I would advice to not change the collation of your table columns! I may run into problems if you use another collation than the servers default collation. Just use the...

Hi

If you found a solution maybe post it (or a link) here so other people with same problem may get a solution too ;).

Greets

Flo

Hello

It is not possible to store only time values within DATETIME columns. With SQL Server 2008 there are new data types for DATE and TIME but not since SQL Server...