Viewing 15 posts - 4,171 through 4,185 (of 9,715 total)
Lynn Pettis (7/3/2012)
Mr. Celko actually posting a helpful reply!
Already happened once. We're still here.
A little singed, but still here.
July 16, 2012 at 7:56 am
Jeff Moden (7/16/2012)
mtillman-921105 (7/11/2012)
'Guess it's time for me to pu away my aluminum floil[/url] now. MIT has researched the effectiveness of tin foil hats. :w00t:[edited link]
Heh... their testing was...
July 16, 2012 at 7:53 am
L' Eomot Inversé (7/15/2012)
July 16, 2012 at 7:50 am
Is GAH a word? If so, that's my random word of the day.
GAH!
July 16, 2012 at 7:27 am
Don't have the packages kick off child packages. Have the SQL Job run each individual package (even the "child packages") as individual steps that only run if the "parent" package...
July 16, 2012 at 7:23 am
Is it just me or does the last bit of code have an extra single quote mark? Or maybe is missing one?
Also, please explain to me how @last_upload is not...
July 16, 2012 at 7:21 am
EDIT: changed question.
Why are you using LIKEs using wildcards on both sides of the keyword? You do it 3 times.
Also, you added a table to Scott's original query in the...
July 16, 2012 at 7:07 am
Arman Khan (7/11/2012)
I need you help in writing SSRS Expression which counts the Total Values from Start of Month(Date) and GetDate.
For Example:
=SUM(
IIF(Fields!rpt_date.Value = Parameters!RptDate.Value
And Fields!Mot.Value...
July 13, 2012 at 12:40 pm
Post the code inside the window using the IFCodes please. Many of us don't open attachments. Also, post DDL with sample data so we can help you better.
July 13, 2012 at 12:36 pm
More information.
When we call the webservices directly from the service, it doesn't timeout at the 15 minute mark. Only when we call it from the SSIS package does it timeout.
Does...
July 13, 2012 at 12:35 pm
bitbucket-25253 (7/13/2012)
Revenant (7/13/2012)
Lynn Pettis (7/13/2012)
Brandie Tarvin (7/13/2012)
YAY for people who still allow SQL Injection on their servers! (NOT!)http://news.cnet.com/8301-1009_3-57470786-83/hackers-post-450k-credentials-pilfered-from-yahoo/%5B/url%5D
Yes, saw that on twitter yesterday.
Some people will never learn I guess.
I am...
July 13, 2012 at 12:31 pm
YAY for people who still allow SQL Injection on their servers! (NOT!)
http://news.cnet.com/8301-1009_3-57470786-83/hackers-post-450k-credentials-pilfered-from-yahoo/%5B/url%5D
July 13, 2012 at 10:45 am
That is a very good point, Gazareth. Even my query won't run very well if the table is a heap.
July 13, 2012 at 5:32 am
jdbrown239 (7/11/2012)
Can you show us an example of File to Table conversion? (I can't see 4000 only showing up as 0s or 1s).--select eb_recent_high_credit from gdsland where EB_RECENT_HIGH_CREDIT >= 0
eb_recent_high_credit
0
0
0
0
0
0
0
0
0
0
0
0
Note...
July 13, 2012 at 5:19 am
Viewing 15 posts - 4,171 through 4,185 (of 9,715 total)