CPU Process on Clinet/Server? - Database Discussion Boards

Re: Bumb SQL question - WHER AND syntax?

Vaclav_14-Jun-08 18:43

14-Jun-08 18:43

Thanks - it works.
So why the stupid error code could not tell me that?
Especially when the VC replaces the brackets with single quotation marks.
I am not sure quotation marks should be called "operators".
Thanks again.

Re: Bumb SQL question - WHER AND syntax?

Blue_Boy14-Jun-08 18:46

Blue_Boy

14-Jun-08 18:46

No problem.
When in condition you have value string then it must placed inside single quotes.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

Re: Bumb SQL question - WHER AND syntax?

Vaclav_14-Jun-08 19:03

Vaclav_

14-Jun-08 19:03

So the SQL ends up looking like this 'Table' = 'Condition string'.
I'll try [Table] = [Condition string] to see hat VC will do with that.

Re: Bumb SQL question - WHER AND syntax?

Blue_Boy14-Jun-08 19:04

Blue_Boy

14-Jun-08 19:04

Vaclav_Sal wrote:
'Table' = 'Condition string'.

but

select * from TableName where ColumnName='ConditionString'

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

problem with web user control

sabaMCA14-Jun-08 10:00

sabaMCA

14-Jun-08 10:00

hi friends,

I have a problem with web user control with firing events using AjaxPopupcontrol.

my need is, when I mouse hover the text - some other text will display as a

popuptext from database. this is working well in normal aspx pages.

but when I place the popupextenwer and other controls to the Web User Control and

place the web user control to one aspx page. it doesn't work. mouse hover worked but not getting values from database. it returns the following error message!!!

Web Service Call Failed : 500

can any one explain how to do this. giv me a code for this.

Thanks in Advance!!!
Sabarees

Re: problem with web user control

Christian Graus14-Jun-08 10:09

Christian Graus

14-Jun-08 10:09

Wow - SQL questions in the ASP.NET forum, and now ASP.NET questions in the SQL forum ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: problem with web user control

Blue_Boy14-Jun-08 10:49

Blue_Boy

14-Jun-08 10:49

I guess one day he/she will get idea on posting questions in right forum.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

CPU Process on Clinet/Server?

LordCover14-Jun-08 7:11

LordCover

14-Jun-08 7:11

Hello All

I have a server with MS SQL Server 2005 DataBase on it

and I set the connection string for the client to the

database on the server.

now my question is, does the processing (CPU activity) while making

a query (or a transaction) on the server or on the client?

and if it is on the client, how do I change it to the server?

Thanks

Re: CPU Process on Clinet/Server?

Hesham Amin14-Jun-08 9:19

Hesham Amin

14-Jun-08 9:19

The parsing, compilation and execution of the query is performed on the server, not the client.

Hesham A. Amin
My blog

Re: CPU Process on Clinet/Server?

LordCover15-Jun-08 1:55

LordCover

15-Jun-08 1:55

thank you very much.

how i can roll back today transaction

wasimsharp13-Jun-08 19:43

wasimsharp

13-Jun-08 19:43

hi friend i want to rollback all the transaction of today when there is some Exception thrown while executing today Query how i can do this
in C#.

wasim khan

Re: how i can roll back today transaction

Ashfield15-Jun-08 21:08

Ashfield

15-Jun-08 21:08

I'm not quite sure what yuo are trying to achieve, but you enclose your sql in a try catch with a transaction:

<pre>try
{
SQLConnection conn = new SQLConnection(connectionString);
conn.begintran():
...do your sql
conn.committran();
}
catch (Exception)
{
conn.rollbacktran();
}
finally
{
conn.close();
conn.dispose();
}</pre>

I may have the syntax slightly wrong, I don't have c# on this laptop to check, but yuo should get the idea.

Bob
Ashfield Consultants Ltd

Re: how i can roll back today transaction

Alsvha16-Jun-08 2:11

Alsvha

16-Jun-08 2:11

Do you mean you want to roll back an earlier transaction if a later transaction fails?

---------------------------
Blogging about SQL, Technology and many other things

Problem using FillSchema

FerJones13-Jun-08 14:23

FerJones

13-Jun-08 14:23

Hi!

I´m new here, and as i was in doubt about the right place to publish a question that involves asp.net and ado.net, i published in asp.net but here is the link for it.

http://www.codeproject.com/script/Forums/View.aspx?fid=12076&select=2597234#xx2597234xx[^]

Really thanks for the help.

Fernando

Stored Procedure not working with parameters as sort order

Brendan Vogt13-Jun-08 2:22

Brendan Vogt

13-Jun-08 2:22

Hi,

I have a stored procedure that I can not get to work. I am passing a value for the sort order in the GROUP BY clause, but code does not want to create the stored procedure. What am I doing wrong:

