reading xml by sql function - Database Discussion Boards

First Prev Next

Sql Ansi

Click^ok4-Sep-07 16:50

Click^ok

4-Sep-07 16:50

Does someone knows where I find the SQL Ansi specs?

For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life.(John 3:16)

Re: Sql Ansi

Sathesh Sakthivel4-Sep-07 20:13

Sathesh Sakthivel

4-Sep-07 20:13

Sql Ansi

SSK.

How to filter column ?

RichardBlare4-Sep-07 16:34

RichardBlare

4-Sep-07 16:34

Hi,
Here is my query.
Select * from Table1

Result

Department NewYork Chicago Washington LA

DepartmentA 1 5 4 0
DepartMentB 2 0 0 3
DepartMentC 0 1 1 1

What I need to do is to get the Top 3 City. ( here Chicago,WashingTon,LA)
Can i filter out the columne with the query ? When I use TOP, it can show top 3 rows.
But, that's not what I want.

Can anybody help me, please?

Re: How to filter column ?

John-ph5-Sep-07 0:42

John-ph

5-Sep-07 0:42

RichardBlare wrote:
Select * from Table1

I suppose this is you query...and My doubt is

RichardBlare wrote:
Department NewYork Chicago Washington LA

Is this your table columns?

RichardBlare wrote:
DepartmentA 1 5 4 0
DepartMentB 2 0 0 3
DepartMentC 0 1 1 1

Is this your output?

RichardBlare wrote:
Chicago,WashingTon,LA

Is this you want?

RichardBlare wrote:
Can anybody help me, please?

If I'm not wrong please tell...Do you need a output that gives you the list of Column names that has maximum values?
If I'm wrong Please explain more clearly what you want...

Regards
J O H N

"Even eagles need a push." David McNally

Re: How to filter column ?

RichardBlare5-Sep-07 0:52

RichardBlare

5-Sep-07 0:52

Dear John,
I'm sorry that my question confuse you. Actually, I just need the result with the Column names that has maximum values.

Let me try to be clear.
Here is the result of my query.

Department City1 City2 City3 City4 City5 City6

Operations 4 2 6 NULL 1 NULL
Risk Management 4 5 1 NULL 2 NULL
Technology 2 3 5 NULL 1 NULL

I want to remove the column with NULL values.
That's exactly what I want.

Thanks ,
RB

Re: How to filter column ?

Frank Kerrigan5-Sep-07 1:10

Frank Kerrigan

5-Sep-07 1:10

I think I know what you want

<br />
SELECT * from TABLE<br />
ORDER BY City DESC<br />

ORDER BY WITH SUM

<br />
SELECT *, SUM(City1 + City2 + City3 + City4 + City5 + City6) as Total<br />
  from TABLE<br />
ORDER BY Total DESC<br />

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Clear the Service Broker Queue

FernandoMartin4-Sep-07 7:21

FernandoMartin

4-Sep-07 7:21

Hi,

How can i list the queues of the Service Broker and clear them?

thank you a lot. Smile | :)

reading xml by sql function

Sachin Pimpale4-Sep-07 1:49

Sachin Pimpale

4-Sep-07 1:49

i faced problem during reading xml file by sql function, xml file is comm separeated.

The Stifler
--
Bugs can neither be created nor be removed from software by a developer. They can only be converted from one form to another. The total number of bugs in the software always remain constant.

Re: reading xml by sql function

WoutL4-Sep-07 1:54

WoutL

4-Sep-07 1:54

I can imagine you have a problem with a xml-file when it is comma seperated.

Wout Louwers

how t o call a stored procedure inside a stored procedure

bhattiprolu4-Sep-07 0:59

bhattiprolu

4-Sep-07 0:59

how t o call a stored procedure inside a stored procedure

Re: how t o call a stored procedure inside a stored procedure

John-ph4-Sep-07 1:17

John-ph

4-Sep-07 1:17

bhattiprolu wrote:
how t o call a stored procedure inside a stored procedure

Execute [Procedure_Name] [@Parameter1,Parameter2...][^]

Regards
J O H N

"Even eagles need a push." David McNally

Re: how t o call a stored procedure inside a stored procedure

bhattiprolu4-Sep-07 1:26

bhattiprolu

4-Sep-07 1:26

I want stored procedure A to call stored procedure B, which returns a set of records from a table. Then, I want stored procedure A to perform work on these records. How do I call stored procedure B from within stored procedure A?

Re: how t o call a stored procedure inside a stored procedure

John-ph4-Sep-07 1:30

John-ph

4-Sep-07 1:30

didn't you try the link???

ok try this... this sample has a parent stored proc that calls a child stored proc by passing parameter values and then does some insert operation...

