Viewing 15 posts - 19,396 through 19,410 (of 26,484 total)
ifila (8/3/2009)
I am using Config Mgr 🙁I have attached a screen shot.
FYI, not everyone has Office 2007 (or Word 2007) and as I have more than enough things installed on...
August 3, 2009 at 11:02 am
andrewd.smith (8/3/2009)
However, a minor change fixes the problem I think.
WHERE (a.START_DATE = DATEADD(day, -14, GETDATE()))
Here's a variation that removes...
August 3, 2009 at 10:56 am
Not sure if the above actually works. I got an empty result set with this WHERE clause
WHERE
a.START_DATE >= dateadd(dd,-14,getdate()) and
a.END_DATE <=...
August 3, 2009 at 10:12 am
Luke L (8/3/2009)
Lynn Pettis (8/2/2009)
August 3, 2009 at 9:04 am
It would help if you would please provide the DDL for the table, sample data in a readily consummable format, expected results based on the sample data.
For help providing this,...
August 3, 2009 at 8:36 am
CrazyMan (8/3/2009)
This might sound crazy, but just wanted to know what is the background process when we write a...
August 3, 2009 at 7:08 am
naginderp (8/3/2009)
My Situation is that data in table is reduntant or duplicate . So We Need to maintain the Identity Column in Table to maintain...
August 3, 2009 at 7:00 am
Not sure why you would limit yourself to only out of the box components? SSIS is designed to be extensible, allowing you to develop or purchase custom components to...
August 3, 2009 at 6:53 am
zubamark (8/3/2009)
try this:convert(char(10),convert(datetime, 'jul 5 2009 12:00 AM'),101)
Yep. That is the answer that was provided earlier in the thread.
August 3, 2009 at 6:46 am
Jeff Moden (8/2/2009)
Lynn Pettis (8/2/2009)
August 2, 2009 at 9:29 pm
Thought I'd bring this to the water cooler. We talked to Kassondra again today, and she leaves reception tomorrow to actually start Basic Training. She sounded much better...
August 2, 2009 at 7:48 pm
Tejas Shah (8/1/2009)
Its better to use DATEADD(dd,0, DATEDIFF(dd,0,GETDATE())) instead of the conversion.
Because when you use this syntax fro order by, it will order t by date, while in VARCHAR, it...
August 1, 2009 at 6:40 am
Jeff Moden (7/31/2009)
You have had a bit of a tough go...
July 31, 2009 at 8:16 pm
Jeff Moden (7/31/2009)
Lynn Pettis (7/31/2009)
How many times do you plan on posting this???Multiple post, please post responses here.
Heh... not to worry, Lynn. It would appear that a good number...
July 31, 2009 at 8:09 pm
Here is a mighty vague answer for a mighty vague question; It depends.
What are you wanting to test?
July 31, 2009 at 7:37 pm
Viewing 15 posts - 19,396 through 19,410 (of 26,484 total)