Urgent Help!-how To Format After Getting Rows? For Newline

Oct 8, 2004

while(@@FETCH_STATUS=0)
begin
print 'inside while'

set @BodyContents = @BodyContents+@gotclientName+@gotproductName
set @Body= @Body + @BodyContents + ','

fetch next from resultcursor into @gotclientName,@gotproductName

print 'going outside of while'
end --while end

Client Name Product Name
aaa test1
bbb test4

how to format row like above. currently i am getting
aaa,test1,bbb,test4

View 1 Replies


ADVERTISEMENT

Specifyin The Row Delimeter As Newline (Unix Style) In Bulkinsert Format File

Sep 28, 2007

Hi,

I am bulk inserting the data from a file into a table using the following format.



9.0
1
1 SQLCHAR 0 10 "
" 1 MSISDN SQL_Latin1_General_CP1_CI_AS

This works perfectly for me.

But my problem is that the firmat may not be generated in Windows and i can't user "
" as row delimeter.
It could be generated in Unix and want to use LF as the row delimeter.

Questions :

1) How do i specify this kind of new line (LF ) in formatfile?
2) Is there anyway that i can specify both the delimeters and let it use which ever is appropriate ?

Please provide some inputs on this??

Thank u so much
~Mohan

View 3 Replies View Related

Urgent Format Que

Oct 31, 2007

 I have a urgent need for a date format.I have a third part
tool which inserts date into the database in the format  ( 7/1/2007 ) 
but what i want to display is 07/01/07).Kindly suggest fast as I have to put this to production shortly.Thanks

View 4 Replies View Related

Urgent Help On Date Display Format

Nov 12, 2007

Hi,
I am using a sql database and vb.net... In form i display a date from calendar as smalldatetime in the format of dd/MM/yyyy by changing the web.config file to culture = "en-GB"... It did display as dd/MM/yyyy with no doubt... Problem is in sql database it is display as mm/dd/yyyy, there4 when i retrieve it out, it is not the format i wan... so can any1 helps mi? I need do many adding and subtracting to the date so a constant dd/MM/yyyy format is veri important to mi... I cant save it as yyyy/mm/dd cos my boss dun wan it... If use Convert method when i select * out how to convert the date zzz
Helps would be greatly appreciated

View 9 Replies View Related

Date Format: Urgent Help Needed

Dec 12, 2007


I have a date "4/25/2007"
but the requirement is to have data as "04/25/2007"
.if month is single digit it should have leading zeroes, same with date,
can some tell me how to convert this.

View 2 Replies View Related

Urgent Help : Date Format Conversion

Dec 12, 2007

I have a date "4/25/2007"
but the requirement is to have data as "04/25/2007" in datamart.
if month is single digit it should have leading zeroes, same with date,
can some tell me how to convert this.

View 7 Replies View Related

Urgent (External Table Is Not In The Expected Format)

Aug 10, 2007



Hi,
I have 7 excel files that i have to import to sql server database and in that 6 of them work fine. But when i try to import the 7 one i get an

oledb exception saying that External table is not in the expected format.

So can i someone please help me with this error.

Regards
Karen


View 6 Replies View Related

URGENT - CURRENCY STRING FORMAT IN SSAS

Apr 24, 2008



In cube created by me, there is one measure called SALES AMOUNT, i defined its Format String as Currency.
And there is one Calculated measure Average Sales Amount, that also have the Format string as Currency.

But for some strange reasons, when I Pull Sales Amount it is coming with $ prefix, but when I pull Average Sales Amount it is coming with prefix Rs....

can anyone help me, what is going wrong here.. its very urgent.

View 7 Replies View Related

URGENT: UNIX DATE FORMAT CONVERION TO SQL SERVER

May 9, 2001

I HAVE ONE COLUMN CONTAING THE INTEGER TYPE DATA COMING in UNIX DATE FORMAT. NEED TO CONVERT IT TO THE SQL SERVER DATE TIME FORMAT.

NOTE: UNIX IS STORING THE DATE IN SECONDS STARTING FROM 1970/1/1

ANYBODY CAN HELP ME TO SOLVE THIS PROBLEM.

e.g. The UNIX date time is 973101026 need to be converted to SQL DATE TIME

View 2 Replies View Related

Newline In C# + SQL?

Feb 26, 2008

