Viewing 15 posts - 2,416 through 2,430 (of 2,451 total)
jshahan (7/25/2012)
July 25, 2012 at 2:27 pm
Lynn Pettis (7/25/2012)
July 25, 2012 at 2:03 pm
Lynn Pettis (7/23/2012)
July 25, 2012 at 1:23 pm
Gosh, that's quite confrontational.
My sincere apologies if I came off as confrontational; that was not my intent.
I, too, get quite a bit of information on the Internet...
July 25, 2012 at 1:16 pm
Jeff Moden (7/23/2012)
XMLSQLNinja (7/23/2012)
ChrisM@home (7/20/2012)
XMLSQLNinja (7/18/2012)
...There are other ways to do this but using recursion is generally the fastest.
Recursion is the third fastest; CLR > "Quirky Update" > rCTE >...
July 23, 2012 at 10:34 pm
Oky Doky.
Just got back from vacation and wanted to get to this ASAP. I am not optimizing this query, just getting the desired results for now.
First, no UDF needed....
July 23, 2012 at 5:05 pm
ChrisM@home (7/20/2012)
XMLSQLNinja (7/18/2012)
...There are other ways to do this but using recursion is generally the fastest.
Recursion is the third fastest; CLR > "Quirky Update" > rCTE > cursor > triangular...
July 23, 2012 at 3:43 pm
Just got back from vacation and wanted to address this one first...
I must be missing something but I don't see how that recursive CTE (as much as I like...
July 23, 2012 at 2:55 pm
First thought was that we would connect to current db and do updates directly (validating fields before update).
Good Grief! First and foremost - NEVER do that. As a DBA,...
July 18, 2012 at 11:22 am
First, by "count of" sales I assume you mean SUM of sales. Otherwise we'd be looking at a result set a little more like:
WeekEndDate SalesTotal
2011-01-07 1
2011-01-14 1
2011-01-21 1
2011-01-28 1
Lets try...
July 18, 2012 at 10:12 am
Sean Lange (7/18/2012)
See if this article helps. http://www.sqlservercentral.com/articles/T-SQL/68467/[/url]
Jeff's article is certainly a must-read on this topic.
July 18, 2012 at 8:54 am
a2zwd (7/18/2012)
I have a table which holds the running total.
DECLARE @CumCredit TABLE(RowId INT, CustomerId INT, TransId INT, Pts INT, RunningTotal INT)
INSERT INTO @CumCredit VALUES(1,123,121,10,10), (2,123,131,20,30), (3,123,141,15,45)
New resultset which needs to...
July 18, 2012 at 8:32 am
harri.reddy (7/17/2012)
hii need to add my user name into ssms,how to login first in order to add another user.
like sa or what password?
First, a little more detail would help here....
July 18, 2012 at 7:42 am
SQLSACT (7/17/2012)
How would I setup a script to copy files from a shared location on one server, to a shared location on another server?
The extension of the files would...
July 17, 2012 at 9:53 am
dndaughtery (7/17/2012)
I was told someone interviewing me would ask this. In my 7 years of DB Development Ive never had a...
July 17, 2012 at 9:19 am
Viewing 15 posts - 2,416 through 2,430 (of 2,451 total)