Alex,

You'd just do something like

SET NOCOUNT ON;

INSERT INTO DestTable

SELECT [fieldlist] FROM SrcTable WHERE...

in your stored procedure and then just call it in a job that you schedule.

Alex,

this part: "What I want to do is have the data populate from the nightly run into a SQL table (already created) each night at least 4 rows will get...

Was it removed in 2016? I didn't really ever use it much... just never had a reason to.

That said, anybody know what MS's plans are with reporting? It seems...

First off, this is an Integration Services question. You would create all the steps there and run it via a Job. I think you just posted in the wrong...

Got Google?

http://www.sqldbadiaries.com/2010/10/22/generate-scripts-for-linked-servers/

Faulty reasoning on his part in my opinion. They're just different.

Can't you just change the font color property value to an expression?

This would be easier to pull off in Reporting Services. Is that an option?

I think you're missing a join.

SELECT FirstName

FROM NewRecs n

WHERE NOT EXISTS (SELECT FirstName

FROM ExistingRecs e

WHERE e.FirstName = n.FirstName);

Note the join between NewRecs and ExistingRecs in the...

That would make a great SQL Saturday half-day or full day precon... I just wish someone would put together even part of that. Sure, you can look up the...

If you stripped off the WHERE clause, it would be a valid query in SQL Server. I would convert the parameters to SQL Server, though.

--put in the real field...

I'll see you and raise...

CREATE TABLE OrderList (OrderNo INT, SerialNo INT, OrderStatus TINYINT);

GO

INSERT INTO OrderList

SELECT 1 AS OrderNo, 100 AS SerialNo, 1 AS OrderStatus

UNION ALL

SELECT 1, 200, 3

UNION ALL

SELECT...

Got sample data? If you want a tested answer, please read this article: How to post data/code to get the best help[/url].

Maybe something like this?

SELECT *

FROM OrderList ol

WHERE NOT...

orenk (12/14/2015)

what I like to do is count a column and group by year. Very easy :-),

select count(*) as Anzahl, year(Datum) as Jahr from KdTickets

where Typ = 1 and...

From Solomon Rutzky on Stack Exchange...