Hi everyone!I'm be stuck by a simple issue about newline in C# and has relative with SQL. I wrote a SQL sentence like that:                        IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME =  'TG1' AND TYPE = 'TR')" +                          " DROP TRIGGER TG1" +                          " GO " +                          " CREATE TRIGGER TG1 ON FILES FOR DELETE AS DELETE table1 FROM" +                          " table1 INNER JOIN DELETED ON DELETED.ID = table1.ID" +                          " GO " +                          " DELETE FROM table2 WHERE ID = 'ID00001'It's executing ok in SQL but when execute programming then " GO " have to break newline (
or System.Environment.NewLine), However seem have not mean for SQL Execute becoz will be appear
in SQL sentence.  I'm not  have experience about GO and TRIGGER so have any idea for this problem! Thanks so much. 

View 2 Replies View Related

Help With Newline

Jun 25, 2007

Hey guys, how do I return a string from a stored proc that displays some of its text on a newline?

E.g.

"some text goes here
some more text goes here
etc etc etc"

View 4 Replies View Related

How To Add A Newline Sequence

Apr 9, 2007

I have a SQL 2005 stored procedure to generate an email when passed parameters such as receipient, subject etc
 One of the paramteres passed to it is @body which is the body text of the message.  I want to be able to add a couple of blank lines and then some footer information.  This is working right now except I can't find the right way to add newlines into the string within the store procedure, so my footer information just tags right on after the bodytext.
I have tried but that literally adds the two characters  and n
Can anyone advise how to generate newlien sequences in T-SQL.
Regards
Clive

View 1 Replies View Related

Newline In Data

May 10, 2005

Hello,
I have data in a database table that has newline data in it.  It has a newline character in front of the text of the data, and for some reason, I can't figure out how I can replace it. I've tried entering in a return character between '' and I've tried trimming the text...  How do I represent a newline character to remove it from the text?
Thanks.

View 1 Replies View Related

Newline In String

Sep 21, 2006

hi all..

i have a text field which has to be shown in the result of a query execution as several lines..

eg: the result should be like this

8STK :: L/2
: M/2
: S/1

Original string is stored as "8STK :: L/2 : M/2 : S/1"

expect a positive reply soon..
thanx..

View 6 Replies View Related

Urgent - Duplicate Rows...

Apr 6, 2001

hi,

I want to delete duplicate rows in a table, can any one write a sql for doing that...

please help me in this...

urs
Vj

View 2 Replies View Related

URGENT! Rows Disappearing

Jul 4, 2006

Hello together,

strange things going on:

1. The table statistic shows for example 67 rows in a table, select count(*) only returns 63 rows.
2. Table statistic shows 50 rows, select count(*) returns 55 rows.

In both cases if you do an insert the newly inserted row sometimes can be retrieved by a select statement sometimes not. Row statistics sometimes is updated correctly, sometimes not.

Integrity check for these databases says everything is fine. DBCC CHECKDB, DBREINDEX, UPDATESTATISTICS, ... does not help or says everything is fine.

Already opened a case at HP's Microsoft support and they involved Microsoft itself but all are a little bit clueless at the moment.

As this is our main DB cluster and several databases are affected we had to stop most of our applications since last Thursday and now we are getting a little bit in trouble so any hint is very welcome.

Thanks in advance

PS: Restore is not an option - as all tools say everything is fine all of our backups from the last months include the error. Don't ask why nobody recognized the lost data earlier, seems they were stored but not required for some time.

View 4 Replies View Related

Import From Flatfile With Rows That Have Different Format...

Jan 23, 2008

Hello Folks,

Im trying to use Integrations services to import a file on a daily basis.

My flatfile has to different type of rows that comes from an transaction system, it looks like this:

132,1/1/2008,00,123654,text,1,123.00
132,1/1/2008,00,123652,text,1,23.00
132,1/1/2008,00,123655,text,1,3.00
123,1/1/1/2008,01,149.00
1125,1/1/2008,00,123654,text,1,123.00
1125,1/1/2008,00,123652,text,1,23.00
1125,1/1/2008,00,123655,text,1,3.00
1125,1/1/1/2008,01,149.00;Cash;EUR;01;12

After the date you can see that there is two digits number either 00 or 01. The rows also have a different lengthts.

When ever that columns contains 00 the line should be inserted to a special text file, if the columns contains 01 it should to another file.

How can I solve this in a good way?

