|
I got one solution : Here it is,-
SELECT *
FROM table1
WHERE attribute1 IN (SELECT * FROM dbo.fn1('ab'))
modified on Friday, April 15, 2011 10:13 PM
|
|
|
|
|
prasanta_prince wrote: I got one solution
Glad you got one yourself.
prasanta_prince wrote: Here it is,- SELECT * FROM table1 WHERE attribute1 IN (SELECT * FROM dbo.fn1('ab'))
BTW please put the code in code block always like below.
SELECT *
FROM table1
WHERE attribute1 IN (SELECT * FROM dbo.fn1('ab'))
Cheers.
|
|
|
|
|
Thanks , i will do it from next time..
|
|
|
|
|
SET @my_variable =SELECT dbo.my_function(@my_function_parameter)
|
|
|
|
|
Hi,
I am creating a Schema Bound View on Database 'B', which contains select statement from Database 'A'. I searched and i found that i schema bound view must refer same database objects only.
My original aim was to create Index on view, to boost performance. Is there any other way to boost performance or create index on views? View is center of access and is already being in use in most projects, so i have to do everything with this view only.
Note: I only have select access to Database 'A' and no DDL operations.
Thanks.
♫ 99 little bugs in the code,
99 bugs in the code
We fix a bug, compile it again
101 little bugs in the code ♫
|
|
|
|
|
hi..
i'm facing a new problem in ssrs reports ...
i have hosted an asp.net application which is running fine in XP..
but when i open the application in UBANTU OS application is working
fine but reports in kannada are not displaying
it is displaying some russian character .. same problem when i
export to PDF it is displaying some russian character..
In windows XP prof3 Kannada reprots are working fine..
but in ubantu OS it is not displaying the fonts..
what to do... ? help me....
|
|
|
|
|
1) Try to use Unicode instead of a special Windows code page.
2) Indian fonts are not very common, I wouldn't expect to find any Indian fonts except perhaps Devanagari on a "normal" computer. You have to install the fonts. In Ubuntu (I guess you mean Ubuntu when you say Ubantu), some South Indian localizations are available for the system, I don't know for Kannada. Just install some of these localizations, and the respective fonts will also be installed. Then test with Firefox and a web page in that language.
Oh, let's try:
ಕರ್ನಾಟಕ
|
|
|
|
|
how can i creat a report for databse i have in c# ?
|
|
|
|
|
Assuming you are using Visual Studio ... you would add a Crystal Report to your project.
Do a search on Crystal Reports here in CodeProject and you will find all kinds of articles on how to use it.
|
|
|
|
|
|
|
Yes it is. And since it's native for Sql Server, I'd say you have lot's of opportunities when you play with it
|
|
|
|
|
codeproject is may interested site and is my project for software engineering 2 in university
.please send me the er of codeproject.com
|
|
|
|
|
r.kh wrote: please send me the er of codeproject.com
er?
|
|
|
|
|
that looks more like a question, not an answer.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
You are right, of course!
|
|
|
|
|
Yes ... What do you mean by er ??
|
|
|
|
|
prasanta_prince wrote: What do you mean by er ?
I don't know, what do you mean by er?
|
|
|
|
|
I trust the Emergency Room is strictly staff only, the Evaluation Report is a work in progress, the Equipment Required is simply more, and the Entity Relationships are a business secret.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
You forgot Encryption Rights. Although they are tough to decrypt.
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
The OP clearly was familiar with them already.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Luc Pattyn wrote: Emergency Room
|
|
|
|
|
codeproject <-- there they are!
|
|
|
|
|
I can send you the ar of CodeProject, the ur of CodeProject, and the ir of CodeProject but we ran out of er's last week. Sorry.
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
you are bad, you may be the worst of us all.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|