Viewing 15 posts - 2,671 through 2,685 (of 5,685 total)
Let me break that down to what I think I understood. I'm going for the simplest format:
1) Find all accounts with a transaction on a date.
2) For that account,...
August 16, 2011 at 4:05 pm
goodguy (8/16/2011)
Anyone home?
Yes and no. Not a small order to contemplate, and in-depth work at the architecture level is usually paid well for. 😉
First off, it sounds like what...
August 16, 2011 at 3:59 pm
tonyppham (8/16/2011)
Evil Kraig F (8/16/2011)
tonyppham (8/16/2011)
Do you know if it's possible with SQL Server 2005 Express since it doesn't have Agent Service?
You can arrange something using the windows scheduler instead,...
August 16, 2011 at 1:48 pm
Are these DML statements constantly morphing, or are they pretty much the same structure with different parameters?
If they're the same structure, have you looked into Service Broker? Pretty much...
August 16, 2011 at 1:46 pm
Correct, and this is the older syntax for joins.
Old way:
SELECT *
FROM tblA AS a, tblB AS b
WHERE
a.Col1 = b.Col1
Is equivalent to:
SELECT *
FROM ...
August 16, 2011 at 12:16 pm
tonyppham (8/16/2011)
Do you know if it's possible with SQL Server 2005 Express since it doesn't have Agent Service?
You can arrange something using the windows scheduler instead, but it's not as...
August 16, 2011 at 12:14 pm
Michael Valentine Jones (8/16/2011)
However, when you add 3 months to November 30, it will return Feb 28 (or...
August 16, 2011 at 12:12 pm
quillis131 (8/16/2011)
Evil Kraig F (8/15/2011)
quillis131 (8/15/2011)
August 16, 2011 at 12:10 pm
Jeff Moden (8/16/2011)
========== DATEADD/DATEDIFF ==========
SQL Server Execution Times:
CPU time = 1326 ms,...
August 16, 2011 at 11:01 am
quillis131 (8/15/2011)
August 15, 2011 at 7:45 pm
Chuck Hottle (8/15/2011)
This is good and simple too.SELECT CAST(FLOOR(CAST(GetDate() AS FLOAT)) AS DATETIME)
I was originally going to call this a bad idea, but I decided a little sample million row...
August 15, 2011 at 5:14 pm
Steve Jones - SSC Editor (8/15/2011)
Craig,
It's not inaccurate. You can sit for the test without having the certs. Multiple people, including myself have done it. You can't get awarded the...
August 15, 2011 at 4:51 pm
Yeah, this won't be pretty, if I've understood this right.
Your VARCHAR(MAX) is storing standard ASCII coding, but also html tags and the like. Here's a problem with that:
<a>ABC</a> and...
August 15, 2011 at 4:48 pm
Jeff Moden (8/15/2011)
You might want to check again... what happens on May 31st?
I'm confused here Jeff, nothing bad happens on May 31 + 3 months. August 31st is a...
August 15, 2011 at 4:37 pm
chandleya (8/15/2011)
August 15, 2011 at 4:32 pm
Viewing 15 posts - 2,671 through 2,685 (of 5,685 total)