Viewing 15 posts - 4,216 through 4,230 (of 9,722 total)
Koen Verbeeck (7/9/2012)
These are the types of bugs that can drive you really mad 🙂
Tell me about it!
Sure enough, same issue on the other packages that are having the exact...
July 9, 2012 at 5:27 am
Oh, for the love of ...!#(*%$#W$
I think I just found out what the issue is. EDIT: Forget the screenshots.
I have a file that comes over from a vendor named MyFile...
July 9, 2012 at 5:06 am
GilaMonster (7/6/2012)
July 9, 2012 at 4:21 am
mehmet.erbay (7/8/2012)
Hiuse
"SET ANSI_WARNINGS OFF"
in your stored procedure
Can I ask what makes you think this will work?
July 9, 2012 at 4:07 am
You said nothing about distribution, so here's a link. Check everything:
July 6, 2012 at 12:33 pm
tim.cloud (7/6/2012)
For my business, it begins on the first day of October and ends on the last day of the following September.
In addition to what everyone else has already added,...
July 6, 2012 at 12:31 pm
What error is it giving you?
I'm betting the distributor is still set up. Or the subscribers.
July 6, 2012 at 12:15 pm
I don't know how you can add an entire job history, but you can check the success / failure of a job and its individual steps by querying against sysjobs,...
July 6, 2012 at 12:09 pm
You may have to make the query dynamic SQL (stored in a variable) and execute the variable in order to get the Body = @tableHTML part of it working correctly.
July 6, 2012 at 12:07 pm
bitbucket-25253 (7/6/2012)
I would suggest reading Jeff Moden's aticle here on SSC at:http://www.sqlservercentral.com/articles/Tally+Table/72993/%5B/url%5D
Making it a clickable link. @=)
July 6, 2012 at 12:00 pm
tim.cloud (7/6/2012)
I need one that will always display the last day of the fiscal year.
What is your fiscal year? And do you keep track of it in other ways in...
July 6, 2012 at 11:57 am
I've never run into an instance where using CAST over CONVERT (or vice versa) has made a difference in code performance. The problem is usually related to the rest of...
July 6, 2012 at 10:49 am
OCTom (7/6/2012)
Brandie Tarvin (7/6/2012)
July 6, 2012 at 6:36 am
Another recommendation:
Learn the data, learn the business.
If you know the data well enough to recognize bad data the instant you see it on a report or in an administrative request,...
July 6, 2012 at 6:24 am
One thing I strongly advise: Do not take this career path just for the possibility of high pay. If you do not like what you are doing, then the pay...
July 6, 2012 at 6:19 am
Viewing 15 posts - 4,216 through 4,230 (of 9,722 total)