And here is it 😀

Back in the late 80's I had...

The challenge we have in IT is to deliver toolsets that allow users access to data without having to anticipate every question that will potentially be asked of that data...

majorbloodnock (1/25/2011)

---

For me, it's an incredibly simple equation. The number of times I've trawled the Web to see if someone's already solved the problem I'm encountering is huge. The number...

So when i import the package, i should import the package to the SQL Server 2008 Clustered Virtual Name and then Create Jobs to run the packages. For this i...

It's that simple. Good to know, thanks.

Ken

This is actually data...

GilaMonster (12/6/2010)

---

Or, as an (untested) alternative.

Select

Distinct RCD.Variable4

FROM Route_Call_Detail RCD

WHERE RCD.[DateTime] > '12/4/10'

AND RCD.[DateTime] < '12/5/10'

AND CASE WHEN SUBSTRING(RCD.Variable4, 1,...

Lowell (12/6/2010)

---

i think you'll just have to wrap a section of the query into a subquery, since the data has to be filtered on the LIKE statement first;

because the second...

I think this could be a whole other forum discussion. "How much of your time is spent doing work other than coding and how much time do you think developers...

I'm into alternative rock but could not imagine trying to do anything but the easiest tasks at work if I had it in my headphones. Would be way too distracting.

Ken

You might look into one of the note-taking softwares like SpringPad. You can write notes on the smartphone & it syncs, automagically, with the internet where you can read it...

Michael Lysons (10/22/2010)

---

I'm finding myself less interested in learning new programming tech as I get older. I've been working in IT for 16 years now, the last 7 of...

Brian, thanks a lot for these articles. So we bump the permissions of the guest account so that under the hood a connection can be made from calling DB to...

You mean something like:

use db_1

create user ROuser1 for login ROuser1 --with default_schema = user1schema

create schema user1schema authorization ROuser1

create view user1schema.vwTest as select * from db_2.dbo.test

Seems that ROuser1 still needs access...