Viewing 15 posts - 181 through 195 (of 14,953 total)
I don't follow what you're trying to do. Are you trying to get the proc to execute in each database, or trying to get it to insert the statement...
- 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 9, 2013 at 11:48 am
Okay, so we don't get confused with District Attorneys, but people think my job title is "Doing Business As". Not much of an improvement. 🙂
But there are lots of...
- 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 9, 2013 at 11:43 am
Can you post the table definition and sample data (as insert statements) instead of an Excel spreadsheet?
Pardon my paranoia, but this is the internet, and trusting a file that 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
January 9, 2013 at 11:22 am
lnardozi 61862 (1/9/2013)
Aargh! I knew that! Failure to engage brain before engaging fingers!
ROUND(@date,0,1)
is what I meant.
That still doesn't get around the implicit conversion issues I pointed out.
Try this:
DECLARE @Date DATETIME2...
- 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 9, 2013 at 11:18 am
Michael Valentine Jones (1/8/2013)
paul.j.kemna (1/7/2013)
That is,...
- 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 9, 2013 at 11:12 am
fbernausberraondo (1/8/2013)
- 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 9, 2013 at 11:10 am
Oracle_91 (1/8/2013)
Hi Gus,I am just testing/learning memory concepts over here. not to throttle any productions systems 🙂
Ah! That makes sense then.
Yeah, learning how to deliberately overload the data cache...
- 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 9, 2013 at 11:08 am
Grant Fritchey (1/8/2013)
hisakimatama (1/8/2013)
- 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 8, 2013 at 12:59 pm
Do it in two steps. Merge can't insert into a different table. Not really.
- 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 8, 2013 at 11:29 am
My first guess would be the virtual machines aren't configured correctly for optimal SQL Server performance. If not done exactly right, it's pretty usual to get some performance degredation...
- 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 8, 2013 at 11:28 am
Sounds like it should work. So long as the backup can be restored successfully.
- 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 8, 2013 at 11:25 am
If you really need the numeric part of the date, you can do either of these:
DECLARE @D1 DATETIME = '2013-01-08 13:00', @D2 DATETIME = '2013-01-08 11:00';
SELECT FLOOR(CAST(@D1 AS FLOAT)), FLOOR(CAST(@D2...
- 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 8, 2013 at 11:23 am
lnardozi 61862 (1/8/2013)
That's why I cast the date as an int. The fractional part of the date is the time. Casting is pretty fast.
Rounding errors.
Try this:
DECLARE @D1 DATETIME = '2013-01-08...
- 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 8, 2013 at 11:16 am
Based on your description, that's not really something a relational database does.
What you need is a separate table of unique combinations of DOB, Source, and Organism. Then assign an...
- 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 8, 2013 at 9:30 am
That makes sense.
Looked at a few more details.
This part isn't correct T-SQL syntax:
WHEN MATCHED and
COALESCE('target.[Programabilty_NME] <> source.[Programabilty_NME]', '') <> '' and
(target.[Programabilty_NME] <> source.[Programabilty_NME])
THEN
UPDATE
SET Expiration_DTM = '2013-01-06 23:59:59.977'
WHERE Expiration_DTM = '12/31/9999'
INSERT...
- 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 8, 2013 at 9:28 am
Viewing 15 posts - 181 through 195 (of 14,953 total)