Viewing 15 posts - 136 through 150 (of 212 total)
I believe your select query should look like:
select distinct #TempA.NameA, #TempC.NameC
from #TempA
inner join #TempB
on id_a = fkid_a
inner join #TempC
on fkid_C = id_c and id_c = 2
_________________________________
seth delconte
http://sqlkeys.com
February 23, 2011 at 1:13 pm
Querying sys.database_files will also give you some of that info.
_________________________________
seth delconte
http://sqlkeys.com
August 18, 2010 at 11:27 am
andrewkane17 (8/17/2010)
_________________________________
seth delconte
http://sqlkeys.com
August 17, 2010 at 1:24 pm
Take a look at the SUBSTRING function:
http://msdn.microsoft.com/en-us/library/ms187748.aspx
_________________________________
seth delconte
http://sqlkeys.com
August 2, 2010 at 1:08 pm
James Tech (8/2/2010)
Steve Jones - Editor (8/2/2010)
How are you querying it? Same query? same permissions/user account?varchar(50) shouldn't be an issue in terms of size/type.
Yes it is the same...here is the...
_________________________________
seth delconte
http://sqlkeys.com
August 2, 2010 at 12:44 pm
I'm not absolutely positive this is the way to do it - if someone can confirm that these instructions are correct, that would be great:
Under SQL...
_________________________________
seth delconte
http://sqlkeys.com
July 23, 2010 at 10:56 am
Is the SQL Server service started? Check Windows Services (Start/Run/services.msc) for MSSQLSERVER or MSSQL$SQLEXPRESS.
_________________________________
seth delconte
http://sqlkeys.com
July 23, 2010 at 10:21 am
Marv-1058651 (7/22/2010)
Thanks for your advice.I tried that SQL on a view and i recieved the error below:
"Cannot create index on view '[ViewName]' because the view is not schema bound"
To...
_________________________________
seth delconte
http://sqlkeys.com
July 22, 2010 at 3:02 pm
Jeff Moden (7/16/2010)
seth delconte (7/16/2010)
I think there's a way to do that other than running Profiler to record the queries...Cool... what is it?
Typo...I meant I DON'T think there's a way...
_________________________________
seth delconte
http://sqlkeys.com
July 16, 2010 at 3:52 pm
Check to make sure that TCP port 1433 is not being blocked by a firewall; use Server Network Utility to make sure TCP/IP is enabled.
_________________________________
seth delconte
http://sqlkeys.com
July 16, 2010 at 1:22 pm
I think there's a way to do that other than running Profiler to record the queries...
_________________________________
seth delconte
http://sqlkeys.com
July 16, 2010 at 1:12 pm
ALTER TABLE changed_data ADD query_run VARCHAR(255) NULL ;
GO
http://msdn.microsoft.com/en-us/library/ms190273.aspx
_________________________________
seth delconte
http://sqlkeys.com
July 16, 2010 at 12:13 pm
Skipping the schema by using two dots just tells the server to use the default schema (usually dbo). AFAIK, there is no efficiency gain by using this, I think...
_________________________________
seth delconte
http://sqlkeys.com
July 15, 2010 at 3:06 pm
Does your job use xp_sendmail? Is the table a permanent one or a temp table? When referencing the table, try using the 3-part table name ('dbname.dboname.tablename' if static...
_________________________________
seth delconte
http://sqlkeys.com
July 15, 2010 at 8:30 am
Can you try creating a SQL Server login on the SQL Server (you are using mixed mode, right?) and test that login? Is the problem on the server or...
_________________________________
seth delconte
http://sqlkeys.com
July 15, 2010 at 8:13 am
Viewing 15 posts - 136 through 150 (of 212 total)