Viewing 15 posts - 2,146 through 2,160 (of 11,678 total)
Dinesh R. Nandwalkar (8/5/2014)
Parameter query where am using multivalueselect distinct hr_agreement_contract.atct_contract_status
from hr_agreement_contract
where isnull(hr_agreement_contract.atct_contract_status,'') not in ('A','L','P')
Union
select 'A'
Union
select 'L'
Union
select 'P'
This is the query that fetches the value for the parameter,...
August 5, 2014 at 5:59 am
Could you post the query here, in plain text?
August 5, 2014 at 5:51 am
hjvegt1960 (8/5/2014)
Enterprise it is
Developer edition costs around 60 dollar.
I hope you didn't pay more for the enterprise version.
August 5, 2014 at 5:25 am
On a sidenote: why doesn't the business want a SP or temp table? Any reasons for that decision?
(and why is the business meddling with technical stuff?)
August 5, 2014 at 5:13 am
You could use a table variable instead of the temp table. Be aware that this might have an impact on performance.
Do you need a temp table by the way? Maybe...
August 5, 2014 at 5:12 am
Dinesh R. Nandwalkar (8/5/2014)
I have developed report with parameter having multi value option. The report was developed in Microsoft Visual Studio 2010 and having SQL 2012.
Acceptance environment report...
August 5, 2014 at 5:10 am
Is there a way you can uninstall SSDT first?
If that doesn't work, you can perhaps download the Visual Studio 2012 version of SSDTBI, which can work with SSIS.
ps: I hope...
August 5, 2014 at 5:04 am
ronan.healy (8/5/2014)
if I...
August 5, 2014 at 4:46 am
Not sure why it doesn't work. What if you put the code in a stored procedure and you call that sp with the OLE DB command?
On a sidenote: the OLE...
August 5, 2014 at 4:38 am
Grant Fritchey (8/5/2014)
August 5, 2014 at 4:35 am
Grant Fritchey (8/5/2014)
You get a phone call. The person on the phone says the database is slow. What do you do?
Migrate from Oracle to SQL Server? Do I get the...
August 5, 2014 at 4:32 am
TomThomson (8/5/2014)
edit: I'm amazed how many people fell for one of the two "only simple values, no expressions" options; and that only 44% got it right.
The Interwebz, they never cease...
August 5, 2014 at 4:30 am
ronan.healy (8/5/2014)
its a csv file and in the csv file is all in the 1 column so should be split out correctly
Are you opening it in Excel?
August 5, 2014 at 3:46 am
ronan.healy (8/5/2014)
I have a flat file then the replace. but after I read the falt file its like this
Counter...
August 5, 2014 at 3:27 am
Viewing 15 posts - 2,146 through 2,160 (of 11,678 total)