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...

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...

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...

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.

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;

Try changing this:

SET @StrSelect = N'SELECT COUNT(*) FROM ' + @TrackitServer + '.TRACKIT8_DATA.DBO.Tasks WHERE UserID = ' + CAST(@UserID AS varchar(5)) + ' AND Task LIKE ' + '''' +...

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....

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....

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...

talltop (6/15/2009)

---

Yep, now that we have the list, getting the last modifed date of the detached files is a piece of cake. Going forward, all detached database files will be...

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...

Digs (6/15/2009)

---

Thanks, good response.

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...

Pretty much. But it's the even-more-dumb kind (Russian roulette with...

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...

That was my situation. Built with Dev, then changed the server to production once all the code was working.