How To Monitor Store Procedure (Line By Line)
Sep 29, 2001HEllo can anybody tell me how to monitor a long store procedure
line by line. Also how to put progress bar in it to tell user how
much is done.
Sabih.
ADVERTISEMENT
How Can I Remove The Line Feed/carriage Return In The Last Line Of The Exported Text File ?
Feb 27, 2007Hi,
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 ?
Thank you all.
Reporting Services :: Draw Trend Line For SSRS Line Chart 2005
May 4, 2012I 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.
Storing And Retrieving Line Breaks/newlines From Multi-line Textbox (C#)
Aug 31, 2007I 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!
ISQL: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect Syntax Near ' '
Nov 8, 2006G'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
View 3 Replies View RelatedDisplaying A Trend Line (in Line Chart) In SSRS
Feb 7, 2007We 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.
View 1 Replies View RelatedDynamically Change The Color Of The Line On A Line Graph
Oct 26, 2007I 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?
kam
How To Store A Multi-line Textbox In MS SQL?
Feb 28, 2008Hello,I'm a newbie and I have a little problem that's starting to work on my nerves I want to store a multi line textbox in the database, just like the way it has been entered.I used a varbinary-field.This is my code in my aspx Dim myOptions As New InterTyp.Opties() Dim myCon As SqlConnection = myOptions.getCon() Dim cmdOef As SqlCommand Dim parmOef As SqlParameter cmdOef = New SqlCommand("GetOef", myCon) cmdOef.CommandType = CommandType.StoredProcedure cmdOef.Parameters.Add("@oid", System.Data.SqlDbType.Int).Value = ID 'output parmOef = cmdOef.Parameters.Add("@otext", SqlDbType.VarChar) parmOef.Size = 8000 parmOef.Direction = ParameterDirection.Output 'execute the query myCon.Open() cmdOef.ExecuteNonQuery() txtOef.Text = cmdOef.Parameters("@otext").Value myCon.Close()In my code i call a sp:CREATE PROCEDURE dbo.GetOef @oid integer, @otext varchar OutputAS SELECT otext FROM oefening WHERE (oid = @oid) So my problem is:How do i cast the varbinary back to a text?
View 2 Replies View RelatedBIDS Line Charts - Cant Remove Line?
Dec 12, 2007Hi,
When creating a line chart, I would like to be able to show Markers for the data points, but no line between these points (as you can do in excel).
I have set the line setting to none (for the lines of interest), however the lines still show.
Is this a bug, or am i missing something obvious settings-wise?
Cheers,
M
Line 1: Incorrect Syntax Near '-'. But There Is No '-' In First Line!
Dec 28, 2007 HiIt's my stored procedure 1 CREATE PROCEDURE singleSearch2
2 @SQ nvarchar(30),
3 @pType nvarchar(11),
4 @pCol nvarchar(11)
5 AS
6 BEGIN
7 DECLARE @SQL NVarChar(1000)
8 SELECT @SQL='SELECT *,'
9 SELECT @SQL=@SQL+' CASE RTRIM(LTRIM(op))'
10 SELECT @SQL=@SQL+' WHEN '+CHAR(39)+'e'+CHAR(39)+' THEN '+CHAR(39)+'اجاره'+ CHAR(39)
11 SELECT @SQL=@SQL+' WHEN '+CHAR(39)+'r'+CHAR(39)+' THEN '+CHAR(39)+'رهن'+CHAR(39)
12 SELECT @SQL=@SQL+' WHEN '+CHAR(39)+'f'+ CHAR(39)+' THEN '+ CHAR(39) +' Ù?روش '+CHAR(39)
13 SELECT @SQL=@SQL+' WHEN '+CHAR(39)+'e r'+CHAR(39)+' THEN '+CHAR(39)+ 'اجاره - رهن '+CHAR(39)
14 SELECT @SQL=@SQL+' WHEN '+CHAR(39)+'e f'+CHAR(39)+' THEN '+CHAR(39)+'اجاره - Ù?روش '+CHAR(39)
15 SELECT @SQL=@SQL+' WHEN '+CHAR(39)+'r f'+CHAR(39)+' THEN '+CHAR(39)+' رهن - Ù?روش '+CHAR(39)
16 SELECT @SQL=@SQL+' WHEN '+CHAR(39)+'e r f'+CHAR(39)+' THEN '+CHAR(39)+'اجاره - رهن - Ù?روش'+CHAR(39)
17 SELECT @SQL=@SQL+' ELSE op END AS xop, CASE LTRIM(RTRIM(type)) '
18 SELECT @SQL=@SQL+' WHEN '+CHAR(39)+'z -'+CHAR(39)+' THEN '+CHAR(39)+'زمین'+CHAR(39)
19 SELECT @SQL=@SQL+' WHEN '+CHAR(39)+'m -'+CHAR(39)+' THEN '+CHAR(39)+'مسکونی'+CHAR(39)
20 SELECT @SQL=@SQL+' WHEN '+CHAR(39)+'t -'+CHAR(39)+' THEN '+CHAR(39)+'تجاری'+CHAR(39)
21 SELECT @SQL=@SQL+' ELSE [type] END AS [xtype] FROM [data] '
22 SELECT @SQL=@SQL+' WHERE ([type] LIKE %'+CHAR(39)+@pType+CHAR(39)+'%) AND ('+@pCol+' LIKE %'+CHAR(39)+@SQ+CHAR(39)+'%)'
23 Exec (@SQL)
24 END
25 GO
and i face this error: Line 1: Incorrect syntax near '-'.
Line Chart - Line Styles
Jan 16, 2008
Hi
Anyone have any idea how to make a line style dashed or dotted in a line chart please?
If I change the series style to dashed or dotted it still appears as a solid line, yet the legend displays a dashed or dotted line....
Thanks
Style: Constraints - In-line Vs Out-of-line?
Apr 18, 2008My question is about coding style for specifying constraints when creating tables.
Two styles for defining constraints:
In-line:
CREATE TABLE Fruit
(
FruitID INT IDENTITY(1,1)
CONSTRAINT PK_fruit PRIMARY KEY CLUSTERED,
FruitName NVARCHAR(50),
FruitTypeID INT
CONSTRAINT FK_fruit_fruit_types FOREIGN KEY
REFERENCES FruitTypes (FruitTypeID) ON UPDATE CASCADE,
DateCreated DATETIME DEFAULT GETDATE()
)
Out-of-line:
CREATE TABLE Fruit
(
FruitID INT,
FruitName NVARCHAR(50),
FruitTypeID INT,
DateCreated DATETIME
)
ALTER TABLE Fruit ALTER COLUMN FruitID INT NOT NULL
ALTER TABLE Fruit ADD
CONSTRAINT PK_fruit PRIMARY KEY CLUSTERED (FruitID),
CONSTRAINT FK_fruit_fruit_types FOREIGN KEY (FruitTypeID)
REFERENCES FruitTypes (FruitTypeID),
CONSTRAINT DF_fruit_date_created DEFAULT
GETDATE() FOR DateCreated
Which style do you prefer and why?
Problem Showing Data From Select Line With Another Select Line In It
Apr 7, 2007Hi
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.
Msg 102, Level 15, State 1, Procedure Dni_invoices_get, Line 37
Feb 20, 2007
Hello,
I am using SQL express as a backend for my websites and my accounting software.
When installing my new app I run the install.sql file and all is good untill the end.
the following error occurs. Can someone direct me where to look to fix this please?
Msg 102, Level 15, State 1, Procedure dni_invoices_get, Line 37
Incorrect syntax near '.'.
Thanks eveningjazz
Msg 15600, Level 15, State 1, Procedure Sp_change_users_login, Line 207
Jun 20, 2007I restored a database to my test server from a production server. I ran "sp_change_users_login 'report' " and found 1 orphan id. Then I ran "sp_change_users_login 'auto_fix', 'orphan_id' ". It gets the error. I have run it before with success. Any idea why this time is different?
CLR Stored Procedure And Stack Trace Line Numbers
Sep 27, 2007Hello you all CLR stored procedure experts,
When a self-developed CLR stored procedure throws an Exception and the Exception is caught in the code and for example logged, there only are class and method names in the stack trace lines, but not the line numbers. Can the line numbers somehow be included in the stack trace?
I'm not familiar with .NET framework stack traces, but when I tried to find out more information I hit concepts like PDB files, are such things somehow needed to enable line numbers in stack traces?
Big thanks already in advance,
J
EXEC Stored Procedure For Every Line Of SELECT Result Table - How?
Jul 23, 2005Hello,Is it possible to EXEC stored procedure from a query?I want to execute stored procedure for every line of SELECT resulttable.I guess it's possible with cursors, but maybe it's possible to make iteasier.Give an example, please.Thank you in advance.Hubert
View 2 Replies View RelatedHow To Execute Stored Procedure By Command Line In Client's Computer ?
Nov 28, 2006I've a S.P. that need to execute in local PC, how can I execute ?
View 1 Replies View RelatedSQL Server 2012 :: Displaying Code Of A Stored Procedure To A Single Line
Sep 14, 2015Any better way to query SQL 2012 to display the code of a stored proc to a single line. I'm trying to write a script to insert the contents of the procs between my devestprod environments. So people can query a single table for any proc that is different between environments. At the moment I am using the syscomments view and the text column but the problem here is if you get a lengthy proc it cuts it up into multiple rows.
I can get around it by converting the text to a varchar(max) and outer joining the query, but as you can see by my code below I have to try and guess what the maximum number of rows I'm going to get back for my largest proc. If someone adds a new one that returns 8 rows I'm going to miss it with this query.
Select col1.[type],col1.[name],convert(varchar(max),col1.text) + isnull(convert(varchar(max),col2.Text),'')
+ isnull(convert(varchar(max),col3.Text),'')
+ isnull(convert(varchar(max),col4.Text),'')
+ isnull(convert(varchar(max),col5.Text),'')
+ isnull(convert(varchar(max),col6.Text),'')
+ isnull(convert(varchar(max),col7.Text),'')
[Code] .....
There Was An Error Parsing The Query. [ Token Line Number = 1,Token Line Offset = 43,Token In Error = C]
Jul 27, 2007
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
string dsc = Application.StartupPath + "\FCDB07.sdf";
conn = new SqlCeConnection("DataSource = " + dsc);
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText = "DELETE FROM DataContainer WHERE FileName =" + dgContainers[0, SelRowIndex].Value.ToString();
cmd.ExecuteNonQuery(); //There was an error parsing the query. [ Token line number = 1,Token line offset = 43,Token in error = C ]
conn.Close();
Any Idea on What causes this?
TIA
Trophus
Error Parsing Query: [ Token Line Number = 1,Token Line Offset = 83,Token In Error = 5 ]
Nov 23, 2007Hey all-
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.
Here is the relevent code:
private void scheduleMenu_Click(object sender, EventArgs e)
{
//connect to DB and do our scheduling magic
string message = messageBox.Text; //should rename messageBox...
string phoneNum = phoneNumBox.Text;
string dataBase = @"Program FilesSMS_Scheduler2SMSDatabase.sdf";
//SqlCeEngine eng = new SqlCeEngine(dataBase);
SqlCeConnection conn = new SqlCeConnection("Data Source=" + dataBase);
conn.Open();
//insert phone number, message text, and date/time into DB
string cmd = "INSERT INTO Scheduler(phoneNum, message, date) VALUES("+ phoneNum + ", "+ message + ", "+ dateTimePicker1.Value +")";
SqlCeCommand cmdPhone = new SqlCeCommand(cmd,conn);
cmdPhone.ExecuteNonQuery(); //error occures here...
messageBox.Text = "";
MessageBox.Show("Message Scheduled!");
}
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?
Get The Next In Line...
Apr 22, 2008Hi, 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?
Down To 1 Line Now
Jan 24, 2006'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
Line Breaks In SQl
Nov 12, 2001I 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 ?
Hope someone can help me out. Thanks in advance.
Books On Line
Aug 7, 2001Hi,
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.
Any help would be appreciated.
jim
Database Is Out Of Line
Mar 20, 2000Hello!
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
Jaggrd Red Line
Dec 18, 2000Greetings
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.
Many thanks in advance.
Sqlmaint Cmd Line
Jan 10, 2000I am having problems running sqlmaint against my servers.
From a command line I am running c:sqlmaint -S servername -U "username" -A "password" -D database -UpdSts as a test.
All i get is the list of arguments displayed. This never seems to work.
Any Ideas??
Line Count In SP's
Aug 25, 2004Hi,
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
Repeat Line
Jun 22, 2006Hi 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?
Thanks for the help
New Line In Query
Oct 5, 2006Hi,
I was wondering if there is any way I can place a new line inside a query...
e.g.
select field1 + 'NEWLINE' + field2 from tablename
I want to place a new line between field1 and field2
Thanks in advance
One Line For 3 Rows
Mar 27, 2007for MS SQL 2000
I am having :
Table1
ID | N1 | N2 | N3 |
-------------------
12 | A | | |
12 | | B| |
12 | | | C|
how can I get :
12,A,B,C ?
thank you for helping
New Line Character
Jun 18, 2008I have text in a description field which has a new line character which is causing the value from the column being displayed in 2 lines
'Receipt#
3 generated for the amount of $ 130.00'
How can replace the new line character with blank space ''.
Any suggestions and inputs would help
Thanks