Viewing 15 posts - 7,201 through 7,215 (of 14,953 total)
Will you ever have part of an order confirmed but the other part isn't? That seems illogical to me, but that's what this table allows.
If an order will be...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 13, 2010 at 11:05 am
You can split on the slash pretty easily, but the rest is trickier. For example, will you have any names that don't have a middle name? How about...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 13, 2010 at 11:02 am
Run a server-side trace, and query that.
Look up sp_trace_create in Books Online for details on how to do that.
Here's a sample:
declare @ID int, @FS bigint, @FilePath nvarchar(245), @1 bit
select @fs...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 13, 2010 at 7:33 am
Simply put, the first query uses the leading edge of the index you posted. The first column in the index is part of the Where clause. That's optimal...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 13, 2010 at 7:29 am
I have to say I haven't yet run into a situation where I'd want to do this.
Does RedGate's backup product use the SQL backup engine? I don't see how...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 13, 2010 at 7:23 am
homebrew01 (1/12/2010)
GSquared (1/12/2010)
Looks like. There's a list of them here: http://html-color-codes.com/
Thanks. If I'm hard up, I'll try that. The rest of the world has a nice little pop-up...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 13, 2010 at 7:14 am
Have you tried using the site search for your username? Does that give you what you need?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 12, 2010 at 2:40 pm
Sounds like a good idea.
Till it's implemented, you can get a list of the topics you've subscribed to (which usually happens when you post), at http://www.sqlservercentral.com/Forums/TopicSubscriptions1.aspx. That can help...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 12, 2010 at 2:39 pm
Nope. Not really.
If you want to use a stored procedure in the From clause, I believe that can be done with OpenRecordset, but I have to admit, I never...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 12, 2010 at 2:37 pm
Looks like. There's a list of them here: http://html-color-codes.com/
Edit: Occurred to me that you might be looking for how to color code, like this:
select 'red' from sys.columns;
If so, that's...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 12, 2010 at 2:34 pm
What tool are you using for the import? The Import/Export Wizard? OpenRowset? SSIS?
The answer will depend on which one.
Pretty much, it will boil down to handling the...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 12, 2010 at 2:30 pm
The only way I can think of to do this would be dynamic SQL.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 12, 2010 at 2:28 pm
I'm not entirely sure what you're trying to accomplish here. Is this intended to create a list of columns to select from a table?
If so, you can do that...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 12, 2010 at 2:25 pm
GilaMonster (1/12/2010)
Yes, we have electricity and internet (most of the time), we...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 12, 2010 at 9:46 am
Tampa, Florida
Moved here from Houston, Texas (more precisely, from Katy, Texas, outside Houston).
Moved there from Washington, DC.
Moved there from Missoula, Montana.
Moved there from Los Angeles, California.
Moved there from Seattle, Washington.
And...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 12, 2010 at 9:05 am
Viewing 15 posts - 7,201 through 7,215 (of 14,953 total)