Viewing 15 posts - 1,756 through 1,770 (of 1,920 total)
How about this?
;WITH SUM_CTE(K, SUM_AMOUNT)
AS
(
SELECT
K, SUM(MONEY) SUM_AMOUNT
FROM
AAA
GROUP BY
K
)
SELECT
K,
...
April 16, 2010 at 9:15 pm
Glad to have helped you and happy that your issue is resolved 😉 😎
Cheers!!
April 16, 2010 at 7:00 am
Malavika, NO LOCK is a TABLE HINT which instructs Query Optimizer (QO) to do a thing in a different way from the way QO actually planned to do..
You can learn...
April 16, 2010 at 6:56 am
Yes we can, i have had 2005 and 2008 installed my machine 🙂
April 16, 2010 at 6:49 am
Cool, Paul! 🙂
Am not at my desk right now, so when i reach upstairs, i will work on your ask mate 🙂
Meanwhile, as u said , keep trying :cool:!!
Cheers!!
April 16, 2010 at 6:46 am
Paul White NZ (4/16/2010)
COldCoffee (4/14/2010)
...i am giving u a vague and rogue code...Rogue code is right ;-).
LOL, 😀
Yes there are other ways in doing it.. I will let u know...
April 16, 2010 at 6:42 am
Raunak Jhawar (4/16/2010)
SET ROWCOUNT 10
Oh ok, u were talking about SET ROWCOUNT only!! OK, i thot u were mentioning about @@ROWCOUNT 😉
Thanks for your time and reply guys... I will...
April 16, 2010 at 6:41 am
Hello paul, dont feel embarassed ..
Did u try using my code, Paul?
April 16, 2010 at 6:39 am
Thanks Mate!!
Can u provide me a sample of using @@ROWCOUNT to filter the result set?
April 16, 2010 at 5:46 am
How about this code buddy??
This will select the rows of a column that dont contain characters from 0 to 9 and a to z
DECLARE @STRING TABLE (STRING VARCHAR(100))
INSERT ...
April 16, 2010 at 5:46 am
Hi Buddy,how about you going through this following article and helping us help you?? 🙂
CLICK HERE FOR FORUM POSTING ETIQUETTES - JEFF MODEN[/url]
When u do so, i am sure a...
April 16, 2010 at 5:39 am
miss.delinda (4/16/2010)
It return error as follows,Msg 2627, Level 14, State 1, Line 37
Violation of UNIQUE KEY constraint 'tPosi01'. Cannot insert duplicate key in object 'dbo.#tPosi'
Yes it will.. look at your...
April 16, 2010 at 5:23 am
Thanks Gianluca.. what if i dont have a order by clause? still the top operator is processed only after getting the result set?
Do u think SET ROWCOUNT will be...
April 16, 2010 at 5:10 am
Try this then buddy...
DECLARE @SQL VARCHAR(4000)
SET @SQL = ''
SELECT @SQL = @SQL + 'EXEC MASTER.SYS.XP_CREATE_SUBDIR N'''+ COLUMN_NAME +''''+ CHAR(10) FROM TABLE_NAME
PRINT @SQL
Tell us if this code worked for...
April 16, 2010 at 3:04 am
Hey Delinda..
Here is the code for you.. this will update if an match is found and will insert if no match is found between the tables..
Tell us if this worked...
April 16, 2010 at 12:05 am
Viewing 15 posts - 1,756 through 1,770 (of 1,920 total)