Viewing 15 posts - 1,771 through 1,785 (of 5,590 total)
Jeff Moden (2/25/2011)
uf curs ah gots ta haz abito funz hurinder too! 😛
I don't get this 'hurinder" part...
February 25, 2011 at 6:41 pm
GilaMonster (2/25/2011)
ALZDBA (2/25/2011)
It states the magical figure of 100 rows.Does it also state where that 'magical' figure comes from?
I'd be shocked if it did...
February 25, 2011 at 6:33 pm
daveriya (2/25/2011)
i tried sunquery,i cant join them coz i think there is no pk->fk releation between them.nothing is worked
SELECT SUM(num_trans), SUM(spend)
FROM (
...
February 25, 2011 at 2:46 pm
This link should give you some good examples of using subqueries.
February 25, 2011 at 2:12 pm
daveriya (2/25/2011)
i solve first one,but in the second one
Write a SQL query that will display the total number...
February 25, 2011 at 1:52 pm
SpectralGhost (2/25/2011)
February 25, 2011 at 1:46 pm
GSquared (2/25/2011)
I have a really obscure sense of humor
Obscure? Now that's a really interesting way of putting it... 😀
February 25, 2011 at 1:01 pm
Simon Davidson (2/25/2011)
Thanks for your reply. I did try Row_Number but got the same message about window functions. What I didn't know was the WITH syntax, essentially...
February 25, 2011 at 11:54 am
You need to utilize the DelimitedSplit8K function to split the delimited list apart.
You would use it like so:
SELECT Num, Item AS Code, [Start Date], [End Date]
FROM #TEST t
...
February 25, 2011 at 11:47 am
Looking at this differently, how about using the GetUTCDate() function to return a common date/time?
February 25, 2011 at 10:39 am
;
WITH CTE AS
(
SELECT *,
RN = ROW_NUMBER() OVER (PARTITION BY [ACCOUNT_CODE], [SECONDARY_CODE], [PERIOD] ORDER BY [REVISION_NUMBER] DESC)
FROM #Budgets ...
February 25, 2011 at 10:33 am
Sean Lange (2/25/2011)
WayneS (2/25/2011)
Gianluca Sartori (2/25/2011)
Sean Lange (2/25/2011)
...there is not a table to log against. This is no different than any other variable type.
Not true: operations on table variables are...
February 25, 2011 at 10:04 am
Gianluca Sartori (2/25/2011)
Sean Lange (2/25/2011)
...there is not a table to log against. This is no different than any other variable type.
Not true: operations on table variables are logged, but don't...
February 25, 2011 at 9:51 am
Gianluca Sartori (2/25/2011)
Check this great article by Wayne Sheffield:http://www.sqlservercentral.com/articles/Temporary+Tables/66720/
Thanks Gianluca.
[shameless plug] And if you happen to be going to SQL Saturday #69 in Philadelphia on March 5, 2011, I'll be...
February 25, 2011 at 9:45 am
AJ-636201 (2/25/2011)
Also when we submit a query having a table variable then the query optimizer always assumes only single row
If you are using the entire table (ie. no where clause),...
February 25, 2011 at 9:43 am
Viewing 15 posts - 1,771 through 1,785 (of 5,590 total)