Viewing 15 posts - 9,241 through 9,255 (of 14,953 total)
I'm not sure what you mean by learning "SSRS package". I tend to think of packages as being part of SSIS. Are you sure what you mean 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
June 16, 2009 at 12:26 pm
I think you can't re-create the master key. I think you need to migrate it. If I remember correctly, in MSDN/BOL articles on encryption, it has data on...
- 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
June 16, 2009 at 12:23 pm
In Books Online, check out Exists. If you use Where Exists and a sub-query to find non-science fails, and Where Exists and a sub-query to find science passes, you'll...
- 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
June 16, 2009 at 12:21 pm
Are you using Management Studio, or Business Intelligence Dev Studio? The second is the one for SSIS, and might be the right place to start for what you're doing.
- 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
June 16, 2009 at 12:19 pm
Try this, see if it does what you need:
select distinct CustID,
(select Col1 + ' '
from Table1 T1_Sub
where CustID = Table1.CustID
order by Col2
for XML path('')) as ColA
from Table1;
- 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
June 16, 2009 at 12:17 pm
Try changing this:
SET @StrSelect = N'SELECT COUNT(*) FROM ' + @TrackitServer + '.TRACKIT8_DATA.DBO.Tasks WHERE UserID = ' + CAST(@UserID AS varchar(5)) + ' AND Task LIKE ' + '''' +...
- 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
June 16, 2009 at 12:13 pm
I back up system databases daily. Should probably only do it when they change, but I'm too lazy to keep track of that, so they get backed up daily....
- 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
June 16, 2009 at 12:08 pm
There's nothing I know of that can't be bypassed. QA needs to hold to established standards, or the standards need to be revised to say what the exceptions 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
June 16, 2009 at 6:53 am
I've gone both ways on proposed solutions.
Had a prior employer, they said what they wanted, I said how long I thought it would take, they said yes/no on the project...
- 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
June 16, 2009 at 6:42 am
talltop (6/15/2009)
- 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
June 15, 2009 at 3:06 pm
Try something like this:
select dateadd(day, datediff(day, 0, "start_date"), 0) as DateRun,
sum(EstSetup) as TotalEstSetup
from
(SELECT "track"."start_date",
CASE
WHEN "track"."order_id"=
(SELECT "look"."order_id"
FROM "flute_data"."dbo"."track" "look"
WHERE "look"."process_id"=1
AND "look"."start_date"=
(SELECT MAX("datefind"."start_date")
FROM "flute_data"."dbo"."track" "datefind"
WHERE "datefind"."start_date"={ts...
- 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
June 15, 2009 at 3:03 pm
Digs (6/15/2009)
The table will suffer deleted records.
I like the idea
One field for UserID (no users 100 to 10000)
another for datetimecalc
Yes maybe I making too complicated, even tho...
- 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
June 15, 2009 at 2:39 pm
GilaMonster (6/15/2009)
GSquared (6/15/2009)
Someone asking for help here. I'm interested in other people's takes on it.Russian roulette with a database.
Pretty much. But it's the even-more-dumb kind (Russian roulette with...
- 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
June 15, 2009 at 2:31 pm
Instead of a new filegroup every month, I'd seriously look into separating the data into and Old database and a Current database. Flush the data into the old database...
- 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
June 15, 2009 at 2:16 pm
That was my situation. Built with Dev, then changed the server to production once all the code was working.
- 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
June 15, 2009 at 1:52 pm
Viewing 15 posts - 9,241 through 9,255 (of 14,953 total)