Search results for query: *

Hi all, I'm trying to understand the code below, with (+). Comming from MS-SQL server, I never seem this before. Can some explain what the (+) does? thanks SELECT tblA.FIRST_NAME, tblA.lAST_NAME, tblA.STREET_NUMBER, btlA.CITY FROM tblA, tblB WHERE...

Hi all, I need to generate a report to show all current user(s) login the Active Directory. Anyone have the script, or point me to the right direction? This is a Windows 2003 Domain server. thanks

I have the following in the table: id QTY_IN Price_IN QTY_Out Price_out 1 150000 10.01 150000 10.01 2 15 10 5 15 3 25 12 35 18 4 25 20 35 25 5 45...

Hi all, Beside the boot-up screen, Is there a way to identify which raid configuration the server is using? computer spec: Windows Server 2003: Dell Prec 5/i Adapter Raid thanks

If col1 is null... this statement doesn;t seem to work. update table set col1=col1 +'-VAR' where id=idNumber. Alway return Null value. this will work update table set col1=isnull(col1,'')+'-VAR' where id=idNumber Can anyone explain this? I'm using sql 2000.

I need to update the resx column with the following: Id num resx 151 686 NULL 152 686 3 153 686 X3 154 41 NULL 155 41 3 156 768 NULL 157 768 3 158 462 NULL 159 462 Y 160 642 NULL 161 642 3 162 098 NULL 163 098 3 164 537 NULL 165 537...

I need to check to see if the columns from the table are empty or the length not long enough. Currently this is what I got...is there a better way to write these: INSERT INTO #tmpTBL SELECT col1 FROM tbl WHERE ISNULL((col1,'')='' or len(col1) < 5) INSERT INTO #tmpTBL SELECT col2 FROM tbl...

I think I a bit over my head here, but can some take a look at the code and give me suggestion how to write this better. thanks select sum (case when count(*)<> 0 then 1 else 0 end) from ( select fname + lname+ address + city+ state+ cast(zip,varchar(5)) as tbl from tbl1 union all select...

These two statement seem to be doing the same job when purging the data from table: truncate table table1 delete table What is the benefit if any over using them? When should once be uses over an other? thansk

running the sp_spaceused the following return: db size 48426.75 MB unallocated space 8098.20 MB. My question is will the db size continue to growth if I add more data, and leave the unalloactaed space alone or the new data will used the unalloacted space? If not, what % would you recommend on...

I need the following to be validate. the field contain 11 character (X8656787659) How ever, some of the data is just only 10. I want to select which field have only 10 character no include space. I have look up LEN, right function, but some how it is not return right value. The problem is the...

Is there an easier way to re-write this update, beside updating 1 at a time with the update statement? thanks UPDATE tbl1 SET col1 = '' UPDATE tbl1 SET col1 = col1 + '-YY' WHERE col2 IS NULL AND col3is IS NOT NULL AND col3is = 'Y' AND col3b = 0AND col2 IS NULL UPDATE tbl1 SET col1...

How do I assign the select value 'TotalSum' to the case below? thanks SELECT ID, SUM(when month1 =0 then '0' else Month1 END)+ SUM(when month2 =0 then '0' else Month2 END) as TotalSum, (CASE WHEN TotalSum > 0 and TotalSum < 100000 THEN 1 WHEN TotalSum >= 100000 and TotalSum <...

The following query is support to sort the state out in order, but I guess I must have been missing something. Can someone explain why this is not working and what I can do to resolve this. thanks --trying to sort them out in alpha select isnull(clmstate,''),count(isnull(clmstate,'')) from...

what is the best way to get the count of the columum if like the tree structure. If the first columun does not = 0 then go to the next columun and so on. if the columun match then count and go to the next row. eg: t-x-y-z-w 2-3-4-5-6 0-2-0-0-0 2-1-0-3-5 0-0-0-1-1 count return for t=2 because...

hi all, I a bit stuck with this problem. I trying to query the result if col1 have more then 1 and col2 is not the same, retrieve the fields. eg: table: col1--col2 1-----a 1-----b 1-----c 1-----c 2-----a 2-----b 2-----b 3-----a result want: 1,a,b,c 2,a,b thanks

I am having trouble when adding second node after the first node is up and running. when I bring the second node up, the drives I need on the SAN show up as unreadable. As a result, adding the second node fails because it cannot see the shared quorum drive nor the shared data drive. Am I...

Hi all, How would I go around to change the default location of the local quorum to a new partition? I had tried this http://support.microsoft.com/kb/283715 but it doesn't give the option to change or move to the new file. thanks

hi all, I need to insert multi row from a text box which contain multi email address separate by comma field. Anyone have example any where? thanks

hi all, how would I go around and transfer all the zones from primary to the secondary server? I created a zone and transfer from master, but this is only 1 zone. The primary dns have 300 zones entry, and it is a pain moving the 1 at a time. thanks