Viewing 15 posts - 6,616 through 6,630 (of 14,953 total)
Yes, it is possible to do what you want, but it's both difficult and a bad idea.
You should use the dataset from your query and do that kind of thing...
- 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
April 15, 2010 at 10:07 am
I'm not sure, but it's probably possible.
However, I can see all kinds of problems coming up from it, even if it is possible. What happens if one of 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
April 15, 2010 at 10:04 am
george sibbald (4/15/2010)
any user code in system databases (naughty)?any user defined error messages? (held in master)
backed up and copied over your RS Key if you are copying RS databases over.
Good...
- 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
April 15, 2010 at 10:02 am
I was including the dropserver/addserver step as part of the rename step.
The current server doesn't have any SSIS packages running, so I don't have to worry about those.
I'll check 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
April 15, 2010 at 9:02 am
Steve Jones - Editor (4/15/2010)
Happy Tax Day, and behave children. I'm going skiing, so no one will be here to moderate bad jokes and subtract points.
Okay, I definitely have mixed...
- 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
April 15, 2010 at 8:28 am
SQL Server probably has all the tools you need already available.
My first suggestion would be to post the table definition, the stored procedure, and some sample data here, and see...
- 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
April 15, 2010 at 8:25 am
Try using DateDiff(second, T1, T2), then divide by 3600 to get hours, then divide the modulus of that by 60 to get minutes, then use the modulus to get seconds.
My...
- 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
April 15, 2010 at 7:34 am
jcrawf02 (4/15/2010)
RBarryYoung (4/14/2010)
jcrawf02 (4/14/2010)
I've been out of Twitter-touch lately, but did you guys see this? Library of Congress is archiving every single tweet ever made?Goggle already has them anyway.
Yes,...
- 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
April 15, 2010 at 7:13 am
I should blog, but not at work. Just never seem to have the time for it. Too busy with all the things I should blog 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
April 15, 2010 at 7:10 am
seeteshh (4/15/2010)
The code must be modified if pulling data into excel exceeds 65536 records without storing header info else its...
- 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
April 15, 2010 at 6:51 am
You can use DateDiff to get that.
Here's a sample. Doesn't do the whole job, but should get you started:
CREATE TABLE #T (
ID INT IDENTITY PRIMARY KEY,
T1 NVARCHAR(50),
T2 NVARCHAR(50));
INSERT INTO...
- 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
April 15, 2010 at 6:47 am
Are you using table-level partitioning, or a federated (partitioned) view?
For a view, you'll need to have the table physically split, and have a column in the table that uniquely identifies...
- 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
April 15, 2010 at 6:30 am
If the report server login can't access the images, the reports won't be able to either.
- 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
April 15, 2010 at 6:24 am
James Stover (4/14/2010)
GSquared (4/14/2010)
kevin77 (4/13/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
April 15, 2010 at 6:22 am
Switch to a Nested Sets hierarchy, and it will do all that and more.
Here's an article that will help explain some ways to implement this: http://www.sqlservercentral.com/articles/T-SQL/65540/
If you have questions after...
- 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
April 14, 2010 at 3:24 pm
Viewing 15 posts - 6,616 through 6,630 (of 14,953 total)