Viewing 15 posts - 376 through 390 (of 1,183 total)
in the report server, browse to your report and then select the subscriptions tab > new subscription ...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 16, 2010 at 8:22 am
Red Gate has a LOT of DB tools, and Dependency Tracker is one of them.
Free for 14 days.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 14, 2010 at 6:20 am
vba-dev (5/17/2010)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 17, 2010 at 1:47 pm
This may not answer your question directly, but may offer an alternative solution if you can't get the answer you need elsewhere....
http://www.sqlservercentral.com/articles/Development/2824/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 13, 2010 at 7:08 am
and the question is.....?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 15, 2010 at 8:04 am
In your ODBC setup/properties, make sure you have the default database set to the correct DB. Sounds like you have it set to be master.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 13, 2010 at 11:46 am
Create a job that runs every 60 minutes that checks the date/time and send your response from there.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 13, 2010 at 8:59 am
select * from personnel
where hiredate >= '20080415'
enclose the date in apostrophes '
😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 13, 2010 at 7:30 am
It doesn't APPEAR to be in the proc. One of your functions maybe?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 9, 2010 at 8:33 am
itskumar2004 (4/9/2010)
I recommend that you use the Search feature on this site before you post in the future.
http://www.sqlservercentral.com/articles/Date+Manipulation/69694/
I did search the site and found this article but...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 9, 2010 at 8:23 am
Try
HAVING DIRECTORATE_CODE LIKE CASE WHEN @Directorate = 'ALL' THEN DIRECTORATE_CODE ELSE @Directorate END)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 9, 2010 at 8:05 am
Do you have a batch terminator "GO" at the very END of the procedure and function code window?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 9, 2010 at 7:53 am
I recommend that you use the Search feature on this site before you post in the future. 😀
SELECT DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0)
Can be found from yesterday's article here --> http://www.sqlservercentral.com/articles/Date+Manipulation/69694/ 😉
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 9, 2010 at 7:19 am
Jeff Moden (4/7/2010)
Jason Selburg (4/7/2010)
test for numeric:ISNUMERIC(LEFT(yourFieldName,1)) = 1
Heh... you sure about that ol' friend?
SELECT ISNUMERIC(LEFT('$Howdy',1)),
ISNUMERIC(LEFT(',Howdy',1)),
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 8, 2010 at 6:26 am
shannonjk (4/7/2010)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 8, 2010 at 6:25 am
Viewing 15 posts - 376 through 390 (of 1,183 total)