Viewing 15 posts - 3,346 through 3,360 (of 14,953 total)
DECLARE @XML XML = '<MESSAGE>
<HEADER>
<Source_System>ACF</Source_System>
<Target_System>CRIMS</Target_System>
<System_Date>2011/01/14</System_Date>
<Generation_Date>2011/09/05</Generation_Date>
<Generation_Time>11:25:28</Generation_Time>
</HEADER>
<DETAIL>
<Account_CD>VPBN</Account_CD>
<Source_Security_ID>131924</Source_Security_ID>
<Long_Short_Code>L</Long_Short_Code>
<Valuation_Date>2011/01/14</Valuation_Date>
<Qty>N</Qty>
<Tax_lot_ID>N</Tax_lot_ID>
<Position_Or_TaxLot>P</Position_Or_TaxLot>
<Desc>última flor do Lácio</Desc>
<Source>ACF</Source>
</DETAIL>
<TRAILER>
<Number_of_Records>N</Number_of_Records>
</TRAILER>
</MESSAGE>';
SELECT @XML.value('(/MESSAGE/DETAIL/Account_CD/text())[1]','varchar(100)') AS Account_CD;
Just add the rest of the columns you need by following that pattern.
- 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
September 16, 2011 at 6:35 am
GilaMonster (9/15/2011)
GSquared (9/15/2011)
What if you happen to know that 40% of the cars in there are white? That'll help you plan how long this project will take, and what...
- 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
September 16, 2011 at 6:31 am
jcrawf02 (9/15/2011)
GSquared (9/15/2011)
Ninja's_RGR'us (9/15/2011)
GSquared (9/15/2011)
Ninja's_RGR'us (9/15/2011)
Anybody got deep-ish cardinality / index / stats knowledge?Not my forte!
http://www.sqlservercentral.com/Forums/Topic1174681-338-1.aspx
I put what I could.
Much better than what I could have done without someone proof...
- 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
September 15, 2011 at 9:58 am
I don't think SQL 2008 licenses will cover SQL 2005, but I wouldn't swear to that. Ask on Microsoft's support site. You'll get a more authoritative answer there.
- 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
September 15, 2011 at 7:21 am
YTZ (9/15/2011)
EXEC sp_MSForEachTable ‘ALTER TABLE ? CHECK CONSTRAINT ALL’
Okay, I have to ask, how will that delete any data?
- 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
September 15, 2011 at 7:20 am
Perhaps a problem with the path to the executable? Do you fully qualify that in the call, or just call "winrar.exe"?
- 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
September 15, 2011 at 7:19 am
SELECT 'delete from ' + name + ';'
FROM sys.tables
WHERE type = 'U'
Copy-and-paste the results into a connection window and run them.
Or use that for a cursor and execute the commands...
- 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
September 15, 2011 at 7:17 am
Ninja's_RGR'us (9/15/2011)
GSquared (9/15/2011)
Ninja's_RGR'us (9/15/2011)
Anybody got deep-ish cardinality / index / stats knowledge?Not my forte!
http://www.sqlservercentral.com/Forums/Topic1174681-338-1.aspx
I put what I could.
Much better than what I could have done without someone proof reading. ...
- 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
September 15, 2011 at 7:13 am
"Aligned" in this case essentially means "same columns and function and file(s)". It just makes the query engine do less work when it does partition switching. It doesn't...
- 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
September 15, 2011 at 7:06 am
Ninja's_RGR'us (9/15/2011)
Anybody got deep-ish cardinality / index / stats knowledge?Not my forte!
http://www.sqlservercentral.com/Forums/Topic1174681-338-1.aspx
I put what I could.
- 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
September 15, 2011 at 7:01 am
1) Magic Density
This is simply the name for how SQL Server guesses when it doesn't know. The name probably comes from the programming concept of "magic numbers", which are...
- 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
September 15, 2011 at 7:00 am
Stefan Krzywicki (9/14/2011)
GSquared (9/14/2011)
....
Edit: Deleted the rest of my post because this debate is just looney at this point. Shouldn't have brought it back up.
I found another interesting...
- 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
September 14, 2011 at 3:37 pm
I doubt anyone is still interested, but yesterday, the data about poverty in the US was updated. The stats are bad (thank you incompetent/malignant federal government and Federal Reserve...
- 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
September 14, 2011 at 6:14 am
ALZDBA (9/14/2011)
We get to hear "Ho, ho, hoo" at SQLPASS 2011 !!!!http://www.sqlservercentral.com/articles/Exceptional+DBA+Awards/75988/
Congratulations Jeff !!
Ditto! (In the manner of Taggart in Blazing Saddles.)
Very well done!
- 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
September 14, 2011 at 5:27 am
Is MARS enabled on the server? Won't matter if it's a single resultset, it will still fail the insert, as per Insert Exec in BOL/MSDN.
A proc that returns multiple...
- 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
September 14, 2011 at 5:22 am
Viewing 15 posts - 3,346 through 3,360 (of 14,953 total)