Google the Google...[^]

Regards
J O H N

"Even eagles need a push." David McNally

Re: how t o call a stored procedure inside a stored procedure

bhattiprolu4-Sep-07 1:34

bhattiprolu

4-Sep-07 1:34

yeah i got that one john,
one more thing is...
i have one field in my table which i want to update after inserting some values in the table.
i have written one stored procedure for inserting values,
i want to update one field depending upon the inserting values.

can u help me...

Re: how t o call a stored procedure inside a stored procedure

John-ph4-Sep-07 1:46

John-ph

4-Sep-07 1:46

you can do both Insert and Update in single procedure. I'm not sure about why you want to do in 2 procs...ok... you can go through the below sample.

CREATE PROCEDURE sp_Update
(
@col1 varchar(20)
@ValuePassed varchar(50),
)
AS

declare @Id int
EXEC sp_Insert @ValuePassed, @Id OUTPUT

Update SomeTable
(col1, col2)
VALUES
(@col1, @Id)
RETURN
GO 


CREATE PROCEDURE sp_Insert

(
@ValuePassedIn varchar(50),
@Id smallint OUTPUT
)
 AS

INSERT INTO LookUpTable(column1) 
VALUES(@ValuePassedIn)
    
    SET @Id = Scope_Identity()
END
GO

Regards
J O H N

"Even eagles need a push." David McNally

Re: how t o call a stored procedure inside a stored procedure

bhattiprolu4-Sep-07 2:03

bhattiprolu

4-Sep-07 2:03

The thing is,
i have one one registration page.
in that if user chooses his own question for security(while signup in yahoo also we will get security question like that) then the table field must b updated and question flag should be "yes"
if i take the custom question option else not.
how we will make that?

Re: how t o call a stored procedure inside a stored procedure

John-ph4-Sep-07 2:57

John-ph

4-Sep-07 2:57

bhattiprolu wrote:
i have one one registration page.
in that if user chooses his own question for security(while signup in yahoo also we will get security question like that) then the table field must b updated and question flag should be "yes"
if i take the custom question option else not.

with this information it's quite difficult for me to assume the table structure, their relationships and giving you a stored procedure in working condition.

In the previous post there is a sample procedure. I guess if you understand that you can solve your problem. First do an insert in whichever table you want and then read the newly inserted records PK_ID value using SCOPE_IDENTITY(). with primary key value of the newly inserted record you can perform the subsequent update in whichever table you want...

Hope this helps....

Regards
J O H N

"Even eagles need a push." David McNally

Insert data into database

Tuanhung1894-Sep-07 0:35

Tuanhung189

4-Sep-07 0:35

Hi ! I am writting a Dictionary online website. I want to insert,update,delete data from gridview but I have some trouble.so I want to ask how to do that ? Thanks so much !

Re: Insert data into database

John-ph4-Sep-07 1:03

John-ph

4-Sep-07 1:03

Tuanhung189 wrote:
I have some trouble.so I want to ask how to do that ?

How to do what???????? You mean how to write stored proc to insert, update and delete...

Regards
J O H N

"Even eagles need a push." David McNally

Re: Insert data into database

Rami Said Abd Alhalim4-Sep-07 6:26

Rami Said Abd Alhalim

4-Sep-07 6:26

you can take the celles from grid view after that you can set data in
sqlcommand.commandtext="insert into tablename(col1,col2,col3)values(cell1,cell2,cell3)"

Sql server. varbinary or varchar

Eli Nurman4-Sep-07 0:24

Eli Nurman

4-Sep-07 0:24

Hi. I'm hosting on a SQL server 2005 some encrypted data which could be stored as binary (Hex) or base64 (varchar).

What datatype would be best to use varbinary for the hex or varchar for the base64?
Is there any difference between them in memory usage?

Re: Sql server. varbinary or varchar

Colin Angus Mackay4-Sep-07 0:50

Colin Angus Mackay

4-Sep-07 0:50

never.reply wrote:
What datatype would be best to use varbinary for the hex or varchar for the base64?

byte arrays and strings respectively

never.reply wrote:
Is there any difference between them in memory usage?

Yes. Base 64 encodes things as characters, and as the name suggests this is in base 64 which is represented by only 6 bits. So base 64 will take more memory to store.

Upcoming FREE developer events:
* Glasgow: Agile in the Enterprise Vs. ISVs, db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ...

My website

Re: Sql server. varbinary or varchar

Eli Nurman4-Sep-07 0:51

Eli Nurman

4-Sep-07 0:51

Thanks

Re: Sql server. varbinary or varchar

Pete O'Hanlon4-Sep-07 22:16