Viewing 15 posts - 31 through 45 (of 1,109 total)
GilaMonster (8/21/2008)
Provided the database was shut down cleanly, that is.
That is correct, thanks Gail. In case the database has not been shut down cleanly, you can still rescue most of...
August 21, 2008 at 7:03 am
Peso (8/21/2008)
He only has to read the replies here
Well spotted :), the answer there (at the time of this post) addresses the problem if the pivot values are static. If...
August 21, 2008 at 4:53 am
What you need (since you are on SQL Server 2005) is pivots with dynamic SQL. I've put some examples on:
http://www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx
Regards,
Andras
August 21, 2008 at 4:32 am
nairsanthu1977 (8/21/2008)
I physicaly deleted LOG file of one database. I have the MDF file with me now. I want to create a database to point...
August 21, 2008 at 4:09 am
nairsanthu1977 (8/21/2008)
Hello,The problem is that SSMS itself is not opening....Without query analyzer how will I fire the command..?
You can use sqlcmd from command line for example. Or run...
August 21, 2008 at 3:21 am
onlo (8/21/2008)
Does it mean if we have had "Extened support" from Microsoft, we can still have Microsoft technical support services on our SQL 7.0 systems...
August 21, 2008 at 2:57 am
And after you follow Hadrian's advice, take a full backup. Then find out if that database had any periodic full/log backups. If yes, try to find the reason for the...
August 21, 2008 at 2:54 am
PS: thanks for providing table definition, test data and expected results in your question, hope this will get you the best & right answer 🙂
- Andras
August 21, 2008 at 2:13 am
Assuming that you want to maintain the ordering, i.e. all the first rows have lower id than the next rows (and I assume the row ordering is by the col1),...
August 21, 2008 at 2:11 am
mohd.imtiaz (8/21/2008)
Thanks for your spontaneous reply, it was really kind of you.
I tried your query in sql 2005 it was woring fine over there.
Is it possible...
August 21, 2008 at 1:58 am
Carl B. (8/20/2008)
Thank's Andras,Can I get back the result of the execution of @q and use it afterwards?
Best regards.
Carl
You can do this too. One way of doing this is to...
August 20, 2008 at 7:30 am
mohd.imtiaz (8/20/2008)
c1 c2 c4
--------------
a b 01,05
z y 10,15,20
...
August 20, 2008 at 7:26 am
Carl B. (8/20/2008)
We would like to have a T-SQL script to purge some data based on several conditions (not trivial).
What is the most complicated is that we do not...
August 20, 2008 at 6:58 am
karthikeyan (8/20/2008)
t would probably be a poor choice if you do not want to get rid of every row in your table.
You mean we need to use TRUNCATE if we...
August 20, 2008 at 5:17 am
karthikeyan (8/20/2008)
TRUNCATE may help for your need.You have to frame your question better. Also please post your requirement clearly.
While I agree with Karthik that TRUNCATE may help you, it would...
August 20, 2008 at 5:00 am
Viewing 15 posts - 31 through 45 (of 1,109 total)