SELECT 0 AS ID, -1 AS PARENT_ID, ROOT AS NAME

UNION ALL

SELECT ID, ISNULL(PARENT_ID, 0), NAME

FROM TableName

It's good you have no power to alter the existing table.

Its structure is better...

If you are about to make bulk update of historical data then read again the post from Michael above.

Time difference applied for summer months records should be different from time...

Yes, that's it.

If you don't need WHERE condition just don't add it.

BTW, my script will work correctly not only in winter but in summer as well.

And if they move the...

[created date] + GETDATE() - GETUTCDATE()

Please read Cast and Convert topic in Book On Line.

Especially the part about styles for datetime-to-varchar conversions.

Your answer is right there.

PG, couple o suggestions.

1. Avoid using triggers. At least without a good advice. Your SQL knowledge and technics are not good enough for that.

When every your procedure will return instant...

Jeff, it's so obvious! 🙂

Because:

- they have list of ExpertCategories in separate table with GUID as a PK (because GUID is so cool and so much more advanced comparing to...

You query for different things, so you get different results. Naturally.

Try this:

DECLARE @catuid uniqueidentifier

SET @catuid = '%{FD45C3EE-4A1C-4BF9-8C68-E7085F0EA045}%'

SELECT email FROM tblExperts WHERE ExpertCategory LIKE @catuid

or

DECLARE @catuid uniqueidentifier

SET @catuid = '{FD45C3EE-4A1C-4BF9-8C68-E7085F0EA045}'

SELECT email...

If you need just to run a program in System32 you don't need to include folder in the command at all.

This folder should be registered in PATH variable and cscript.exe...

SQL Server should not be anywhere around System32 folder.

What do you want to do in there?

It's just a "hand made" trace.

Less effective and less accurate. If a connection was open and closed within the same...

So, for some time bigint values were inserted into datetime column?

And now you need to restore them as bigint?

Is it right?

We discussed this matter on this forum several times.

Here are couple of links for you:

http://www.sqlservercentral.com/Forums/Topic18289-8-2.aspx

http://www.sqlservercentral.com/Forums/Topic296166-8-2.aspx

If your files are not very big it's easier to set up linked server connection to text files using ODBC driver.

That driver interpretes quoted values correctly.

Matt Miller (1/19/2009)

---

You should be looking at something like

INSERT into TableA (mycolumns)

select mycolumns

from TableB tb

where not exists (select null from tableA ta where ta.id=tb.id)

update TableA

set whatever

where conditionmatch

Note that by...