There are many option for saving something so you can read it later. I recently started using Pocket (https://getpocket.com). Pocket, or similar services, might give you that functionality,not just...

Grant Fritchey (6/26/2015)

---

Alvin Ramard (6/26/2015)

---

Any maintenance plans you're running that look at all online databases would have less work to do if you took those databases offline. That might help...

Any maintenance plans you're running that look at all online databases would have less work to do if you took those databases offline. That might help if you only have...

dmarz96 (6/25/2015)

---

This particular report would be ran after the books are closed.

So if it was ran today it would be for period 201505. Most cases this report would run for...

I think I figured out what you're looking for.

Try changing the where clause to:

WHERE c LIKE '%[0-9][0-9][0-9][0-9]%'

mario17 (6/25/2015)

---

Hi, all

How can I do this in TSQL, there are alot of wild chars but I could not find how to count them, in case below I only...

You say you want to run this on a monthly basis, so if I ran this with today's date, what month should the period cover?

fpchavula (6/25/2015)

---

I have been trying to get this condition to be TRUE, but can't seem to get it right.

Any suggestions would be helpful. Thanks.

DECLARE @stopat datetime

SET @stopat = '2015-06-23 02:16'

IF...

dmarz96 (6/25/2015)

---

GOOD DAY SqlSanctum,

Maybe I didn't explain myself correctly, or I'm just confused.

Both fields

@BeginPeriod INT,

@EndPeriod INT

are being used as parameter(s) in my where clause

WHERE TT11.PERIOD >= ''+@BeginPeriod+''

AND TT11.PERIOD...

REPLACE(YourString, CHAR(10), '') would replace the...

You'll have to manually update the connection manager each month.

You could use a script task to split the files into a number of files, one for each year, each one...

As long as they are not being accessed anybody, then they should not be using any resources.

keshab.basnet (6/25/2015)

---

ALTER PROCEDURE [dbo].[p_sub_agent_Grp_report]

@parent_pay_agent_cd VARCHAR(25) ,

@tagno NUMERIC(18,0) =...

Oh RATS!!!!

Guess I'll have to watch the recorded sessions later.

Great!...