Viewing 15 posts - 8,551 through 8,565 (of 8,731 total)
I don't know if this helped the OP, but it sure helped me to learn more.
Thank you guys.
August 24, 2012 at 8:58 am
After several runs (with consistent results) that might not be enough to prove something real. I found out that the explicit RBAR (from Paul) beated the hidden RBAR from Eugene....
August 24, 2012 at 8:30 am
Paul,
I'm curious. Why would you use a cursor?
Shouldn't it give the worst performance? (at least in my tests it did)
August 24, 2012 at 7:56 am
As posted before, you should give your sample data in a consumable format. This time was easy so I did it for you.
I recommend you to read Jeff Moden's article...
August 24, 2012 at 7:07 am
I might be wrong, but I believe it's not returning the first letter from each element (Declined returns 'R').
I would do something like this:
CREATE FUNCTION [dbo].[FnSplit_string]
(
@List nvarchar(max)
)
RETURNS table AS
RETURN SELECT...
August 23, 2012 at 12:55 pm
Administration is not my forte, so you shouldn't take my advice as the only truth.
But you can use something like this.
declare @cmd1 varchar(500),
@cmd2 varchar(500)
set @cmd1 =
'use ?;...
August 23, 2012 at 12:37 pm
I'm sorry, I got confused.
If you're using Windows Authentication, you should create a Windows group and then create a Login for that group.
That way, you can manage the permissions as...
August 23, 2012 at 12:13 pm
Have you tried making a server role and adding the logins to that server role?
Or you could make a script to create the logins and give permissions.
EDIT: Forget this post.
August 23, 2012 at 11:58 am
The problem was on your conditions to choose the valid end_date.
As it would become more and more complicated, I changed the way it was made. Try to understand what it's...
August 23, 2012 at 8:50 am
REPLACE( string, '0', '')
Use the help or Books OnLine for SQL Server.
August 22, 2012 at 11:36 am
A simple hint:
If you manage to get the SourceCount correct, the rest will be easier.
August 22, 2012 at 9:22 am
DerbyNeal (8/22/2012)
I do have another query though...Any ideas please?
Thanks in advance,
I have an idea.
Why don't you try to use the previous queries as example and show us what you...
August 22, 2012 at 7:13 am
I'm not sure if this is the best approach or if you should divde the query for better performance, but as I said in my previous post: "It's an option"
UPDATE...
August 21, 2012 at 1:04 pm
Check this, it's on the Restrictions part
http://msdn.microsoft.com/en-us/library/bb964719(v=SQL.100).aspx
August 21, 2012 at 12:36 pm
Could you post the desired output?
I couldn't understand how you want it.
August 21, 2012 at 12:19 pm
Viewing 15 posts - 8,551 through 8,565 (of 8,731 total)