Can anyone tell me what a jagged red line next to the server symbol in the enterprise manager means?. (Also how can I get rid of it.) It started when I was practicing the sp_attach_db / sp_detach_db procedures. I have looked at all the symbols in the on line books but it is not shown.
Hi, for some AP issue, the file I upload must be without the line feed/carriage return in the last line. for example:
original fixed-length file (exported from SSIS) line NO DATA 1 AA123456 50 60 2 BB123456 30 40 3 CC123456 80 90 4 <-- with line feed/carriage return in the last line
The file format that AP request. The file only has 3 records, so it should end in the third line. line NO DATA 1 AA123456 50 60 2 BB123456 30 40 3 CC123456 80 90
Should I use script component to do it ? I am new for VB . Anyone would help me ?
I need the Trend line for the following data in Line chart they are the following data. The following are the graph are my output and i need the trend line for these Key_gap value.
This is the link [URL] ....
I need the same trend line for the Bar-Chart in SSRS 2005.
I hope I'm posting this in the correct forum (forgive me if I'm not) since I'm not sure if this is an issue with inserting an item into a db or the processing of what I get out of it. I wrote a basic commenting system in which someone my post a comment about something written on the site. I wanted to keep it very simple, but I at least want the ability for a user to have newlines in their comment without having to hardcode a <br /> or something like that. Is there a way for me to detect a newline if someone, for example, is going to their next paragraph? Let me know if you need a better explanation. Thanks in advance!
G'day everyoneThat's a space between the ticks.It's all part of a longer script but seeing as the failure occurs online 1if exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[config]') and OBJECTPROPERTY(id, N'IsUserTable') =1)drop table [dbo].[config]GOThat's three lines only. Does it matter that they're in Unicode?Any ideas?Kind regards,Bruce M. AxtensSoftware EngineerStrapper Technologies
We have a line graph which plots the actual data points (x,y), everything is working fine with this graph. Now we need to add a trend line to this existing graph after going thro. the articles we came to know that there is no direct option in SSRS to draw a trend line. So we need to calculate the trend values ourselves which we need to plot as atrend line. This trend line is similar to the trend line which comes in Excel chart, do anyone know how to calculate the trend values from the actual data points. We got through several formulas, but were not clear, have anyone tried out exactly the same, if so please help us out by providing an example to calculate the trend values.
I have a line graph which shows positive and negative values. Is it possible to have the line one color when its negative and another when its positive?
Hi If i use this code i cant get the data showed, it show nothing."SELECT COUNT(DogImageDate) AS Amount, DogImageDate, DogImageID FROM EnggaardImages WHERE DogImageDate NOT LIKE (SELECT TOP 1 DogImageDate FROM EnggaardImages ORDER BY DogImageDate DESC;) GROUP BY DogImageDate ORDER BY DogImageDate DESC;" But if i use this code i get data showed"SELECT COUNT(DogImageDate) AS Amount, DogImageDate, DogImageID FROM EnggaardImages GROUP BY DogImageDate ORDER BY DogImageDate DESC;" Then i get Images(6)Images(1)Images(1) But i dont want the first to be showed, therefor i use the Select TOP 1, so i get a look like this Images(1)Images(1) But i cant get it to work.
Hello all Trying to delete some data from a SSCE (2005) DB produces the exception: SqlCeException There was an error parsing the query. [ Token line number = 1,Token line offset = 43,Token in error = C] Here is the code I am using
I'm trying to insert some values into an SQL Compact database on a WM6 device but there is something apparently wrong with my SQL statement...
The program is going to allow users to schedule an SMS message to be sent at a certain date and time. I'm using a database to keep track of the scheduled SMS messages. The database has 3 rows: phone number, message, and the date/time to be sent.
I'm guessing it doesn't like how I am trying to get the data from the different text boxes and the DateTimePicker to go inside the SQL command. Does anyone have any ideas on how to fix my SQL command or how to get data from a textbox and DateTimePicker to be inserted into a database a different way?
Hi, i've got a table which holds a field called order. Let's say it looks like this
ItemId Name Order 223 test 1 1 542 test 5 34 23 test 2 4 676 test 123 2
I'm building a website, which gets the records by the right order. So it displays this on the website:
test 1 test 123 test 2 test 5
Now, I'm building a up/down function. So when I click down on 'test 123' it should swap the order with 'test 2'
So the database will look like this: ItemId Name Order 223 test 1 1 542 test 5 34 23 test 2 2 676 test 123 4
And the website will look like this:
test 1 test 2 test 123 test 5
And it should also work the other way around with the up button.
So my guess is, I have the order of the item I clicked on (2) and I should get the order of the previous or next record (depending on which button I clicked). So how would I do that?
'So whats the SQL server 2005 Express Edition gonna be called here?
sub openconn ' open a connection to access db' dim tries set conn = CreateObject("ADODB.Connection") 'prep connection' set rs = CreateObject("ADODB.Recordset") ' prep recordset' tries = 0 ' clear tries counter' do 'try to open connection to the db conn.open "DRIVER={Microsoft Access Driver (*.mdb)};" &_ 'CHANGE THIS STRING FOR SQL CONNECTION "DBQ=" & RouteFile & ";DefaultDir=;UID=;PWD=;" tries = tries + 1 if (err.number <> 0) then 'if errored, close this connection conn.close end if Loop While (Err.Number<>0) And tries < 10 'if errored, try again. MAX TRIES = 10 end sub
I wanted to know how to insert line breaks while updating the database. Even if I have a number of paragraphs......everything is displayed as one single paragraph. How do i display text in paragraphs ?
I just started at a client's site and have found that the Books On Line has been removed (all other items are there in the program group instead of BOL). Is there a site at microsoft that mimicks BOL? (sybase has a 'sybooks on the web' which mimicks their 'Sybooks' product documentation.
Hello! I have the database out of line, but it doesn't have suspect status. As I know in SQL Server 6.5 I can run sp_marksuspect stored procedure for this database and then try to reset suspect status. But I didn't find sp_marksuspect in SQL Server 7.0. Do you know something about changes for 7.0 and do you have idea what should I do to put database back on line. I can even drop it to recreate and restore. Thank you, Anny
Hi, Can smeone help me with finding out the line count for all the sp's in a database?I tried a lot but could not find the result for this..Please someone help. Thanks
Hi all I am new in the forum and in SQL I have this code
Code:
SELECT PersPlac.Name, Zoom1.Descr, Client.PersonID, Client.Name AS CLIENT_NAME,ClientCu.Period,ClientCu.YearID,IVPeriod.PrdDescr,(ClientCu.DebitP/((InvVAT.VATVal+100)/100)),InvVAT.VATVal FROM Client RIGHT JOIN Salesman WITH (READUNCOMMITTED) ON (Client.SalesmanAA = Salesman.AA) LEFT JOIN PersPlac WITH (READUNCOMMITTED) ON (Client.Place = PersPlac.Code) LEFT JOIN Zoom1 WITH (READUNCOMMITTED) ON (Client.Zoom1 = Zoom1.ID) LEFT JOIN CLIENTCU WITH (READUNCOMMITTED) ON (CLIENT.PERSONID=CLIENTCU.PERSONID) RIGHT JOIN InvVAT WITH (READUNCOMMITTED) ON (CLIENT.TAXCAT=InvVAT.TAXCAT) RIGHT JOIN IVPeriod WITH (READUNCOMMITTED) ON (ClientCu.Period = IVPeriod.PeriodID) WHERE Salesman.Name='ΚΟΡΜΠΟΣ ΦΩΤΙΟΣ' AND ClientCu.Period<>0 AND PersPlac.Name<>'Εικονική Γεωγρ. Περιοχή' AND Client.Name='ΦΩΤΕΙΝΙΑ ΑΝΝΑ' and InvVAT.VATVal in (13,19)
the code run fine but every line is turn back 4 times. Why?
I have this report that I am trying to create, below is my statement. My problem is that the billing address and provider address is in the same field. I wanted to create another column as I did called “BillingAddress1� so that I can have the Prodider address on the same line as the billing address, is this possible? How does it work?
Here is an example of my data.
I want to keep the Provider office in the provider column which is fine(300 Community Dr), but I want to have the billing address (P.O. Box 5200) to be in the Billingaddress1 column on the same line as the provider address. Can this be done? Even though we are working from the same field?
Select Distinct p.pro_id1, p.PRO_TAX1 as "TaxID", p.Pro_XTYP as "ProviderType", p.Pro_XTYP as "ProviderTypebill", p2.Pro_XTYP as "ProviderTypebill", p.PRO_Office as "PracticeName", p.Pro_Lname as "ProviderFirstName", p.Pro_Fname as "ProviderLastName", p.Pro_sys as "System affiliate Field367", --v.val_desc, p.pro_pcs as PCS#, p.pro_spec1 as "Specialty1", p.pro_spec2 as "Specialty2", p.pro_spec3 as "Specialty3", p.pro_spec4 as "Specialty4", p.pro_degree as "ProviderDegree",
p.pro_addr1 as "ProviderAddress1", p2.pro_addr1 as "BillingAddress1",
p.pro_addr2 as "ProviderAddress2", p2.pro_addr2 as "BillingAddress2",
p.pro_city as "ProviderCity", p2.pro_city as "Billing Address2",
p.pro_state as "ProviderState", p2.pro_state as BillingState,
p.pro_zip as "ProviderZip", p2.pro_zip as "BillingZip",
p.pro_phone as "ProviderPhone", p.pro_fax as "ProviderFax", p.PRO_BTAG --pro2.PRO_BTAG ---Need Billing address, billing city, billing zip
FROM dbo.pro p JOIN pro p2 ON p.pro_id1 = p2.pro_id1
I need help figuring out how to consolidate duplicate records. For example We have a termed client same info until you get to the number of live because they are different. How can I take a both these lines and have them combined. There are other clients that are dups too. Please help if you can.
25-001610270-00000-00013 WEXFORD HEALTH SOURCES 12/31/200747 25-001610270-00000-00013 WEXFORD HEALTH SOURCES 12/31/200775
Dear all, I wanted to write a select statement which display the letter A in the first line and B will be in the second line.
The below second statement achieve my goal. But the first one is not displaying as i expected. How can i write the select statement to display the letters(A&B) in different line. Please let me know.
Hey guys. I feel like the prodigal son that has returned. It's been while! In your experience, what is the most like kind of cause to the cpu graph sitting quite high most of the time along with a constant second graph line in red at around the 10% line.
I feel that my aim should be to get rid of the red line alltogether. I've got a few ideas, but I don't know for certain how to target that particular symptom. Any suggestions?
Using Query Analyzer, I can right click on an object and select "scriptobject to new window as create" and I get the text of the object'sdefinition (schema). Can I get same result from command line, i.e., fromosql, I can get text output for the definition of the object (something likedefncopy under Sybase)? If so, what is the command or store procedure name?Thanks in advance.