create PROCEDURE [dbo].[nsp_SearchManager_716]
(
@RequestedNB VARCHAR(50),
@Sort VARCHAR(50),
@SortOrder VARCHAR(50)
)

AS

SELECT
DISTINCT *
FROM
tblResult WITH (NOLOCK)
WHERE
sRequestedNB = @RequestedNB
ORDER BY
sSalary @SortOrder;

I would appreciate any sort of help.

Thanks
Brendan

Re: Stored Procedure not working with parameters as sort order

SomeGuyThatIsMe13-Jun-08 2:29

SomeGuyThatIsMe

13-Jun-08 2:29

I'm fairly certain that it wont evaulate the variable @SortOrder to get the direction. however you can do

EXEC ('SELECT DISTINCT * '+
'FROM tblResult WITH (NOLOCK) '+
'WHERE sRequestedNB = ' + @RequestedNB +
'ORDER BY sSalary ' + @SortOrder)

which will create then execute the string including evaluating the varibles. you could also put the sring into a varchar varible so that you can do SELECT or EXEC on it for testing purposes. limiting the size of your sort order varible to 3 (ASC, DSC) would help prevent someproblems from wherever this gets called. Hope this works for you.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Stored Procedure not working with parameters as sort order

Ashfield13-Jun-08 2:37

Ashfield

13-Jun-08 2:37

The syntax won't work unfortunately - I wish it would. there are two real options, create some dynamic sql or

if @SortOrder = 'ASC'
begin
SELECT
   DISTINCT *
FROM
   tblResult WITH (NOLOCK)
WHERE
   sRequestedNB = @RequestedNB
ORDER BY
   sSalary ASC
end 
else
begin
SELECT
   DISTINCT *
FROM
   tblResult WITH (NOLOCK)
WHERE
   sRequestedNB = @RequestedNB
ORDER BY
   sSalary DESC
end

Alternatively, would it be possible to do the order by back in your code?

Bob
Ashfield Consultants Ltd

Re: Stored Procedure not working with parameters as sort order

Alsvha13-Jun-08 3:03

Alsvha

13-Jun-08 3:03

If salary is a number simply multiply -1 or 1 on it for desc and asc sorting.
It is an easy way to do dynamic sorting of number fields (and dates).

---------------------------
Blogging about SQL, Technology and many other things

Re: Stored Procedure not working with parameters as sort order

Ashfield13-Jun-08 3:56

Ashfield

13-Jun-08 3:56

Good idea, never thought about doing that.

Bob
Ashfield Consultants Ltd

problem in creating sql reports in asp.net

prakss13-Jun-08 1:51

prakss

13-Jun-08 1:51

hi..
can anyone help in merging two sqlreports into one report.the one report has landscape orientation and other report has portrait mode.
if it is not possible to merge then how can we use the subreport method to do the same..

SQL Query - If condition

aaraaayen12-Jun-08 20:56

aaraaayen

12-Jun-08 20:56

Hi Friends,

I am using SQL Server 2005. I am facing the following problem. I need to know how to apply if condition in query.

I am having one table called Test1 with two fields c_name, average.

CC 7
CC 6
CC 8
IGC 2
IGC 4
IGC 6
HC 4
HC 5
NM 9
NM 6
NC 2
NC 5
NC 9
JC 4
JC 3
JC 1

The above are the values in that table.

Now I am using the following query to display the c_name, count(college) with average >5 group by c_name

select c_name,count(c_name) as Total from test1
where average>5 group by c_name

Result :

CC 3
IGC 1
NC 1
NM 2

Based on my query I am getting the above result. In the above result the colleges HC and JC are not coming because it has average only less than 5. But for my case, I want to display the college name with the total as 0 if that college doesnt have average >5. I need to modify the above query to get the result like below.

CC 3
IGC 1
NC 1
NM 2
HC 0
JC 0

Please help for this.

Thanks in Advance,

Regards,

Re: SQL Query - If condition

Ashfield12-Jun-08 21:08

Ashfield

12-Jun-08 21:08

Try this:

select c_name, sum(case when average > 5 then 1 else 0 end) as Total
from Test1
group by c_name

Bob
Ashfield Consultants Ltd

Re: SQL Query - If condition

aaraaayen12-Jun-08 21:38

aaraaayen

12-Jun-08 21:38

Hi Bob,

Thanks lot for ur help.

Its working well.

Regards,

Re: SQL Query - If condition

Ashfield12-Jun-08 21:39

Ashfield

12-Jun-08 21:39

No problem

Bob
Ashfield Consultants Ltd

Restore backup from sql server 2005 to 2000

PrakashBhaskar12-Jun-08 19:56

PrakashBhaskar

12-Jun-08 19:56

Hi,

I have database backup from sql server 2005, i want to restore that backup file to sql server 2000. I have tried attach database and restore database but i am not able to do that. Is there any way to achieve this? please help me.

Thanks
Warm Regards
Prakash-B

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.