More like this:

WITH Query1 AS(

select scholarship_category , COUNT(s.scholarship_id) as [No of applicants]

from Students s

join Students_Scholarships_junction j...

shaneoneillis (4/11/2016)

---

Hi bjaricha,

You may want to let us know how you got your variables as it could help with the answers to this.

Also with this

do...

Wild idea:

Instead of using dynamic SQL, use synonyms for the cross-database calls.

It depends on the interpretation. A restricted outer join, could be the simple use of a WHERE clause (which shouldn't change the outer join into an inner join) or additional...

TMNT

Seek

mw112009 (4/7/2016)

---

While running an ssis package , I get this error..

[Execute SQL Task] Error: Executing the query

"exec [dbo].[sp_visits_modified_for_execution] @Run..." failed

with the following error: "Could not allocate space for...

Is this what you're looking for?

DECLARE @tbl_MediumResults TABLE(

Answer VARCHAR(8000)

);

INSERT INTO @tbl_MediumResults

SELECT '{"Sunday:"[3,4,5,]},{"Monday:"[1,6,]},{"Tuesday:"[5,6,7,]},{"Wednesday:"[6,7,]},{"Thurday:"[5,6,]},{"Friday:"[5,6,]},{"Saturday:"[1,6,7,]},'

UNION ALL

Select '2,3,4,5,6'

SELECT Answer,

CASE

...

Maybe the package is using an incorrect code page for your varchar column.

This is weird as it's changing the values completely.

Lynn Pettis (4/7/2016)

---

This:

INSERT into [JP_CDM].[case]

SELECT

*

--ucn,

--lcn,

--court_id,

--case_initiation_date,

--case_restriction_flag,

--county,

--date_disposed,

--recurrent_flag,

--intestate_testate_flag,

--case_referred_to_mediation_flag,

--contested_flag,

--jury_trial_flag,

--outstanding_warsumcap_flag,

--pro_se_flag,

--record_source,

--record_state,

--create_user,

--create_date,

--maint_user,

--maint_date

FROM

#case_tmpTable;

select * from #case_tmpTable

Is not going to work as there are not an equal number of columns between...

EXECUTE sp_help 'MEMBER_IN'

Or view dependencies.

ram302 (4/7/2016)

---

I know this is an old post, but how does this work? I have tried the following:

EXECUTE sp_MSforeachtable

'EXECUTE master.dbo.xp_cmdshell ''osql -E -S "MYSQLSERVER" -d "MyDB" -q "sp_help ''?''" '...

maylar (4/7/2016)

---

So far the online docs have been worthless. I don't need to learn about databases, I just need to understand how to navigate within this admin tool. I've worked...

As I figured, you're employees and products are unrelated, but somehow you want them both on the same data set. As you're trying to describe projects, maybe a single row...

You could use the NTILE function.

WITH

E(n) AS(

SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

),

E2(n) AS(

SELECT a.n FROM E a, E b

),

E4(n) AS(

...