Viewing 15 posts - 556 through 570 (of 1,473 total)
Here's an article that touches on using FOR XML PATH to do this type of concatenation.
http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
If you need some more help with writing the code, please post sample data in...
October 8, 2009 at 8:51 pm
Just because your query doesn't return any rows, it doesn't mean that the server didn't have to read through a large amount of data to come to the conclusion that...
October 8, 2009 at 2:36 pm
What are you using to verify that you only get a space? You're not going to see it in QA or SSMS, as they don't show things like carriage...
October 6, 2009 at 10:56 am
eseosaoregie (10/6/2009)
Incidentally, with the original data I gave you how would I have done it without out the datetimes?
This is the method that I prefer. For this running total...
October 6, 2009 at 9:36 am
Well, in that case, you need part 2 of the article ;-).
http://www.sqlservercentral.com/articles/Crosstab/65048/
That Jeff, always thinkin ahead.
October 6, 2009 at 9:08 am
This is an interesting request. Can you explain a bit further? Does the action that is failing not actually need to happen? If so, why is it...
October 6, 2009 at 7:54 am
What you're trying to do is known as a running total. Ordinarily, I'd point you to Jeff's article on it, but it's under construction as he is re-writing it....
October 6, 2009 at 7:42 am
Oh yeah, didn't even notice those were functions. That's likely major issue #2. Please post the code for the functions as well. If they're simple enough, pulling...
October 6, 2009 at 7:35 am
At a glance (Gail has the right of it, please post what she asked for), these 2 may be causing significant problems.
SELECT EfaYear
FROM EfaCalendarDates
WHERE ...
October 6, 2009 at 7:31 am
Take a look at the article in my signature by Jeff Moden on Cross Tabs. Post back if you have questions.
October 6, 2009 at 7:15 am
Jacob Pressures (10/5/2009)
October 5, 2009 at 2:57 pm
PIVOT needs to aggregate something. You're not aggregating anything, thus the error. You really don't need PIVOT at all, you can use something like this:
select g.studentid, g1.guardianname, g2.guardianname
from...
October 5, 2009 at 1:34 pm
krish-529631 (10/5/2009)
Hi Girish,First-of-all thanks for reply..
Actually i use SQL Server 2000. so i can not use Table variable.
any ways, i use temporary table using yr solution. 🙂
Again thank u....
SQL 2000...
October 5, 2009 at 10:37 am
Roust_m (10/1/2009)
October 2, 2009 at 5:02 pm
bitbucket-25253 (10/2/2009)
These were my test conditions using Developer version of SQL Server 2008 Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
/
ALTER DATABASE Test
SET COMPATIBILITY_LEVEL = 100
CREATE TABLE Dbo.NonExisting
(ABC...
October 2, 2009 at 4:51 pm
Viewing 15 posts - 556 through 570 (of 1,473 total)