Viewing 15 posts - 616 through 630 (of 3,666 total)
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 29, 2015 at 7:47 am
Grant Fritchey (6/26/2015)
Alvin Ramard (6/26/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 26, 2015 at 7:34 am
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 26, 2015 at 7:17 am
dmarz96 (6/25/2015)
So if it was ran today it would be for period 201505. Most cases this report would run for...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 25, 2015 at 3:49 pm
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]%'
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 25, 2015 at 3:37 pm
mario17 (6/25/2015)
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 25, 2015 at 3:15 pm
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?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 25, 2015 at 3:14 pm
fpchavula (6/25/2015)
Any suggestions would be helpful. Thanks.
DECLARE @stopat datetime
SET @stopat = '2015-06-23 02:16'
IF...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 25, 2015 at 3:03 pm
dmarz96 (6/25/2015)
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 25, 2015 at 2:40 pm
wallywizard (6/25/2015)
I read about using the REPLACE command with char(13) AND char(10), but I dont know how to use this. Can anyone please help me?
REPLACE(YourString, CHAR(10), '') would replace the...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 25, 2015 at 2:28 pm
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 25, 2015 at 1:46 pm
As long as they are not being accessed anybody, then they should not be using any resources.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 25, 2015 at 12:43 pm
keshab.basnet (6/25/2015)
@parent_pay_agent_cd VARCHAR(25) ,
@tagno NUMERIC(18,0) =...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 25, 2015 at 12:28 pm
Luis Cazares (6/24/2015)
OMG, I forgot that 24 hours of PASS started today!
Oh RATS!!!!
Guess I'll have to watch the recorded sessions later.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 24, 2015 at 11:36 am
Meatloaf (6/24/2015)
Thank you all, the problem has been solved. What I am using is:SELECT * FROM #ContactList
UNION ALL
SELECT DISTINCT UPPER(LEFT(vchLastName,1)),NULL,NULL,NULL,NULL FROM #ContactList
ORDER BY vchLastName, vchFirstName
Great!...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 24, 2015 at 9:36 am
Viewing 15 posts - 616 through 630 (of 3,666 total)