Hi Al

Sorry, my misstake! It seems that this function is new in SQL Server 2008.

Greets

Flo

Hi

Only a suggestion:

Maybe you select only one value from INSERTED instead of working with the bulk set of data within?

Greets

Flo

Hi

Yet another way

[font="Courier New"]

DECLARE @sql NVARCHAR(MAX)

SET @sql = ''

SELECT @sql = @sql + CASE WHEN LEN(@sql) != 0 THEN 'UNION ALL ' ELSE '' END + 'SELECT * FROM '...

Hi Justin

What are the criteria to aggregate the time spans?

Greets

Flo

Thank you for translation! In my company the "OP" is the "operational process" but I've been quiet sure that you have been talking about something else ;).

Greets

Flo

Hi Jeff

Sorry for the stupid question... What means "OP" ? Sometimes I hate all these acronyms :w00t: ...

Thank you

Flo

Hi Jeff

Sure the xp_cmdshell is part of the master. First I saw the error messages of the BCP and I thought this is the only problem.

Thanks for the correction!

Greets

Flo

Hi Jeff

He said:

I just did not read the part with the anchors 🙂

Greets

Flo

Hello

Just read the error messages 😉

Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].

SQLState = HYT00, NativeError = 0

Error = [Microsoft][SQL Native...

Mohit (3/7/2009)

---

Compression would be an option for you.

I am not sure how well backups compress with standard compression tools; but tools like RedGate Backup work nicely to compress it before...

Hi

The (non-)uniqueness is a commo problem. Maybe after fixing the problem you should think about an unique index on device table identifier/user_id.

Your current case:

* First you have to identify the...

Okay, my interpretation 🙂

If you need the columns of a table:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'yourTableName'

BTW:

You should avoid SQL keywords as table or column names (object, master).

Greets

Flo

Hi % 🙂

ab5sr (3/7/2009)

---

The old style outer joins are not allowed, but equi-joins, which are equivalent to INNER JOINs, will probably never be removed; if you did, you'd have to...

Basically they have the same job but...

Sure NULL values will not be included if you join...