Viewing 15 posts - 10,771 through 10,785 (of 15,376 total)
CELKO (9/11/2012)
I have a two articles on this topic at Simple Talk. There is no need to throw away performance, maintainabilty and portability to do this.http://www.simple-talk.com/sql/learn-sql-server/values()-and-long-parameter-lists/
http://www.simple-talk.com/sql/learn-sql-server/values()-and-long-parameter-lists---part-ii/
If portability to another...
September 11, 2012 at 8:08 am
christina.honnert (9/11/2012)
September 11, 2012 at 7:52 am
raghuldrag (9/11/2012)
hey friendi am executing dis qury on sql server 2000 only...its not server 2008
But we still don't know what the question is. It has...
September 11, 2012 at 7:21 am
Luis Cazares (9/10/2012)
Maybe this modification to Sean's code will work better:
select *,
LEFT(full_name, charindex('_', full_name)) + RIGHT(full_name, charindex('_', reverse(full_name),2) - 1)
from test_name
Thanks Luis. I was a brain meltdown for some...
September 10, 2012 at 2:01 pm
weston_086 (9/10/2012)
September 10, 2012 at 1:46 pm
Nice job posting ddl and sample data. Unfortunately it is totally unclear what you are trying to do. Can you provide a clear explanation of your requirements. Additionally if you...
September 10, 2012 at 1:16 pm
A third option which you did not mention is to use FILESTREAM. http://technet.microsoft.com/en-us/library/bb933993%28v=sql.105%29.aspx
This is a valid option in many situations.
With either of the previous methods there are some pitfalls....
September 10, 2012 at 8:56 am
raghuldrag (9/10/2012)
(
@stuid nvarchar(22),
@startyear nvarchar(22),
@endyear nvarchar(22),
)
as
begin
select name,class,noofsubject,rank,test from @tab1
union
select name,class,subject,rank,test from @tab2
where rank is not null
and studentname=@stuid...
September 10, 2012 at 8:50 am
gpm.alwyn (9/10/2012)
September 10, 2012 at 8:38 am
As Lynn said we need more details to answer your specific issue. I do see some serious performance issues with your query. You have a lot of conditions that cause...
September 10, 2012 at 8:34 am
hehe I hadn't looked at today's question of the day. Seems to be in conjunction with this post. Same issue exactly. We should all three get this one correct with...
September 10, 2012 at 8:08 am
Andrew-495157 (9/7/2012)
Assuming you don't mean VB.net Option Explicit, or the Implicit keyword.
And ingoring the VAR debate.....
Can you give some examples of implicit...
September 10, 2012 at 7:23 am
surma.sql (9/7/2012)
I need help.
I am getting an error while i am try to connect the server B from server A. so please help me for this,
I take screenshot so...
September 7, 2012 at 3:37 pm
There are probably a number of things that can be done. However we don't have enough details to even hazard a guess.
Take a look at this article. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D
It does a...
September 7, 2012 at 3:32 pm
Andrew-495157 (9/7/2012)
Putting the peices together I think the answer is this:
The fragment of the SP causing the error is this:
SELECT Job_Bag
FROM Job_Bag
WHERE Job_Bag.Description_Reference = @OrderID
ANDJob_Bag.Cust_Order_No =...
September 7, 2012 at 2:55 pm
Viewing 15 posts - 10,771 through 10,785 (of 15,376 total)