Viewing 15 posts - 1 through 15 (of 42 total)
GilaMonster (1/9/2015)
jeffem (1/8/2015)
using multiple views is very often going to include tables that aren't at all necessary to the core logic of what you're trying to accomplish.
Depending on the view...
January 9, 2015 at 9:33 am
Paul Brewer (1/8/2015)
January 8, 2015 at 12:59 pm
pkapas (12/29/2014)
If you have to rely on getting data from a previous view in...
January 8, 2015 at 9:16 am
mauriciorpp (1/6/2015)
GilaMonster (12/31/2014)Nothing wrong with cross-database queries. Performance-wise they're the same as queries within a database. There may be some security amusement. There are good, valid reasons to split an...
January 8, 2015 at 9:11 am
Very useful, and thanks!
I think I can even learn from this to simplify a script I wrote to script out all existing indexes on a table (which I use for...
June 16, 2014 at 8:53 am
sjimmo (12/27/2012)
input this URL:
---------------------
you can find many cheap and high stuff
Believe you will love it.
What does this have to do with SQL Server Replication? Are we allowed to advertise on...
December 27, 2012 at 9:13 am
Okay, it was foolish for me to have posted confusing code. 🙂
This is not any actual business logic that exists, but rather is a simplified example that causes the error....
December 14, 2012 at 7:21 pm
Eugene Elutin (9/17/2012)
jeffem (9/17/2012)
CELKO (9/14/2012)
September 17, 2012 at 2:44 pm
CELKO (9/14/2012)
September 17, 2012 at 10:09 am
Very nice article! There is a typo:
"164 (Yen sign)" should actually reference 165.
September 14, 2012 at 8:02 am
Exactly what I went with. Thanks!
And thanks, everybody. When I read the first reply that used derived row numbers to join together, I had to look into a mirror so...
July 31, 2012 at 9:48 am
Sean Lange (7/31/2012)
I have to say that this is a very strange requirement. You have a 1:1 relationship between these tables and from what you posted this equates to another...
July 31, 2012 at 9:46 am
This principle worked perfectly. I switched to CTEs so that I'm not changing table structure...
;WITH CTEMap AS
(
SELECT *, ROW_NUMBER() OVER(ORDER BY WonkyID) AS RowNum
FROM #MapIDs
),
...
July 31, 2012 at 9:41 am
jeffem (6/27/2012)
Les Cardwell (6/27/2012)
So, given 66 original districts (Sweden), that resolve into 151 candidates (population count between 5,900-6,000) resulting in 28 new districts (1 single, 16 doubles, and 11 triples),...
June 28, 2012 at 7:39 am
Les Cardwell (6/27/2012)
So, given 66 original districts (Sweden), that resolve into 151 candidates (population count between 5,900-6,000) resulting in 28 new districts (1 single, 16 doubles, and 11 triples), what...
June 27, 2012 at 3:46 pm
Viewing 15 posts - 1 through 15 (of 42 total)