Viewing 15 posts - 11,476 through 11,490 (of 14,953 total)
Your CTE looks like it should work. Is there a problem with it?
January 20, 2009 at 11:39 am
A login trigger can handle that kind of thing, but be very, very careful about how you write it, because mis-creating one of those can do really bad things, like...
January 20, 2009 at 11:38 am
r.hensbergen (1/20/2009)
CREATE PROCEDURE sp_GetTasks
@colname nvarchar(50),
...
January 20, 2009 at 11:35 am
So, within packages, you have sub-packages as products? That's what the CTE seems to indicate. Is that correct? (Makes sense, just making sure I'm not missing something...
January 20, 2009 at 11:27 am
The problem isn't directly the code in the query. It's that there's data in the timestamp field that SQL can't convert to a date.
If you select from that table,...
January 20, 2009 at 11:24 am
What you're asking for is a very, very simple Select statement. Is there something more to this, or do you not know how to write Select statements?
January 20, 2009 at 11:18 am
Charles Kincaid (1/20/2009)
January 20, 2009 at 11:14 am
Jason Shadonix (1/16/2009)
I used to work for a not-for-profit company that had SQL Server and Access, but no decent devleopment tools. (Couldn't/wouldn't pay for decent MS tools,...
January 20, 2009 at 9:48 am
On the question of testing the answers so you understand them, I highly recommend a proof-of-concept environment. I keep a database named "ProofOfConcept" on a dev server. Very...
January 20, 2009 at 9:31 am
Jeff, I think the basic point of such questions is that data sequentiality matters in some cases, and it's something that SQL (and relational databases in general) are supposed to...
January 20, 2009 at 9:13 am
Max (1/16/2009)
Just thought, have you checked if there's a performance gain in using IF EXISTS( SELECT blah FROM tblBlah WHERE Client_ID\Name = [@Client_ID\Name]) THEN UPDATE... ELSE INSERT...
The problem with that...
January 20, 2009 at 8:59 am
TheSQLGuru (1/19/2009)
January 20, 2009 at 7:33 am
Jeff Moden (1/17/2009)
...CLR's are better at most RegEx and file handling. With those two exceptions (so far)....
The other place I've found CLRs to be "better" is using CLR as...
January 20, 2009 at 7:14 am
Matt Miller (1/16/2009)
January 16, 2009 at 3:16 pm
Jason Shadonix (1/16/2009)
Hey! How come nobody is mentioning how good Access is!? :hehe:
It's great for single-user stuff. But price-for-price, it can't compete very well with SQL Express...
January 16, 2009 at 3:10 pm
Viewing 15 posts - 11,476 through 11,490 (of 14,953 total)