Try this:

from table1 inner join table2 on table1.col1 = table2.col1

where table1.ProductType ='Datasheet'

union

from table1 inner join table2 on table1.col1 = table2.col2

where table1.ProductType ='Manual'

The net result is that the first join will...

try taking out the parenthesis.

exec dbo.sp_Get_CDRL37_Data @wdate, @wdate

Try this:

-- Create temporary table

declare @test-2 table (acct int null, col1 int null, col2 int null)

-- Insert test data

insert @test-2 (acct, col1)

select 101,1

union select 102,2

union...

SSPI errors are normally caused by authentication issues where the user who is trying to access the database is not a user in the SQL instance. Other cause could be...

When you are looking to restrict the DISPLAY of the answer, unlike the precision (as you first asked), it would normallly be handled by the front end application that is...

Try converting the demand_q and the forecast_q to decimal first....

sum(convert(decimal,demand_Q))

You will not be able to directly log in using an alternate account unless you have that account's password and can log in to the network.

However, there is a alternative....

Sounds like the view is selecting from another view, which is selecting from another view, which is .....

You need to look at the first view, see where it is selecting...

Microsoft Training will help. Choose Certifications from the left navigation bar.

Did you try to reinstall .NET framework? MSCORLIB is a part of the framework, maybe it got confused somehow?

To do that, go into Add / Remove programs and look for...

I am not an AD guru, just know enough to get in trouble, but that is something that I have run into using Windows Authentication. Not sure how you can...

Off the top of my head, there are a couple of pretty significant cons.

1- You will be allowing SQL to go outside of your firewall, which is never a good...

NT Authentication utilizes Kerberos. Could it be that the Kerberos Ticket Granting Ticket (TGT) is expiring?

Ken,

Your best bet would be to write a CLR based function to return the Lat / Long based on the address passed to it. This way it will be reusable...

When you say "hide access", are you referring to client connections or the ability to query the tables? All client access to see the tables would be done through SSMS...