Viewing 15 posts - 2,146 through 2,160 (of 11,676 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,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 5, 2014 at 5:59 am
Could you post the query here, in plain text?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 5, 2014 at 5:25 am
*duplicate post*
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 5, 2014 at 5:13 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?)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 5, 2014 at 5:04 am
ronan.healy (8/5/2014)
if I...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 5, 2014 at 4:38 am
Grant Fritchey (8/5/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 5, 2014 at 3:27 am
Viewing 15 posts - 2,146 through 2,160 (of 11,676 total)