One of the problems I have is that when I try to import the rows the flat file connections indicates(erros message) that I have partial row in the file which is true since the the rows with the columns content 01 have more fields then the other.

Thanks for you help.

holtis

View 8 Replies View Related

Newline Character In Sqlserver

Jun 1, 2004

what is the newline character in sqlserver.
My problem is ,I have to display text (say "Hi abcd hhh") where is the newline.
But when i print this in sqlserver storedproc,Its displaying as it is instead of newlines.

please help

thx

View 2 Replies View Related

Newline Character In Query

Feb 28, 2002

Can I use a newline character in my query? I want to dynamically generate a statement, split on several lines. Simple example:

declare @cmd varchar(100)
select @cmd = 'select user_name(), getdate()'
select @cmd

The output will be: select user_name(), getdate()

Can I use something like this:
declare @cmd varchar(100)
select @cmd = 'select user_name(), getdate()'
select @cmd

so as to get an output like this:
select user_name(),
getdate()

Thanks.

View 1 Replies View Related

Redirect URI Cannot Contain Newline Characters

Apr 25, 2005

Hi i get the above error when moving from one page to another. the following code is used. Can u help

Response.Redirect("Applicationform2.aspx?Id="+StudentID.Text+"&nam="+Name.Text+"&surNa="+ SrName.Text +"&DOB="+Ddate+ "&addr="+address.Text+"&pCode="+postal.Text+"&Cntry="+country.Text+"&email="+email.Text+"&ph="+phone.Text);

i dont understand the problem, can u help resolve the problem

View 1 Replies View Related

How Can I Put A Newline Within A String Column?

Apr 20, 2006

I am using Derived Column Transformation Editor. I have 3 string values which I would like to combine them into one string and have a newline character inbetween the 3 strings. I cannot see a Char() function similar to TSQL to use for this purpose. I thought about creating a Variable but even to that I don't know how I can assign a newline character.

Any ideas?

View 5 Replies View Related

Urgent - Deleting Duplicate Rows

Apr 5, 2001

Hi folks,

I need to delete the duplicate rows from a table. How to do that in SQL server 7.0 ? If possible write an example, so that it will be much useful for me..

Thanks for ur help..

rgds,
vJ

View 1 Replies View Related

ELIMINATING DUPLICATE ROWS URGENT

Jul 20, 2007

Hi i have a table value which contains
value
-----
a
a
a
b
b
b
c
c
c

Now i need to have the results as

a 1

b 1

c 1


I tried using distinct.But OLEDB returns error that invalid syntax.It doesn't support distinct keyword.Actually i read these table from a file thru OLEDB.Not from a database.Any idea ? Thanks in Advance

View 8 Replies View Related

Convert Columns To Rows - Urgent

Jan 13, 2008

Hi,
I have a table with 5 columns, from that I need only 3 columns , but the columns should be rows in the output
Ex Table 1
col1 col2 col3

Now I want col1 as one row n col2 as 2nd row and col3 as 3rd row

What query should I write to get this?

Will union work


Thank You

View 1 Replies View Related

How To Group 2 Table Rows (urgent)

Jun 13, 2007

Hi

How do i group 2 table rows?

I have a report with a table and it has 58 rows, in some of the rows i am displaying the data like this



Roth contribution (Heading)

data for the roth contribution.





So depending on the options checked sometimes the heading Roth contribution is at the end of the page and the data is the next page. so how can i group 2 table rows together.



I have tried clicking on the 2 rows and grouping it, but nothing seems to appear in the report..



any help will be appreciated.



Regards,

Karen



View 3 Replies View Related

How Can I Split The Rows In 2 Textboxes - Urgent

Feb 20, 2007

Hi,

I have a report and its been populating from a sproc. and i have 2 text boxes called both of them are poplulated by Fields!Investment Names, but right i can display the data left to right but i want to display the Data starting top to bottom and then towards the right.

I tried grouping the data in this way for one text box = CountRows()/2 > 10 . and this shows all the records one below the other, so is there a way that i can display half the records in one text box and the other half in the other text box.

I am going kinda nuts over this. Can someone please help me.

Regards

Karen

View 15 Replies View Related

Including Newline In SQL SELECT Statement

Nov 21, 2006

