Viewing 15 posts - 121 through 135 (of 583 total)
Maybe what you are looking for is UNION. That is a way to write two queries that don't have to have anything to do with each other and combine them. ...
October 5, 2006 at 3:19 pm
OK, going back to a previous question, you said you created a user and mapped it to DBO. What Login is mapped to DBO?
October 5, 2006 at 3:14 pm
So, is the web server on the same box as the SQL Server instance? If not, you need to specify the Server name in the connection string.
Server=SERVERNAME\SQLExpress;Persist Security Info=True; user...
October 5, 2006 at 2:56 pm
Are you sure that any account can access the SQL Server remotely?
What is the LOGIN name of the account that you mapped to DBO?
October 5, 2006 at 2:29 pm
No worries, thank your co-worker for me.
SSIS is hard to learn, but once you get the hang of it, it's not bad. I hope the book will give people the...
October 5, 2006 at 2:07 pm
It's easy enough to create a unique name, but now that I think about it, if the temp table has a unique name each time, then you'll have to use...
October 5, 2006 at 1:51 pm
You probably need to come up with a unique name for the table everytime the proc runs and then drop the table at the end of the proc. Otherwise, if...
October 5, 2006 at 1:26 pm
I haven't been keeping up with the Blog. I'm trying to do too many things! Thanks for buying the book.
October 5, 2006 at 12:56 pm
You should probably not be using a global temp table. Does any process outside of the proc need to use the temp table? If not, change remove one # so...
October 5, 2006 at 12:45 pm
The question said that the genID in Y is a foreign key to A,B,C. So, please explain the relationship between Y and A,B,C. Or better, yet, if you could provide...
October 5, 2006 at 12:34 pm
Sorry about that, I haven't been able to get the object_id function to work with the temp table either.
You could just do it like this:
IF
October 5, 2006 at 12:29 pm
Unless I'm missing something, I don't see a reason to use an Outer join from your description. Here is the from clause that I think you need:
X
October 5, 2006 at 12:14 pm
Are you working with one login or two? If you are working with same login in both steps, you have already given the login access to the database when you...
October 5, 2006 at 12:01 pm
Try this in your ORDER BY clause:
CASE
WHEN
ISNUMERIC(locationCode) = 0 THEN locationCode
October 5, 2006 at 11:37 am
Temp tables live in the tempdb database. So you could do this:
if exists (select * from tempdb.dbo.sysobjects where id = object_id(N'[dbo].[##temp_test123]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[##temp_test123]
October 5, 2006 at 11:02 am
Viewing 15 posts - 121 through 135 (of 583 total)