Viewing 15 posts - 3,076 through 3,090 (of 8,731 total)
This code is meant to be run in SSMS, then you can transform it into VB code. I would suggest to convert it to a Stored Procedure and call the...
April 11, 2016 at 7:36 am
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...
April 11, 2016 at 6:58 am
shaneoneillis (4/11/2016)
You may want to let us know how you got your variables as it could help with the answers to this.
Also with this
Need your help thanks
do...
April 11, 2016 at 6:25 am
Wild idea:
Instead of using dynamic SQL, use synonyms for the cross-database calls.
April 8, 2016 at 12:42 pm
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...
April 8, 2016 at 12:00 pm
crookj (4/8/2016)
Ed Wagner (4/8/2016)
TomThomson (4/8/2016)
Ed Wagner (4/8/2016)
Pork ChopKarate Pig
Kung Fu Panda
Splinter (Kung Fu Rat)
TMNT
April 8, 2016 at 7:01 am
Ed Wagner (4/7/2016)
Manic Star (4/7/2016)
Grumpy DBA (4/7/2016)
ThomasRushton (4/7/2016)
spanDenard
Obfuscation
Hide
Seek
April 7, 2016 at 11:21 am
mw112009 (4/7/2016)
[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...
April 7, 2016 at 11:20 am
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
...
April 7, 2016 at 11:09 am
Maybe the package is using an incorrect code page for your varchar column.
This is weird as it's changing the values completely.
April 7, 2016 at 10:49 am
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...
April 7, 2016 at 9:27 am
EXECUTE sp_help 'MEMBER_IN'
Or view dependencies.
April 7, 2016 at 8:20 am
ram302 (4/7/2016)
EXECUTE sp_MSforeachtable
'EXECUTE master.dbo.xp_cmdshell ''osql -E -S "MYSQLSERVER" -d "MyDB" -q "sp_help ''?''" '...
April 7, 2016 at 8:02 am
maylar (4/7/2016)
April 7, 2016 at 7:55 am
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...
April 7, 2016 at 7:37 am
Viewing 15 posts - 3,076 through 3,090 (of 8,731 total)