Viewing 15 posts - 1,276 through 1,290 (of 5,504 total)
Ninja's_RGR'us (7/13/2011)
krypto69 (7/13/2011)
I talked to the dev and he says he must use that function -
So I'm guessing that this is a dynamic parameter...
July 13, 2011 at 4:17 pm
Or even just
WHERE PC.[PaymentStatus] IN ('AM','P','VR')
July 13, 2011 at 3:58 pm
On the other side: why bother calling a function in the first place instead of hardcoding the values in a subquery?
INNER JOIN
(SELECT 'AM' as [str] UNION ALL
SELECT...
July 13, 2011 at 3:41 pm
table valued yes, but not in-line...
I expected a string delimiter function.... 😉
Search this site for DelimitedSplit8K to find a much better performing solution.
July 13, 2011 at 3:24 pm
Ask the dev to change the function into an iTvF and use the CROSS APPLY approach.
July 13, 2011 at 3:08 pm
Did you consider using the IDENTITY(1,1) option for the column?
(please note that there might be gaps due to invalid inserts or deleted rows).
If you need to have the values in...
July 13, 2011 at 2:43 pm
How is a week defined? And is it the same definition that you use for verification?
It might be an issue where NumberOfUsers of a Sunday is assigned to the wrong...
July 13, 2011 at 10:46 am
Please don't call us "dudes" since this is not a low level chat room. It is a forum for professionals. I kindly ask you to respect it.
Regarding the query itself:
As...
July 13, 2011 at 5:27 am
If you open a table using SSMS, the rows (usually) are ordered by the clusterd index. It's highly recommended to add an ORDER BY clause to the SQL string returned...
July 13, 2011 at 12:50 am
Frankie-464050 (7/12/2011)
Thanks for the link. Any way to get around this via hints or ?
Yes. Read the article Gail pointed you at. 😉
July 13, 2011 at 12:47 am
Something like this?
ALTER PROCEDURE [dbo].[Userupdate]
@OldName varchar(256),
@NewName varchar(256)
AS
Begin
declare @rows varchar(38),
@msg varchar(2000)
update master set name1=@Newname where cstatus='Y' and name1=@Oldname
set @rows = @@rowcount
set @msg='No. of rows updated in name1 table is ' +@rows...
July 13, 2011 at 12:46 am
"is not working" is just not enough information...
Would you mind posting the error message?
July 13, 2011 at 12:41 am
Please provide all index definitions and thte actual execution plan of the query you're strugglnig with.
July 12, 2011 at 10:43 am
You could create two temp tables in the outer procedure (assuming there is one) and then insert the results into those tables in your testing sproc.
July 12, 2011 at 3:29 am
Do you really receive this message from SQL Server?
Loks like an Outlook error message...
July 11, 2011 at 2:52 pm
Viewing 15 posts - 1,276 through 1,290 (of 5,504 total)