Yep. We've had plenty of discussion on "how can you define 'Senior DBA' when you can't even define 'DBA'?"

I'm an adequate database administrator. I know not to put...

I'd have to see the whole query to really nail this one down.

Is it in the form of?:

select CompanyName, AccountNumber, County, Territory, SalesCount

from dbo.Accounts as PT

left outer join

...

Try this:

declare @x xml

declare @f bit

set @x = ' <Answer code="Text" data="2011-10-25" />'

set @f = @x.exist('.[(concat(string((/Answer/@data)[1]), "Z") cast as xs:date?) eq xs:date("2011-10-25Z")]');

select @f

You can also programmatically generate the date to...

That's precisely what Delayed Validation is for.

The problem for me isn't money. It's that there's no way for me to "copy and paste into SSMS and run the query", since I don't have the tables,...

In the properties of any connection in SSIS, you can use an Expression for the Connection String, and can control the connection dynamically that way.

Ninja's_RGR'us (10/31/2011)

---

Steve Jones - SSC Editor (10/31/2011)

---

Congrats, Gail.

I am not putting as much effort into the discussions lately with all the travel. Not likely to change, either, so I think...

paul.jones (11/1/2011)

---

Thanks for the suggestions - it may be I'm ruling out dynamic SQL unnecessarily and I'll look into it. Not sure what is meant by name-value pairs?

As for examples,...

"Select Into" will replicate the columns of the data-source into a new table. You can use dynamic SQL to build the query so that you can name the table...

Those are Star Trek characters, right? I've heard of them.

If all a company is looking for is speed-of-query, then hardware is almost certainly cheaper than a good DBA.

However, if that's all they're looking for, then they don't know what...

Grats Gail!

In SQL 2008, you could probably do name-value pairs, either in XML or (probably better) a Table Value Parameter, and then join to that using some variation of Outer Join.

I'll...

In SQL Configuration Manager, what connection types have you allowed?

There's definitely demand for senior DBAs. I get several calls per month from recruiters.