Hello!

Which certification were you thinking of doing? I'm currently studying for the MCSA and finding some parts overwhelming even with 5+years experience (albeit I started as an apprentice), I can't...

wendy elizabeth (2/22/2016)

---

Can't each embedded tablix filter the rows they need from the dataset by using a column called report_number? The value in each column will be for each embedded...

naga.rohitkumar (2/21/2016)

---

Hi jeff ,

I have checked that msdb.dbo.sysjobhistory but its not giving the job name not status of the job when it failed

we need the count for number...

Then you need to insert it into an INT column.

A year on it's own is...

Amazing.

mw112009 (2/12/2016)

---

I am not trying to be mean here....

But the real answer is...

"[There is no way to do that in one or several SQl statememts]"

However I found the perfect resource...

Is the log reader agent running? You can check in the replication monitor, or by locating the SQL Server Agent job.

Also, go to the subscription under 'Replication', right click, view...

Assuming create_dtim is a valid date field

SELECT wh_id as Wh,

MONTH(create_dtim) as MonthCreated,

YEAR(create_dtim) as YearCreated,

count(*) as Plan

FROM Backtest

where wh_id in (1,9)

group by wh_id, MONTH(create_dtim), YEAR(create_dtim)

Is that...

Hi MadAdmin,

Thanks for the response. It's an inline TVF (I.e SELECT...UNION ALL...SELECT etc)

I'm currently working on the query performance and am nearly there, but thankyou for offering to help anyway...

By getting 'stuck into performance tuning' - I do mean getting on with tuning the query. Just what I like at 5pm :w00t:

Thanks for the responses everyone - at least...

May have posted this in the wrong section. Apologies.

deleted (misread)

Think I misunderstood your question - sorry! Glad you got it sorted 🙂

Uniform naming convention as opposed to local file path.

So for example, '\\server\c$\folder\file.xlsx' instead of 'c:\folder\file.xlsx'

Are you using a UNC path in your SSIS package?