Viewing 15 posts - 6,781 through 6,795 (of 13,876 total)
michaelfeldman (8/24/2016)
The variables are case sensitive and that solved my issues. I thought that reference was undervalued and was curious if the forum has since discovered better solutions?
Which reference?
What do...
August 24, 2016 at 8:14 am
What do these workflows do?
If you are interacting with data sources and destinations, particularly SQL Server, SSIS offers built-in features which should help speed up development.
August 24, 2016 at 7:44 am
BrainDonor (8/24/2016)
Now I haven't looked at JSON within SQL Server - my fun with that has...
August 24, 2016 at 5:38 am
GilaMonster (8/23/2016)
I suspect Phil meant to apply the traceflag just to the problematic query, not enable it system-wide.
Correct suspicion.
August 23, 2016 at 3:17 pm
This construction is probably causing issues:
final_salary = CASE when eng.placement_name IS NULL THEN '' else eng.final_salary end,
because '' is not numeric.
August 23, 2016 at 1:58 pm
SELECT *
FROM @Cities c1
WHERE NOT EXISTS ( SELECT c2.CityName
...
August 23, 2016 at 10:27 am
SQL Guy 1 (8/23/2016)
August 23, 2016 at 10:10 am
If you tie the structure of your database to a VCS, this requirement should be unnecessary 🙂
I therefore assume that you do not have this in place (I suggest you...
August 23, 2016 at 10:07 am
fanindrabhortakke (8/23/2016)
I have one sql job scheduled every 10 min to run. It mainly does some calculation and then dumps results into one table. It sometimes takes 6-7 minites maximum...
August 23, 2016 at 8:20 am
Drew is correct. But here is an outline of what I think you are trying to do:
insert tableC (c1, c2, c3)
select c1, c2, c3 from tableB b
where exists (select 1...
August 22, 2016 at 1:16 pm
komal145 (8/22/2016)
Thanks Phil for replying. It works.
Cool, no problem.
August 22, 2016 at 9:12 am
liorvikel (8/22/2016)
RESOLVEDMY DC was low function
Please elaborate. DC = Domain Controller? Direct Current?
August 22, 2016 at 9:11 am
komal145 (8/19/2016)
hi,I am having difficulty writing expression to get the value from a string .
example:
E:\Temp\ATT_Hierarchy\Test_COR.xlsb
Need the value "Test" from above string in ssis expression.
I created a string parameter called...
August 21, 2016 at 11:25 am
Alan.B (8/19/2016)
I have a couple ideas I'll play around with when I'm at a PC shortly.non-nullable Tinyint having (-1,0,1) as possible values
tinyint can't be negative 😉
Oops! You can tell...
August 19, 2016 at 8:26 am
drew.allen (8/19/2016)
UPDATE #test
SET Flag = @Flag
CROSS APPLY (
SELECT...
August 19, 2016 at 7:57 am
Viewing 15 posts - 6,781 through 6,795 (of 13,876 total)