Search results for query: *

This query still produces results that are wrong. It should never return any crc unless it = 'error' and it does. Second, it should only return results where there are more than 2 records with the same phone number for those records where the crc = 'error' select calldatetime, crc, projname...

In any SQL Server 2005 job I create on my server, if I specify SQL Authentfication to run that job, put the information in, then click OK to close, it never sticks. I open back up the job and it resorts back to the Windows Authentification Setting again. Is this a bug? Bad install? What?

I just did a reinstall of SQL Server 2005 after backing up a database. I restored the database. I noticed I had to drop one of my users who still existed in sysusers because I needed to recreate that user in the new fresh install of SQL Server 2005. Ok, so I did that. If I logon to my...

I'm trying to figure out why the Variable CustomerName is null. I need to verify if my syntax for all in this Sub is formed well: Sub SendEmail_ElBalazo() Dim mailObj As New MailMessage Conn.Open() Dim myvalue As Integer = 1 Dim cmd As SqlCommand = New...

I'm not sure why I am still getting this connection error www.photopizzaz.biz/allcode.txt

how can I make the value for the output parameter below available to all my subs in my code behind class? This is in one of my Subs but I want to share it out: Dim NewCateringOrderID As New SqlParameter("@NewCateringOrderID", SqlDbType.BigInt) NewCateringOrderID.Direction =...

the portion of my query was working fine, nothing has changed except that I went from 30 to 20 for the dateadd function. Now when my query runs, I get CallDateTime that is not between the current time and 20 minutes prior, I get CallDateTime that is even from a month ago which is not right...

Not sure why I am not able to check whether > 1 for 'error': SELECT @RESULTS = ISNULL(@RESULTS + '', '') + CHAR(13) + 'Phone Number: ' + LEFT(PhoneNum, 3) + '-' + SUBSTRING(PhoneNum, 4, 3) + '-' + SUBSTRING(PhoneNum, 7, 4) + ' Call Date: ' + convert(varchar(20),CallDateTime,101) + ' HistoryID...

I currently can't connecto to my database in SQL Server 2005 (enterprise) but as soon as I try to use any functions, I get cryptic errors found below. I am about to pull my hair out. Everything was working fine for around 4 days and now everything just blows up. I've tried using both sql...

I keep getting this error below no matter how many times I tweak my SQL Server 2005 login. I am wondering if just VS can't handle it in debug mode or what the real problem is here: <appSettings> <add key="Econn" value="Server=****;uid=testit;pwd=***;database=integration_services_en;"/>...

Insert into dbo.E_FINAL (TDate, TTime, ANumber, TCode, FieldCode, NewValue, IFlag, RCode, AS_400_UserID, ProductLoanTypeCode, NotUsed) Select GetDate(), GetDate(), @AcctNumber, fc.FieldCode, @CaseNumber, 'I', ' ', ' ', ' ', ' ' INNER JOIN dbo.E_Field_FieldCode fc ON...

How can I loop through each field in the current record in a cursor? I need to essentially do 2 loops. One loops through each record and then inside each record row, I want to perform an insert on each column. Something like this maybe using a cursor or something else: For each record in my...

Need to know the exact table(s) that can tell me (programmer) a list of active users in our Vantive 8.2.2 system. I need this for a report for our manager as we get rid of Vantive but I can't see any active flags in tables such as SW_USER and I don't even know for sure what tables I should be...