|
|
Did you try it? It returns an empty table
select *
from dbo.Split('aaa.bbb.ccc', '.')
|
|
|
|
|
Oops, the last time i pasted the code, <d> was interpreted as HTML.
CREATE FUNCTION [dbo].[Split](@data NVARCHAR(MAX), @delimiter NVARCHAR(5))<br />
RETURNS @t TABLE (data NVARCHAR(max))<br />
AS<br />
BEGIN<br />
<br />
DECLARE @textXML XML;<br />
SELECT @textXML = CAST('<d>' + REPLACE(@data, @delimiter, '</d><d>') + '</d>' AS XML);<br />
<br />
INSERT INTO @t(data)<br />
SELECT T.split.value('.', 'nvarchar(max)') AS data<br />
FROM @textXML.nodes('/d') T(split)<br />
<br />
RETURN<br />
END<br />
<br />
SG
Cause is effect concealed. Effect is cause revealed.
|
|
|
|
|
hi all,
I am working in sql 2005 migration.
when i ran same query in sql 2000 and sql 2005,no of values return are same.But the Resulting data is in different order.
In sql 2005 the data returns either in asc or desc order.
In sql 2000 the data returns in random order.
plz clarify me
1.the reason for the rows order difference.(is it because of execution plan?)
2.The resulting data of sql2005 should be in same order of sql 2000.
how to overcome this problem.
Thanks in advance,
cheers
sangeet
|
|
|
|
|
ramyasangeet wrote: 1.the reason for the rows order difference.(is it because of execution plan?)
The order in which the rows are returned is determined by a lot of factors, clustered index, page placements, row order etc. For example, if there's a clustered index on the table, the optimizer will find it cheaper to return rows in the index order. Also, the query engine has undergone vast changes in 2005 compared to 2000.
ramyasangeet wrote: 2.The resulting data of sql2005 should be in same order of sql 2000.
Use an Order by clause.
SG
Cause is effect concealed. Effect is cause revealed.
|
|
|
|
|
As the previous poster said, if you want a specific order then use the order by clause. Do not rely on the intrinsic order that SQL Server uses as it can, as you've seen, be non-deterministic.
|
|
|
|
|
Dear all
I created a Data Entry web page (PHP) that has a form with a number of components such as name, mobile , age, etc... (text fields). These data is entered in the database. This page is used by more than one user at a time.
The problem is that some records are entered twice or more in the database. There are some records was entered 15 times and all of them at the same time.
I am sure that my code execute the SQL statment once only.
What could be the problem? Why the script is executed more than one time?
Is it a Thread issue?
Is it a Server issue?
My database is Oracle and the page is in PHP.
regards
-- modified at 2:47 Wednesday 28th November, 2007
|
|
|
|
|
hi mhmo
you see, sometimes when we design our tables, we bare in mind that there might be two "john" or "Marry", so we need to identify them uniquely, we add an identity column or we look for something that will make them unique, like Social Security number, or ID number in your Country, but if you want to use that you can use IDentity column, by that you can track your problem, Another thing is that after your user submit your form that will insert data into the table, you have make sure that your user click it once. after a user click your Submit or save button once, Disable your button and display a Progress bar and you will have less Problems.
Hope this Helps
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
hi
I know that. And already I have an identity column and also I am disabling the button.
It seems that the problem is a Thread related or Server related.
Thanks
|
|
|
|
|
hi
Am not strong in threads, i always make sure that i dont use them, but some situations like concurency handling, or your case, you have to use them. am sorry i could not help
thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
hi friends....I am using following query..its display output with site_id like row by row..but I want to display the site_id like 1,2,3,4,5(single row)...
SELECT dbo.ad_schedule.startdate, dbo.ad_schedule.enddate,
dbo.ad_sitereg.sitename, dbo.ad_schedule.Status, dbo.ad_schedule.creative_id,
dbo.ad_schedule.site_id
FROM dbo.ad_sitereg INNER JOIN
dbo.ad_schedule ON dbo.ad_sitereg.id = dbo.ad_schedule.site_id
WHERE (dbo.ad_schedule.Status = 'q') AND (dbo.ad_schedule.creative_id = '42')
anybody will plz reply me...
|
|
|
|
|
The following article[^] should help.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
thanks alot..really very nice....bye
|
|
|
|
|
Hello All,
I am using SSRS 2005. How do I do forms authentication based on user's role. I have searched on web and applied the code. I have used msdn supplied codes but no progress. I am struggling from many days over this issue. Can anyone help me please by giving me proper code wise solution?
Hello Paul M.,
Can you help me please. I have modified the code. I have put one another message, please help me for that also. Please give me any clue. so that I do the required settings with my reporting server and for client pc. If any setting require with cookie management and DCOM etc. please let me know.
Regards,
Manoj Sinha
-- modified at 11:03 Wednesday 28th November, 2007
|
|
|
|
|
i need solution for this question.
the question is given below :
Print the information of invoice table in the following format for all records –
The Invoice No. of Customer Id. {cust_id} is {inv_no} and Movie
No. is {mv_no)
|
|
|
|
|
SELECT 'The Invoice No. of Customer Id. ' + Cast(cust_id AS Varchar(100)) + ' is ' + Cast(inv_no AS Varchar(100)) + ' and Movie No. is ' + Cast(mv_no AS Varchar(100)) FROM TableA
Assuming all the three columns are are numeric (Cust_id, Inv_no, mv_no
Regards
KP
|
|
|
|
|
Hello,
I have executed a stored procedure written in SQL Server by calling it through VC++.
It was done through ODBC APIs SQLConnect(),SQLBindParameter(),SQLExecDirect() etc.
Now I want to pass parameters to the procedure I know the syntax that I am suppose to write in VC++.
But what changes should I make in the procedure in SQL Server.
I have the following stored procedure in SQL in which I want to accept 'LPG' and 'Mumbai' as parameters
CREATE PROCEDURE tryproc AS
SET @first = 0;
( SELECT SUM(t) AS first FROM demand WHERE product = 'LPG' AND LOCATION = 'Mumbai' )
create table abc (demandsum int);
insert into abc (demandsum) values (@first);
Is this the right forum to ask this question ?else direct me to the right forum.
Thanks
Prithaa
|
|
|
|
|
Read the documentation[^].
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
CREATE PROCEDURE tryproc(@product varchar(10),@LOCATION varchar(50))
AS
SET @first = 0;
SELECT SUM(t) AS first FROM demand WHERE product = @product AND LOCATION = @LOCATION
create table abc (demandsum int);
insert into abc (demandsum) values (@first);
N.Rajakumar B.E.,
Application Developer
|
|
|
|
|
prithaa wrote: Is this the right forum to ask this question ?
Yes it is.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hello All,
I am using SSRS 2005. I have problem on logon page, when cookie is not available. This should generate new cookie: But I am getting error and control returns.
I am getting following error: [System.NullReferenceException] = {"Object reference not set to an instance of an object."}
This comes with the 4th line of the code:
Following is the code:
internal static void RelayCookieToClient(Cookie cookie)
{
// add the cookie if not already in there
if (HttpContext.Current.Response.Cookies[cookie.Name] == null)
{
HttpContext.Current.Response.Cookies.Remove(cookie.Name);
}
HttpContext.Current.Response.SetCookie(TranslateCookie(cookie));
//HttpContext.Current.Response.AppendCookie(TranslateCookie(cookie));
}
-- modified at 1:13 Wednesday 28th November, 2007
|
|
|
|
|
There's 3 problems with your post.
1. Your title is too vague. Read the forum guidelines.
2. You haven't asked a specific question.
3. You've posted too much code. There's too much stuff to wade through. Again, identify what your problem specifically is and post only the code that is relevent.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hello Paul,
Can you help me please. I have modified the code. I have put one another message, please help me for that also. Please give me any clue. so that I do the required settings with my reporting server and for client pc. If any setting require with cookie management and DCOM etc. please let me know.
Regards,
Manoj Sinha
|
|
|
|
|
I'm not really sure what the problem is. I can see that you have lifted the code from a Microsoft sample application though. In the Microsoft sample, they use SetCookie rather than AppendCookie. However I'm not sure whether this is significant.
Is the code actually falling over on this line, or it it failing in TranslateCookie?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I am installing a new server, created my database with a script, loaded my database with my data. Using Enterprise manager, right click a table return all rows works fine, everything looks normal.
Now, go to SQL Query analyzer and run a select * from the table and I get no rows.
Create and ODBC connection and link the table in Access and I see my data, run a query from a simple web page and get no data.
any ideas?
Thanks in advance....
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
