Hi,
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 advanceselect field1 + char(13) + field2 from tablename|||Thanks for reply blindman
I have tried this already but it doesn't work :(
any other suggestions would be appreciated.
Thanks|||It works in query analyzer. What are you looking at the results in?
select 'a' + char(13) + 'b'|||I am using MSSQL 2005 Server Management Studio which replaces both the SQL Server 2000 Enterprise Manager and the Query Analyzer.
Thanks|||Odd. It still works for me.
select 'a' + char(13) + 'b'
--
a
b
(1 row(s) affected)|||Actually It works on the text mode result but not Grid mode ...still it doesn't save a and b on different lines in the database itself not sure why
Once I fetch the record it displays it on a single line...
On my other fields where I am saving text from my .net application textboxes it creates double boxes for a newline... I was wondering how would I create thoes double boxes :)|||Ahh, the grid is saving the carriage return, but it displays as a blank in grid mode.
-- Using Northwind
DECLARE @.MyText CHAR(26)
DECLARE @.MyText2 CHAR(26)
SET @.MyText = 'a' + char(13) + 'b'
PRINT @.MyText
SELECT ShipCity
FROM Orders
WHERE OrderID = 10248
UPDATE Orders
SET ShipCity = @.MyText
WHERE OrderID = 10248
SET @.MyText2 = (SELECT ShipCity
FROM Orders
WHERE OrderID = 10248)
PRINT @.MyText2
SELECT ShipCity
FROM Orders
WHERE OrderID = 10248
UPDATE Orders
SET ShipCity = 'Reims'
WHERE OrderID = 10248
Run this in text mode and you will see that the newline is saved.
Run this in grid mode and you will see that the newline is converted.
I hope this helps,|||Still it will show a one straight line when fetching that data ....what I am thinking now is create a tiny function in .net and add new lines there it did worked for my other data before....
"thank you all for the help guys this forum ROCKS :)"|||Why are you concerned with how it looks in Management Studio? Neither Management Studio or Query Analyzer is meant to be used as a user interface or reporting tool.
Showing posts with label line. Show all posts
Showing posts with label line. Show all posts
Friday, March 9, 2012
New Line in HTML
Hi,
I have a field header with multiline ( ascii chr(10) ). But it does not
shown in HTML but does in other formats. Because it is rendered as is and
not as <BR>.
Is it any way to show the newline?
TIA,
SamuelYou need both a carriage return and a line feed. (chr(13) and chr(10))
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Samuel" <samuel@.photoninfotech.com> wrote in message
news:%233t4P3$bEHA.2972@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a field header with multiline ( ascii chr(10) ). But it does not
> shown in HTML but does in other formats. Because it is rendered as is and
> not as <BR>.
> Is it any way to show the newline?
> TIA,
> Samuel
>|||Hi,
Thanks - It works.
Can you tell me the way to show multiple spaces instead of one space
( ) in HTML?
TIA
Samuel
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:%23mJoEZDcEHA.3804@.TK2MSFTNGP10.phx.gbl...
> You need both a carriage return and a line feed. (chr(13) and chr(10))
> --
> This post is provided 'AS IS' with no warranties, and confers no rights.
All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No
user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach
of
> children under 3.
> "Samuel" <samuel@.photoninfotech.com> wrote in message
> news:%233t4P3$bEHA.2972@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I have a field header with multiline ( ascii chr(10) ). But it does not
> > shown in HTML but does in other formats. Because it is rendered as is
and
> > not as <BR>.
> >
> > Is it any way to show the newline?
> >
> > TIA,
> > Samuel
> >
> >
>
I have a field header with multiline ( ascii chr(10) ). But it does not
shown in HTML but does in other formats. Because it is rendered as is and
not as <BR>.
Is it any way to show the newline?
TIA,
SamuelYou need both a carriage return and a line feed. (chr(13) and chr(10))
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Samuel" <samuel@.photoninfotech.com> wrote in message
news:%233t4P3$bEHA.2972@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a field header with multiline ( ascii chr(10) ). But it does not
> shown in HTML but does in other formats. Because it is rendered as is and
> not as <BR>.
> Is it any way to show the newline?
> TIA,
> Samuel
>|||Hi,
Thanks - It works.
Can you tell me the way to show multiple spaces instead of one space
( ) in HTML?
TIA
Samuel
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:%23mJoEZDcEHA.3804@.TK2MSFTNGP10.phx.gbl...
> You need both a carriage return and a line feed. (chr(13) and chr(10))
> --
> This post is provided 'AS IS' with no warranties, and confers no rights.
All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No
user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach
of
> children under 3.
> "Samuel" <samuel@.photoninfotech.com> wrote in message
> news:%233t4P3$bEHA.2972@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I have a field header with multiline ( ascii chr(10) ). But it does not
> > shown in HTML but does in other formats. Because it is rendered as is
and
> > not as <BR>.
> >
> > Is it any way to show the newline?
> >
> > TIA,
> > Samuel
> >
> >
>
New line in column?
Is it possible?
Sp1 said:
New Lines in Expressions
Previously, expressions had to be contained on a single line. With
SP1, expressions can include a newline character. New line characters
include carriage return (CR), line feed (LF), carriage return and
line feed (CRLF), paragraph separator (Unicode 2029), and line
separator (Unicode 2028). The newline characters are replaced with a
space when the report is processed.
But I can't use it.
Please help me!
--
Composed with Newz Crawler 1.7 http://www.newzcrawler.com/Could you please post an example of how you're using it?
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sean.Xiao" <ydxiao@.suntowntech.com> wrote in message
news:ufUQ64dhEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Is it possible?
> Sp1 said:
> New Lines in Expressions
> Previously, expressions had to be contained on a single line. With
> SP1, expressions can include a newline character. New line characters
> include carriage return (CR), line feed (LF), carriage return and
> line feed (CRLF), paragraph separator (Unicode 2029), and line
> separator (Unicode 2028). The newline characters are replaced with a
> space when the report is processed.
> But I can't use it.
> Please help me!
> --
> Composed with Newz Crawler 1.7 http://www.newzcrawler.com/|||These textbox expressions/values were entered using the expression editor.
The first item, in the examples, is the textbox expression/value while the
second is how it should render. Hopefully these will point you the right
direction for using VB constants in expressions.
Example 1
--
="The brown fox jumped" & vbcrlf & "over the fence
The brown fox jumped
over the fence
Example 2
--
The brown fox jumped
over the fence
The brown fox jumped
over the fence
Example 3
--
="The brown fox jumped" &
" over the fence"
The brown fox jumped over the fence
For more information about constants see Visual Basic Language Reference,
Print and Display Constants:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vamscmiscellaneousconstants.asp
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sean.Xiao" <ydxiao@.suntowntech.com> wrote in message
news:ufUQ64dhEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Is it possible?
> Sp1 said:
> New Lines in Expressions
> Previously, expressions had to be contained on a single line. With
> SP1, expressions can include a newline character. New line characters
> include carriage return (CR), line feed (LF), carriage return and
> line feed (CRLF), paragraph separator (Unicode 2029), and line
> separator (Unicode 2028). The newline characters are replaced with a
> space when the report is processed.
> But I can't use it.
> Please help me!
> --
> Composed with Newz Crawler 1.7 http://www.newzcrawler.com/|||2004-08-20 00:32:50
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in
message
<udj2toghEHA.556@.TK2MSFTNGP10.phx.gbl>
> These textbox expressions/values were entered using the expression
editor.
> The first item, in the examples, is the textbox expression/value
while the
> second is how it should render. Hopefully these will point you the
right
> direction for using VB constants in expressions.
>
> Example 1
> --
> ="The brown fox jumped" & vbcrlf & "over the fence
>
> The brown fox jumped
> over the fence
>
> Example 2
> --
> The brown fox jumped
> over the fence
>
> The brown fox jumped
> over the fence
>
> Example 3
> --
> ="The brown fox jumped" &
> " over the fence"
>
> The brown fox jumped over the fence
>
> For more information about constants see Visual Basic Language
Reference,
> Print and Display Constants:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/vblr7/html/vamscmiscellaneousconstants.asp
>
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> "Sean.Xiao" <ydxiao@.suntowntech.com> wrote in message
> news:ufUQ64dhEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > Is it possible?
> >
> > Sp1 said:
> >
> > New Lines in Expressions
> >
> > Previously, expressions had to be contained on a single line.
With
> > SP1, expressions can include a newline character. New line
characters
> > include carriage return (CR), line feed (LF), carriage return and
> > line feed (CRLF), paragraph separator (Unicode 2029), and line
> > separator (Unicode 2028). The newline characters are replaced
with a
> > space when the report is processed.
> >
> > But I can't use it.
> >
> > Please help me!
> > --
> > Composed with Newz Crawler 1.7 http://www.newzcrawler.com/
--
Composed with Newz Crawler 1.7 http://www.newzcrawler.com/|||Ok,Thanks Bruce.
--
Composed with Newz Crawler 1.7 http://www.newzcrawler.com/
Sp1 said:
New Lines in Expressions
Previously, expressions had to be contained on a single line. With
SP1, expressions can include a newline character. New line characters
include carriage return (CR), line feed (LF), carriage return and
line feed (CRLF), paragraph separator (Unicode 2029), and line
separator (Unicode 2028). The newline characters are replaced with a
space when the report is processed.
But I can't use it.
Please help me!
--
Composed with Newz Crawler 1.7 http://www.newzcrawler.com/Could you please post an example of how you're using it?
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sean.Xiao" <ydxiao@.suntowntech.com> wrote in message
news:ufUQ64dhEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Is it possible?
> Sp1 said:
> New Lines in Expressions
> Previously, expressions had to be contained on a single line. With
> SP1, expressions can include a newline character. New line characters
> include carriage return (CR), line feed (LF), carriage return and
> line feed (CRLF), paragraph separator (Unicode 2029), and line
> separator (Unicode 2028). The newline characters are replaced with a
> space when the report is processed.
> But I can't use it.
> Please help me!
> --
> Composed with Newz Crawler 1.7 http://www.newzcrawler.com/|||These textbox expressions/values were entered using the expression editor.
The first item, in the examples, is the textbox expression/value while the
second is how it should render. Hopefully these will point you the right
direction for using VB constants in expressions.
Example 1
--
="The brown fox jumped" & vbcrlf & "over the fence
The brown fox jumped
over the fence
Example 2
--
The brown fox jumped
over the fence
The brown fox jumped
over the fence
Example 3
--
="The brown fox jumped" &
" over the fence"
The brown fox jumped over the fence
For more information about constants see Visual Basic Language Reference,
Print and Display Constants:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vamscmiscellaneousconstants.asp
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sean.Xiao" <ydxiao@.suntowntech.com> wrote in message
news:ufUQ64dhEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Is it possible?
> Sp1 said:
> New Lines in Expressions
> Previously, expressions had to be contained on a single line. With
> SP1, expressions can include a newline character. New line characters
> include carriage return (CR), line feed (LF), carriage return and
> line feed (CRLF), paragraph separator (Unicode 2029), and line
> separator (Unicode 2028). The newline characters are replaced with a
> space when the report is processed.
> But I can't use it.
> Please help me!
> --
> Composed with Newz Crawler 1.7 http://www.newzcrawler.com/|||2004-08-20 00:32:50
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in
message
<udj2toghEHA.556@.TK2MSFTNGP10.phx.gbl>
> These textbox expressions/values were entered using the expression
editor.
> The first item, in the examples, is the textbox expression/value
while the
> second is how it should render. Hopefully these will point you the
right
> direction for using VB constants in expressions.
>
> Example 1
> --
> ="The brown fox jumped" & vbcrlf & "over the fence
>
> The brown fox jumped
> over the fence
>
> Example 2
> --
> The brown fox jumped
> over the fence
>
> The brown fox jumped
> over the fence
>
> Example 3
> --
> ="The brown fox jumped" &
> " over the fence"
>
> The brown fox jumped over the fence
>
> For more information about constants see Visual Basic Language
Reference,
> Print and Display Constants:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/vblr7/html/vamscmiscellaneousconstants.asp
>
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> "Sean.Xiao" <ydxiao@.suntowntech.com> wrote in message
> news:ufUQ64dhEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > Is it possible?
> >
> > Sp1 said:
> >
> > New Lines in Expressions
> >
> > Previously, expressions had to be contained on a single line.
With
> > SP1, expressions can include a newline character. New line
characters
> > include carriage return (CR), line feed (LF), carriage return and
> > line feed (CRLF), paragraph separator (Unicode 2029), and line
> > separator (Unicode 2028). The newline characters are replaced
with a
> > space when the report is processed.
> >
> > But I can't use it.
> >
> > Please help me!
> > --
> > Composed with Newz Crawler 1.7 http://www.newzcrawler.com/
--
Composed with Newz Crawler 1.7 http://www.newzcrawler.com/|||Ok,Thanks Bruce.
--
Composed with Newz Crawler 1.7 http://www.newzcrawler.com/
new line in bcp
I am exporting sql server table data to excel using bcp... But if any field
contain carrige return , that fields break up into to next line. Is their
any solution to itOne other way might be to create an ODBC connection to Excel and export
through this data source
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Vikram" <aa@.aa> wrote in message
news:ew#myvQPGHA.1532@.TK2MSFTNGP12.phx.gbl...
> I am exporting sql server table data to excel using bcp... But if any
field
> contain carrige return , that fields break up into to next line. Is their
> any solution to it
>|||If you do not want the carriage returns in the data, create a view
that returns all the columns of the table but removes the carriage
returns from the particular column(s) using REPLACE(). Then BCP out
from the view, instead of from the table.
If you must preserve the carriage returns in the data, don't use BCP.
Roy Harvey
Beacon Falls, CT
On Wed, 1 Mar 2006 14:11:29 +0530, "Vikram" <aa@.aa> wrote:
>I am exporting sql server table data to excel using bcp... But if any field
>contain carrige return , that fields break up into to next line. Is their
>any solution to it|||But I cant use views as I am calling stored procedure from bcp... And stored
procedure return data from temp tables...
Is there is no way by which bcp can preserve carrige return in the data.
Because when we use DTS, it export the data perfectly. I even cannot use DTS
as sp return data from temp table...
Any suggestion will be helpful?
"Roy Harvey" <roy_harvey@.snet.net> wrote in message
news:uubc02t9b70m4qtavu7cohq4vmuvi1oqlr@.
4ax.com...
> If you do not want the carriage returns in the data, create a view
> that returns all the columns of the table but removes the carriage
> returns from the particular column(s) using REPLACE(). Then BCP out
> from the view, instead of from the table.
> If you must preserve the carriage returns in the data, don't use BCP.
> Roy Harvey
> Beacon Falls, CT
> On Wed, 1 Mar 2006 14:11:29 +0530, "Vikram" <aa@.aa> wrote:
>
field|||Vikram (aa@.aa) writes:
> But I cant use views as I am calling stored procedure from bcp... And
> stored procedure return data from temp tables...
You using the queryout option? Anyway, if you are already using temp
tables, you have all possibilities to modify the data.
> Is there is no way by which bcp can preserve carrige return in the data.
I guess the question is not how get BCP to preserve the CR in the data -
it bulks out whatever that is, but how to a file should look like for
Excel to accept it with the newlines preserved. I don't know Excel well
enough to say how the file should look like.
Once you are equipped with that knowledge, you can address this by either
formatting the data when you select it, or use a format file, to have BCP
to do it.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
contain carrige return , that fields break up into to next line. Is their
any solution to itOne other way might be to create an ODBC connection to Excel and export
through this data source
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Vikram" <aa@.aa> wrote in message
news:ew#myvQPGHA.1532@.TK2MSFTNGP12.phx.gbl...
> I am exporting sql server table data to excel using bcp... But if any
field
> contain carrige return , that fields break up into to next line. Is their
> any solution to it
>|||If you do not want the carriage returns in the data, create a view
that returns all the columns of the table but removes the carriage
returns from the particular column(s) using REPLACE(). Then BCP out
from the view, instead of from the table.
If you must preserve the carriage returns in the data, don't use BCP.
Roy Harvey
Beacon Falls, CT
On Wed, 1 Mar 2006 14:11:29 +0530, "Vikram" <aa@.aa> wrote:
>I am exporting sql server table data to excel using bcp... But if any field
>contain carrige return , that fields break up into to next line. Is their
>any solution to it|||But I cant use views as I am calling stored procedure from bcp... And stored
procedure return data from temp tables...
Is there is no way by which bcp can preserve carrige return in the data.
Because when we use DTS, it export the data perfectly. I even cannot use DTS
as sp return data from temp table...
Any suggestion will be helpful?
"Roy Harvey" <roy_harvey@.snet.net> wrote in message
news:uubc02t9b70m4qtavu7cohq4vmuvi1oqlr@.
4ax.com...
> If you do not want the carriage returns in the data, create a view
> that returns all the columns of the table but removes the carriage
> returns from the particular column(s) using REPLACE(). Then BCP out
> from the view, instead of from the table.
> If you must preserve the carriage returns in the data, don't use BCP.
> Roy Harvey
> Beacon Falls, CT
> On Wed, 1 Mar 2006 14:11:29 +0530, "Vikram" <aa@.aa> wrote:
>
field|||Vikram (aa@.aa) writes:
> But I cant use views as I am calling stored procedure from bcp... And
> stored procedure return data from temp tables...
You using the queryout option? Anyway, if you are already using temp
tables, you have all possibilities to modify the data.
> Is there is no way by which bcp can preserve carrige return in the data.
I guess the question is not how get BCP to preserve the CR in the data -
it bulks out whatever that is, but how to a file should look like for
Excel to accept it with the newlines preserved. I don't know Excel well
enough to say how the file should look like.
Once you are equipped with that knowledge, you can address this by either
formatting the data when you select it, or use a format file, to have BCP
to do it.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
New Line in a TextBox
In a report, I have a textbox... and I want to make a new line in the
expression builder...
I tried that
=Fields!ShipToName.Value & "\n" & Fields!ShipToAddress.Value
but the \n is not recognized
I have tried without the quote, with singles quotes, ... but no way...
It is a really stupid question and I haven't found an answer
Thanks for the one who answersYou could try this:
=Fields!ShipToName.Value & vbcrlf & Fields!ShipToAddress.Value
or
=Fields!ShipToName.Value & ControlChars.CrLf &
Fields!ShipToAddress.Value
I haven't verified how these will behave with different rendering.
This page has some info on the control characters:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vamscmiscellaneousconstants.asp
Good Luck,
Dan|||I always use Environment.NewLine which will work no matter what the viewer
is.
Craig
"Hasan Ozdil" <hasan.ozdil@.gmail.com> wrote in message
news:1141206171.555868.323910@.i40g2000cwc.googlegroups.com...
> In a report, I have a textbox... and I want to make a new line in the
> expression builder...
> I tried that
> =Fields!ShipToName.Value & "\n" & Fields!ShipToAddress.Value
> but the \n is not recognized
> I have tried without the quote, with singles quotes, ... but no way...
> It is a really stupid question and I haven't found an answer
> Thanks for the one who answers
>|||Environment.NewLine works perfectly !!
Thank you Craig|||Craig, that was a great tip! I have fields in a database that have line
feeds between lines and your tip with a function fixed it right up.
=Replace(Fields!fieldname.Value, vbLf, Environment.NewLine)
Worked like a champ, thanks a million.
Larry
expression builder...
I tried that
=Fields!ShipToName.Value & "\n" & Fields!ShipToAddress.Value
but the \n is not recognized
I have tried without the quote, with singles quotes, ... but no way...
It is a really stupid question and I haven't found an answer
Thanks for the one who answersYou could try this:
=Fields!ShipToName.Value & vbcrlf & Fields!ShipToAddress.Value
or
=Fields!ShipToName.Value & ControlChars.CrLf &
Fields!ShipToAddress.Value
I haven't verified how these will behave with different rendering.
This page has some info on the control characters:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vamscmiscellaneousconstants.asp
Good Luck,
Dan|||I always use Environment.NewLine which will work no matter what the viewer
is.
Craig
"Hasan Ozdil" <hasan.ozdil@.gmail.com> wrote in message
news:1141206171.555868.323910@.i40g2000cwc.googlegroups.com...
> In a report, I have a textbox... and I want to make a new line in the
> expression builder...
> I tried that
> =Fields!ShipToName.Value & "\n" & Fields!ShipToAddress.Value
> but the \n is not recognized
> I have tried without the quote, with singles quotes, ... but no way...
> It is a really stupid question and I haven't found an answer
> Thanks for the one who answers
>|||Environment.NewLine works perfectly !!
Thank you Craig|||Craig, that was a great tip! I have fields in a database that have line
feeds between lines and your tip with a function fixed it right up.
=Replace(Fields!fieldname.Value, vbLf, Environment.NewLine)
Worked like a champ, thanks a million.
Larry
New Job Unable to Copy 200 Line Code Into Command Section
I have a SQL Server 2000 database, I created a new job but I am unable to
copy the 200 lines of code that I created into the command section of the job.
Is there away to expand the New Job Command section?
I cannot use another job step to resolve this issue because I have alot
variables and a cursor used in this job.
This problem is resolve in SQL Server 2005.
Please help me resolve this problem for SQL Server 2000.
Thank You,Joe K. wrote:
> I have a SQL Server 2000 database, I created a new job but I am unable to
> copy the 200 lines of code that I created into the command section of the job.
> Is there away to expand the New Job Command section?
> I cannot use another job step to resolve this issue because I have alot
> variables and a cursor used in this job.
> This problem is resolve in SQL Server 2005.
> Please help me resolve this problem for SQL Server 2000.
> Thank You,
>
200 lines of code in a single job step? That's just insane. Put that
code into a stored procedure, and then use a single EXEC statement in
the job step.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I fully agree with Tracy. If you, for some strange reason, don't want to do this, I believe the
limit is a bit higher at the TSQL level (i.e., the GUI is the limiting factor), so you could have
some more by using sp_add_jobstep.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message news:45BA5D73.3080102@.realsqlguy.com...
> Joe K. wrote:
>> I have a SQL Server 2000 database, I created a new job but I am unable to copy the 200 lines of
>> code that I created into the command section of the job.
>> Is there away to expand the New Job Command section? I cannot use another job step to resolve
>> this issue because I have alot variables and a cursor used in this job.
>> This problem is resolve in SQL Server 2005.
>> Please help me resolve this problem for SQL Server 2000.
>> Thank You,
>>
> 200 lines of code in a single job step? That's just insane. Put that code into a stored
> procedure, and then use a single EXEC statement in the job step.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
copy the 200 lines of code that I created into the command section of the job.
Is there away to expand the New Job Command section?
I cannot use another job step to resolve this issue because I have alot
variables and a cursor used in this job.
This problem is resolve in SQL Server 2005.
Please help me resolve this problem for SQL Server 2000.
Thank You,Joe K. wrote:
> I have a SQL Server 2000 database, I created a new job but I am unable to
> copy the 200 lines of code that I created into the command section of the job.
> Is there away to expand the New Job Command section?
> I cannot use another job step to resolve this issue because I have alot
> variables and a cursor used in this job.
> This problem is resolve in SQL Server 2005.
> Please help me resolve this problem for SQL Server 2000.
> Thank You,
>
200 lines of code in a single job step? That's just insane. Put that
code into a stored procedure, and then use a single EXEC statement in
the job step.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I fully agree with Tracy. If you, for some strange reason, don't want to do this, I believe the
limit is a bit higher at the TSQL level (i.e., the GUI is the limiting factor), so you could have
some more by using sp_add_jobstep.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message news:45BA5D73.3080102@.realsqlguy.com...
> Joe K. wrote:
>> I have a SQL Server 2000 database, I created a new job but I am unable to copy the 200 lines of
>> code that I created into the command section of the job.
>> Is there away to expand the New Job Command section? I cannot use another job step to resolve
>> this issue because I have alot variables and a cursor used in this job.
>> This problem is resolve in SQL Server 2005.
>> Please help me resolve this problem for SQL Server 2000.
>> Thank You,
>>
> 200 lines of code in a single job step? That's just insane. Put that code into a stored
> procedure, and then use a single EXEC statement in the job step.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
New Job Unable to Copy 200 Line Code Into Command Section
I have a SQL Server 2000 database, I created a new job but I am unable to
copy the 200 lines of code that I created into the command section of the job.
Is there away to expand the New Job Command section?
I cannot use another job step to resolve this issue because I have alot
variables and a cursor used in this job.
This problem is resolve in SQL Server 2005.
Please help me resolve this problem for SQL Server 2000.
Thank You,
Joe K. wrote:
> I have a SQL Server 2000 database, I created a new job but I am unable to
> copy the 200 lines of code that I created into the command section of the job.
> Is there away to expand the New Job Command section?
> I cannot use another job step to resolve this issue because I have alot
> variables and a cursor used in this job.
> This problem is resolve in SQL Server 2005.
> Please help me resolve this problem for SQL Server 2000.
> Thank You,
>
200 lines of code in a single job step? That's just insane. Put that
code into a stored procedure, and then use a single EXEC statement in
the job step.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
copy the 200 lines of code that I created into the command section of the job.
Is there away to expand the New Job Command section?
I cannot use another job step to resolve this issue because I have alot
variables and a cursor used in this job.
This problem is resolve in SQL Server 2005.
Please help me resolve this problem for SQL Server 2000.
Thank You,
Joe K. wrote:
> I have a SQL Server 2000 database, I created a new job but I am unable to
> copy the 200 lines of code that I created into the command section of the job.
> Is there away to expand the New Job Command section?
> I cannot use another job step to resolve this issue because I have alot
> variables and a cursor used in this job.
> This problem is resolve in SQL Server 2005.
> Please help me resolve this problem for SQL Server 2000.
> Thank You,
>
200 lines of code in a single job step? That's just insane. Put that
code into a stored procedure, and then use a single EXEC statement in
the job step.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
New Job Unable to Copy 200 Line Code Into Command Section
I have a SQL Server 2000 database, I created a new job but I am unable to
copy the 200 lines of code that I created into the command section of the jo
b.
Is there away to expand the New Job Command section?
I cannot use another job step to resolve this issue because I have alot
variables and a cursor used in this job.
This problem is resolve in SQL Server 2005.
Please help me resolve this problem for SQL Server 2000.
Thank You,Joe K. wrote:
> I have a SQL Server 2000 database, I created a new job but I am unable to
> copy the 200 lines of code that I created into the command section of the
job.
> Is there away to expand the New Job Command section?
> I cannot use another job step to resolve this issue because I have alot
> variables and a cursor used in this job.
> This problem is resolve in SQL Server 2005.
> Please help me resolve this problem for SQL Server 2000.
> Thank You,
>
200 lines of code in a single job step? That's just insane. Put that
code into a stored procedure, and then use a single EXEC statement in
the job step.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I fully agree with Tracy. If you, for some strange reason, don't want to do
this, I believe the
limit is a bit higher at the TSQL level (i.e., the GUI is the limiting facto
r), so you could have
some more by using sp_add_jobstep.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message news:45BA5D73.3080102@.realsqlguy.co
m...
> Joe K. wrote:
> 200 lines of code in a single job step? That's just insane. Put that c
ode into a stored
> procedure, and then use a single EXEC statement in the job step.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
copy the 200 lines of code that I created into the command section of the jo
b.
Is there away to expand the New Job Command section?
I cannot use another job step to resolve this issue because I have alot
variables and a cursor used in this job.
This problem is resolve in SQL Server 2005.
Please help me resolve this problem for SQL Server 2000.
Thank You,Joe K. wrote:
> I have a SQL Server 2000 database, I created a new job but I am unable to
> copy the 200 lines of code that I created into the command section of the
job.
> Is there away to expand the New Job Command section?
> I cannot use another job step to resolve this issue because I have alot
> variables and a cursor used in this job.
> This problem is resolve in SQL Server 2005.
> Please help me resolve this problem for SQL Server 2000.
> Thank You,
>
200 lines of code in a single job step? That's just insane. Put that
code into a stored procedure, and then use a single EXEC statement in
the job step.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I fully agree with Tracy. If you, for some strange reason, don't want to do
this, I believe the
limit is a bit higher at the TSQL level (i.e., the GUI is the limiting facto
r), so you could have
some more by using sp_add_jobstep.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message news:45BA5D73.3080102@.realsqlguy.co
m...
> Joe K. wrote:
> 200 lines of code in a single job step? That's just insane. Put that c
ode into a stored
> procedure, and then use a single EXEC statement in the job step.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
Subscribe to:
Posts (Atom)