Viewing 15 posts - 4,186 through 4,200 (of 9,715 total)
Do you have a question or are you just reporting something you ran across and fixed?
July 13, 2012 at 5:13 am
Instead of doing all your processing in the CASE statement, try using subqueries. I was going to do this using CTEs, but decided to go with the multiple join method.
SELECT...
July 13, 2012 at 5:10 am
There is no backup designed for indexes only. You could script them out as a DROP - CREATE series of statements by going to the GUI though, right-clicking the database...
July 13, 2012 at 4:49 am
Mahmood, would you please bold the places where you made chances to the code to make it easier to read?
July 13, 2012 at 4:45 am
Lowell (7/11/2012)
last i heard, the views were there to stay, but could be changed;
some article i read said any changes would be things like adding columns to the end of...
July 11, 2012 at 12:01 pm
Lowell, Ah. Interesting. I didn't think about it that way.
FYI: Please don't think I was saying "it's bad to use sys.columns." I was just genuinely curious why people would still...
July 11, 2012 at 11:49 am
Just a note on forms. So far as I know, a label box doesn't actually point to a database & table. It is just a label. So trying to connect...
July 11, 2012 at 11:34 am
Lowell (7/11/2012)
since you are searching every table/column for text, this is slow, and any tables with a Million rows are...
July 11, 2012 at 11:28 am
Commenting for me is CTL - Shift - C and CTL - Shift - R to remove. But I'm using SQL 2008 with the keyboard option set to SQL 2000.
July 11, 2012 at 11:25 am
Sumit,
Please don't make duplicate posts on the same issue. It is considered rude to repost the same question multiple times, especially to the people trying to help you.
http://www.sqlservercentral.com/Forums/Topic1328029-391-1.aspx
July 11, 2012 at 10:45 am
Hadrian (7/11/2012)
yes you can ,change the compatibility when it finish.
That is not true. You can make the database compatible with SQL 2000 datatypes & such, but you cannot change the...
July 11, 2012 at 10:35 am
Does your Flat File Connector have that column properly set as string?
Can you show us an example of File to Table conversion? (I can't see 4000 only showing up as...
July 11, 2012 at 10:32 am
Clark,
There are a lot of us that don't open attachments. Could you post your code in your reply, along with a CREATE TABLE statement (DDL) and an INSERT statement containing...
July 11, 2012 at 10:25 am
This type of code has already been posted on many sites using various methods, even this one. Try the search feature on this site and a search engine. If you...
July 11, 2012 at 10:24 am
Sumit,
Please script out your table as a DDL (CREATE TABLE) statement and give us sample data in the form of an INSERT script so we can help you out.
I assume...
July 11, 2012 at 7:00 am
Viewing 15 posts - 4,186 through 4,200 (of 9,715 total)