Just as you posted, no need to call xp_cmdshell.

That's because xp_cmdshell expects an MS-DOS command and you're sending a T-SQL command.

Just another way of doing it.

select *

from dept d

WHERE NOT EXISTS( SELECT 1 FROM empp e WHERE e.dept = d.dname)

Why won't you order by the original orderdate?

In case you can't, try to convert it with a different format in the ORDER BY (such as 120 or 112).

That's correct.

Remember to do it in the correct order.

I believe that you have to add WITH NORECOVERY for every backup until the last log backup restore which will use WITH RECOVERY.

What's exactly your problem?

You could create a trigger for insert

CREATE TRIGGER TI_Locations ON Locations

AFTER INSERT

AS

INSERT INTO _NewLocations (LocationID, LocationName,AreaID)

SELECT LocationID, LocationName, AreaID

FROM Inserted

You could as well try to use the 8k Splitter presented here.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

It will return you a table from which you can do a join or semi-join (IN or EXISTS). 😉

Does this article helps you?

http://www.sqlservercentral.com/articles/T-SQL/63003/

Sean Lange (7/12/2013)

---

WolfgangE (7/12/2013)

---

As far as I've seen you can connect from a Management Studio 2008 to a SQL 2012 instance.

The object explorer might throw some errors when expanding the...

If you're running only on Mondays, these formulas might help you. If the day can vary, you might need an additional operation.

select DATEADD( hh, 7, DATEADD( dd, DATEDIFF( dd, 0,...

Another solution would be to use bcp that will allow you to export tables to text files or import these text files as well.

If you like graphic interfaces you could...

Without more information, I would say you could do it like this.

CREATE function [dbo].[myfunc]

( @a int, @b-2 int, @c money)

returns table

AS

return

select d = (isnull(sum(d.cola),0)+@c) * -1

from (Select distinct c.cola

from tab1...

Thank you for the sample data, however, we're still missing the information for table GLCTA.

Can you post the table definition? I'm afraid that there are some Unicode characters in the data that Excel won't identify.