yes you are right..

We need to install on the client machine /Sqlserver machine from which we are going to run the sql agent .

You can download odata component from the...

Yes it got solved..in my case odata was not installed on the machine from whic iam running the sql agent job.once i had installed it ran fine

Helloooo.Any update??

Hi..I was able to access sharepoint list using Odatasource but not sharepoint list view..Please help

Oh thanks for correcting..but do u gone through the actual issue I mentioned above?

Ofcourse..Yo are right..but I am confused with expressions,collections and connection strings ..Let me explain what I did after going through many sites..

I am using BIDS 2012

My tasks is to Get...

ok..if I need to compare only table schemas..can I get a query?

Also one issue is that.. two databases resides in diff servers and both them cannot be linked due to...

Hey..i got the reason after posting the query..Im clear now

Anyways Thanks a lot!

Thanks twin devil..this what im looking for..it helped me

One doubt is that how will a case stmt work in dynamic sql without being in quotes

Seems like it is not possible apart from the above 3

🙁

nooo

No ,From SSMS stored procedures

🙁

BRACES ARE MISSING IN UR QUERY

Below will work

CAST((@dividend / @divisor) AS decimal(15,2))

david.dartnell (9/5/2014)

---

Hi Indu,

Thank you for your response. Initially when I tried to specify the decimal values parameters, e.g.: DECLARE @dividend decimal(10,3), I was met with 'red underlines' in SSMS. However...