Viewing 15 posts - 1,066 through 1,080 (of 5,504 total)
The interesting part is:
You can always add a column at the end, but not in between (which makes sense, since the forme is a simple alter table add column).
It seems...
August 26, 2011 at 7:55 am
One more issue:
If you know for sure there won't be any duplicate values you could use UNION ALL instead of UNION. Otherwise SQL Server would have to perform an aggregation...
August 26, 2011 at 4:55 am
A table is qualified by INSTANCE.DATABASE.SCHEMA.TABLE.
Within a single database it's sufficient to use SCHEMA.TABLE (like you did when using dbo.PWR_L_PowerStrips). Some folks even omit the schema...
When using queries across databases...
August 26, 2011 at 4:53 am
What exactly do yo mean by "doesn't work"?
Please remember we can't look over your shoulder nor can we access your system.
If you get an error message, please post it together...
August 26, 2011 at 3:05 am
FreeHansje (8/26/2011)
So, the use of PERCENT is the problem? That's the only difference I notice...Tnx for the heads-up all. I rarely use view design, but I was lazy this time...
Not...
August 26, 2011 at 3:02 am
Like I said before, the PIVOT is unrelated to the total.
But in case some sort of a dynamic pivot is required, I would prefer the DynamicCrossTab as described in the...
August 26, 2011 at 2:47 am
@ColdCoffe: are you sure the sample code in this post is related to the original question?
Seems like it belongs to "the other thread"... 😉
@kavinithi: you would need to wrap the...
August 26, 2011 at 2:02 am
And what are the results of the queries Nija asked you to run?
Please help us help you by providing the information that has been asked for.
If there's a reason you...
August 26, 2011 at 1:53 am
Something like this?
SELECT TOP 1 ID,
Name,
Number,
...
August 26, 2011 at 1:40 am
Why would the following be invalid? (still trying to figure out the business rules...)
--------------------------------------------------------------------------------
A1,1,25
A2,1,100
A3,1,25
A1,1,50
A2,1,100
B1,2,50
B1,2,50
B2,2,150
B2,2,50
Keep in mind, there is no special order of rows unless you can specify it using T-SQL.
So,...
August 26, 2011 at 1:32 am
I agree with Orlando.
Too vague to provide a sound answer at this point.
The only thing I can think of is the output format in SSMS that's causing some confusion.
Where do...
August 25, 2011 at 12:24 pm
Brandie Tarvin (8/25/2011)
Which is the correct color sequence of the average rainbow:A) GBIVROY
B) ROYGBIV
C) DBCXY2
D) There is no sequence to an average rainbow
E) It depends. What is an average rainbow?
You...
August 25, 2011 at 11:14 am
Ninja's_RGR'us (8/25/2011)
LutzM (8/25/2011)
Makes sense.You basically used "returning less than x thousands rows" in the meaning of processing that much data not what ends up as the final result. Right?
I was...
August 25, 2011 at 8:17 am
Makes sense.
You basically used "returning less than x thousands rows" in the meaning of processing that much data not what ends up as the final result. Right?
August 25, 2011 at 7:48 am
The very simple answer would be:
Since I don't have to reference the Product node when getting the value for a UserId (-> T.c.value('UserId[1]','INT') as UserId insteand of T.c.value('Product[1]/UserId[1]','INT') as UserId),...
August 25, 2011 at 7:44 am
Viewing 15 posts - 1,066 through 1,080 (of 5,504 total)