Hi,
I'm trying to write a SQL SELECT statement where the phone numer ("telnr") is divided on three rows. How do I write a newline? I've tried , NEWLINE, and a few others.
Thanks in advance!
Pettrer, Sweden (VB, Sql Server, VWD Express, Asp.Net 2.0)
Code:
SelectCommand="SELECT [gID], [enamn], [fnamn], telnr1 + ' ' + telnr2 + ' ' + telnr3 As telnr, [epost] FROM...
The corresponding gridview's cell's value is
08-43 244 234 08-432
23 08-424333
and should be
08-43 244 234
08-432 23
08-424333 
 
 

View 7 Replies View Related

How To Add Newline In Column Of Type Nvarchar

Nov 7, 2005

Hi, I want to add a newline in a content of sql column (using t-sql and not asp.net textbox) so when content is being rendered in a .net textbox I get separate rows, so insteadcol1 col2 col3 I woule like to havecol1col2col3Thanks

View 3 Replies View Related

BCP To Ignore Newline Characters Within The Data?

Mar 9, 2000

I exporting a table of comments. There are some line returns in the comments. Some of these data are paragraphs of data! For some reason, when I am exporting the data, it treats the line return within the comment column as a new record. I am using a -c character data type so (newline character) is the row terminator. How do I get the BCP OUT to ignore a newline character within a record?

For example:
ID~Comment
-- -------
1~This is a comment
2~Hi,how are (user hit carriage)
you (you is part of next row in bcp out)
3~Next record

Thanks!

Joyce

View 1 Replies View Related

Missing 1 Million Rows During BCP PROCESS!! Urgent Help

Mar 12, 1999

Hi, I used the /e in my bcp code. yet did not get all the rows from the main frame into the sql talbes... here is the case I have 11 million rows in an ftp server I use this code to bcp into sql server can anyonecheck if this code is good for the process, I am missing one million row in the bcp process and do not know why??? I put the /e to see if there is any error but could not see any error file in my hard drive?
Please check it out and let me know

regards
Ali


Exec master..xp_cmdshell "bcp dbname..tablename in c:ftprootNbtorder.txt /fd:ftprootformatfileablename.fmt /Servername /Usa /Password /b250000 /a8000 /eerrfileORD"

View 2 Replies View Related

(URGENT) Getting The Number Of Rows From List Control

Oct 16, 2007

Ok here is what I have

Department:A

Line 1 Name: George
Addresss date raise
125254 Test 10
125254 Test 10
125254 Test 10
125254 Test 10

Total: 80% 40


Name: Mik
Addresss date raise
125254 Test 10
125254 Test 10
125254 Test 10


Total: 70% 30


Name: Jonathan
Addresss date raise
125254 Test 10
125254 Test 10
125254 Test 10


Total: 70% 30
Line 10



Line 15 Total for this division: 33% ((100 )/3) 100


Department:B
€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦..
Here is what I did I have a list control that is grouped by department. this will get me the info from Line 1 to Line 10 then this list control is actually under another list control that is grouped by department to get the info from Line 15. I used this example for simplicity and what I am doing is fairly similar to this situation. My problem is, I need to find away to know how many totals I have to count the total for the entire department. In other words : from the example above how can I know I have to divide by 3 to get 33%. I can get the 100 without any problem but I can€™t tell what number I need to divided by. I tried to use Count(Name.Field) I was hoping this will give me 3 which indicates the divided number. But I was getting 7 for some reason.
How can I get the number of times the list control was implemented for one department which is in this case 3?

thanks

View 2 Replies View Related

BULK INSERT Fails Because Of Newline ROWTERMINATOR

Feb 5, 2015

I need to import a CSV file to a table and the CSV has an Address field that has a carriage return in it.

Example:
123 Main St.
Anywhere, CO, 99999

I'm working in Windows with SQL Server 2008. What can I do to the CSV file or from within SQL Managment Studio to get the BULK INSERT to work?

Here's my query:

BULK INSERT Contact
From 'C:UsersBrianDownloadsImport-FilteredContact9c.csv'
WITH
(
FIELDTERMINATOR = '|',
ROWTERMINATOR = '
'
)

View 1 Replies View Related

Urgent Help: Regarding Assigning Mulitple Rows Of A Given Column To Variable

Aug 13, 2007

How to assign multiple values to emp1 variable separated by comma
 Ex: If  ajay karthik vijay are employee names in emp table
then emp1= ajay,karthik, vijay 
set emp1= (select employeename   from emp) returns error
error: subquery returns morethan one value
 
 
 

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved