Viewing 15 posts - 5,746 through 5,760 (of 14,953 total)
Lots of ways. You could pass it to a CLR DLL via a CLR proc, and have one of the .NET languages shred it for you. You 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
December 9, 2010 at 6:58 am
Jack Corbett (12/8/2010)
...BTW-the one thing I've learned and like from leaving in the south is y'all, it's so much better then "you guys":-D
"Dudes and dudettes" - I'm from California
- 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
December 8, 2010 at 7:30 pm
Jack Corbett (12/8/2010)
GilaMonster (12/8/2010)
Jack Corbett (12/8/2010)
- 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
December 8, 2010 at 2:35 pm
Start with Wikipedia. Go from 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
December 8, 2010 at 2:33 pm
What you'd need to do would be find the first ID for each company name, and then update all the records in the subtable to match those.
For example:
;with PrimaryIDs (PrimaryID,...
- 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
December 8, 2010 at 2:30 pm
On the subject of what's in the DLLs, you may not be able to verify it yourself, but you can insist on a level of code-review and sign-off by 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
December 8, 2010 at 2:08 pm
As always, please ignore the rabid monkey in the corner. He makes a lot of noise, but he can't actually bite anyone through an Internet connection. He does...
- 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
December 8, 2010 at 1:51 pm
begin transaction;
UPDATE CMLEDG SET TRANDATE = '12/01/2010' WHERE BLDGID = '600' AND PERIOD = '201012';
Run that. Check the numbers. Then add Commit if you want to keep it...
- 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
December 8, 2010 at 1:29 pm
The first part that strikes me as a target for optimization is the delete.
DELETE psa
FROM
PortSecAgg AS psa
JOIN
@DelPortList AS dpl
ONpsa.PortfolioID = dpl.PortfolioID
AND psa.AsOfDate = dpl.AsOfDate
LEFT JOIN
PortSecAgg_staging AS psa_s
ONpsa.PortfolioID = psa_s.PortfolioID
AND psa.SecurityID...
- 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
December 8, 2010 at 1:28 pm
Try running SSMS as an admin. Right-click and select "Run as administrator". See if that helps.
- 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
December 8, 2010 at 11:16 am
It's kind of a big subject.
The security issues come from a couple of factors. First, have you verified the contents of the DLLs that you're loading as assemblies? ...
- 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
December 8, 2010 at 11:14 am
Do you want files from it to roll over? Will you keep old trace files?
You'll need to set up a startup proc that will re-start it when the 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
December 8, 2010 at 11:09 am
There do need to be risk-vs-reward analyses done.
The place I worked in the early naughts went out of business because an "innovative" new service line ended up sucking up all...
- 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
December 8, 2010 at 11:07 am
LadyRuna (12/8/2010)
I've been a good little girl and having SQL Monitor and a spiffy iPad would really make my year.
🙂
I've left a bottle of 2005 Chateau-Neuf-du-Pape, a clean...
- 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
December 8, 2010 at 10:46 am
If it's more than one row at a time, you can use an Output Into clause to get all the IDs you just inserted.
Create a temp table, Output Into it,...
- 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
December 8, 2010 at 10:42 am
Viewing 15 posts - 5,746 through 5,760 (of 14,953 total)