Viewing 15 posts - 286 through 300 (of 1,183 total)
crackbridge, kindly let us know if our solutions have answered your question.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 27, 2011 at 12:44 pm
The 'ID' column in the Generation CTE is an Alias for the Mother and Father fields in the source table. You can also write it like this ...
-- Create the...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 27, 2011 at 11:46 am
EDITED: and going further with Ninja's approach ...
;WITH
ListWithRows
AS (SELECT
(ROW_NUMBER() OVER (ORDER BY id)/5)+1 as rowNumber
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 27, 2011 at 11:05 am
As Gsquared said. "It depends"
But if you just want to avoid the error message then use NULLIF:
declare @test-2 varchar(30)
Set @test-2 = ''
--Set @test-2 = '2009 12 17 22 31 00...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 27, 2011 at 10:35 am
Not sure which CD it's actuall on. Either one should bring up the same install menu. Just select Client Tools and you'll be fine.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 27, 2011 at 10:15 am
Search BOL for the "OVER" clause and "ROW_NUMBER"
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 24, 2011 at 11:04 am
All good advice above.
I'd add ....
- Create a database that holds your personal finances, movies or song list.
- Visit this site EVERY DAY, read questions, post questions, etc... The knowledge...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 24, 2011 at 9:42 am
I only post this as it is related to your request and although it may be more complicated, it does allow for more functionality... 🙂
Go HERE ->http://www.sqlservercentral.com/articles/2824/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 24, 2011 at 9:31 am
GilaMonster (5/18/2011)
Grant Fritchey (5/18/2011)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 18, 2011 at 7:08 am
Red-Gate SQL Data Compare[/url]
and
They work magic! 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 17, 2011 at 8:24 am
Please check out the article in my signature and provide us some DDL and sample data. That makes our help that much easier to provide to you for free. 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 16, 2011 at 11:58 am
This is the most recent code I have. It may need some tweaking for 2008, I've not tested it on '08.
http://www.sqlservercentral.com/articles/Development/2824/%5B/url%5D
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 16, 2011 at 11:12 am
Jeff Moden (5/15/2011)
vilonel (4/8/2011)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 15, 2011 at 9:01 pm
Sorry, this is SSAS and not my cup of tea. (yet)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 11, 2011 at 2:04 pm
It almost sounds like you're asking how to write your query to get weekly/monthly data.
Can you post the code you're using for the daily info?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 11, 2011 at 1:25 pm
Viewing 15 posts - 286 through 300 (of 1,183 total)