Viewing 15 posts - 211 through 225 (of 7,428 total)
How are you trying to make the connection? And have you tried using VBScript to confirm you are able to connect to 2k5 Express?
December 4, 2007 at 10:35 am
This is what I personally use
select 'exec sp_change_users_login ''AUTO_FIX'',''' + [name] + '''', * from sysusers where status != 0 and uid > 2
it builds a string for each account,...
December 4, 2007 at 10:33 am
You should be able to as long as you have the client drivers installed.
December 4, 2007 at 10:23 am
As ramesh stated you can to charcter types, if you need to go to numeric you have to CAST twice. Also, when dealing with trying to cast to numeric types...
December 4, 2007 at 9:38 am
AVB (12/4/2007)
I did create a PK/FK relationship between the two child tables and the Parent table. This PK/FK ID can only exist in only one...
December 4, 2007 at 7:08 am
AVB (12/3/2007)
December 3, 2007 at 3:17 pm
Matt Miller (12/3/2007)
December 3, 2007 at 3:12 pm
Basically will you need to handle any extended character lanuages such as chinese or have special characters that don't esit in the default set?
December 3, 2007 at 3:00 pm
Sergiy (12/3/2007)
Can anybody give me one simple reason for those RTRIM functions you guys put everywhere?
I did it becuase the original poster did just to be sure I didn't cause...
December 3, 2007 at 2:40 pm
The question about adding the column from the clustered index to others is this. All non-clustered indexes include the clustered value itself up to a length of I think 64...
December 3, 2007 at 11:05 am
Be carefull it is very easy to overcomplicate a task when you are still trying to understand it.
Here are my assumptions
1) Table Relationships
Gov_regions_mining_score_TEMP to Region_lookup via Gov_regions_mining_score_TEMP.Region_key =...
December 3, 2007 at 10:20 am
If you want one resultset with both values against each other then I assume SM is unique in Indicators_for_regions_Both so you could do this to have together as one set.
SELECT
A.Disease_S,
B.Disease_SC
FROM
(
--...
December 3, 2007 at 10:09 am
With that last statement it seems to me like you want this.
-- This will give you all SMs where Disease S has occurred regardless of SC occurring.
SELECT
I.SM as Disease_S
FROM...
December 3, 2007 at 10:02 am
Or as I suspect after thinking a hair more you want All SM's from regions that have experieced both Disease Types then this may actually be your item.
SELECT
I.SM
FROM
dbo.Indicators_for_regions_Both I
INNER JOIN
(
SELECT...
December 3, 2007 at 9:54 am
Viewing 15 posts - 211 through 225 (of 7,428 total)