No problem, good luck!

What I want to know:

Is it possible to have the SSRS report contain links within the results of the report that can be passed back to a Webform so that...

Printed books -- 100%.

I read pdf's & ebooks on my phone & tablet but this is only when it would not be convenient to huff around a real book.

I have always done this manually because of the types of SSIS packages I have dealt with did not work well with the Visual Studio conversion wizard. That said, here's...

Steve Smith-163358 (10/2/2013)

---

Hi,

The software we use often creates a lot of temporary tables that need to be deleted from time to time.

Depending on the usage, this can range from hundreds...

I would strongly encourage you to look at the article that Gail posted.

For a database...

erikd (9/30/2013)

---

Actually, this seems to get me where I need to go. For some reason the tutorial I watched had @ signs in alias paths(?). When I took them out,...

This is what you are looking for.

DECLARE @x xml;

SELECT @x = P

FROM OPENROWSET (BULK '\\usd\SurveyComputing\Sample\SampleRepository\Visit_Survey_2013_08_16_07_21_43.XML', SINGLE_BLOB) AS FMG(P)

DECLARE @hdoc int

EXEC sp_xml_preparedocument @hdoc OUTPUT, @x

select *

from OPENXML (@hdoc, 'SURVEY_EXTRACT/VISIT_SURVEY',...

For what you are doing I think Sean's solution is the way to go. That said, you could run them in parallel in an SSIS package then have your proc...

Taking what Keith said, you could re-write your query like this:

WITH cteSource(CN, U1)

AS (

SELECTr.CN, r.U1

FROM dbo.SSS AS s

INNER JOINdbo.STU AS t ON t.SN = s.SN

INNER JOINdbo.CRS AS...

What Louis posted is the way to go; no DSQL needed for what you are doing. That said, to accomplish this with a temp table you would need to use...

This will get you what you are looking for...

-- (1) Sample data

DECLARE @x_p TABLE (xid int, nbr1 int, cid int);

DECLARE @x_c TABLE (cid int, chr char(1), nbr2 int, nbr3 int,...

I'm just happy someone noticed 😀

As a DBA I used a number of tools in the DBA bundle and was a big fan.

If you ever get a chance to attend a SQL in the...

Below is a script that will get you information about all the jobs that ran between a two dates. I was not able to figure out how to get you...