T-SQL HELP NEEDED

Question

Post reply

T-SQL HELP NEEDED

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

fadewumi SSC Journeyman Points: 84 More actions · Answer 1

fadewumi

SSC Journeyman

Points: 84

April 22, 2013 at 11:47 am

#1608782

l have the management tool already install

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

fadewumi (4/22/2013)
l have the management tool already install

Great.

Start a new thread with questions you might have.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

fadewumi SSC Journeyman Points: 84 More actions · Answer 3

is there any website to learn this sql database very well

mbhandari Mr or Mrs. 500 Points: 578 More actions · Answer 4

How about this?

CREATE FUNCTION dbo.SplitString ( @string varchar(4000))

RETURNS @Result TABLE(SpiltedString VARCHAR(100))

AS

BEGIN

DECLARE @xml XML

SELECT @xml = CAST('<VALUE>'+ REPLACE(@string,',','</VALUE><VALUE>')+ '</VALUE>' AS XML)

INSERT INTO @Result

SELECT t.value('.', 'VARCHAR(100)') AS inVal

FROM @xml.nodes('/VALUE') AS x(t)

RETURN

END

GO

Create table #MYTEMP

(Id int ,

value nvarchar(100),

name varchar(50))

insert into #MYTEMP VALUES(1,'B,C,D','XYZ')

SELECT ID, fnResult.SpiltedString, name

FROM #MYTEMP

CROSS APPLY DBO.SplitString(value) as fnResult

DROP FUNCTION dbo.SplitString

DROP TABLE #MYTEMP

fadewumi SSC Journeyman Points: 84 More actions · Answer 5

fadewumi

SSC Journeyman

Points: 84

April 22, 2013 at 1:15 pm

#1608818

is that creating table

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

fadewumi (4/22/2013)
is that creating table

Ignore the post above this one of yours. I'm pretty sure it wasn't meant for you.

As Sean said earlier. please start your own thread to ask questions instead of using this one. It is just going to confuse you.

Start fresh.

Sean Lange SSC Guru Points: 286590 More actions · Answer 7

mbhandari (4/22/2013)
How about this?
CREATE FUNCTION dbo.SplitString ( @string varchar(4000))
RETURNS @Result TABLE(SpiltedString VARCHAR(100))
AS
BEGIN
DECLARE @xml XML
SELECT @xml = CAST('<VALUE>'+ REPLACE(@string,',','</VALUE><VALUE>')+ '</VALUE>' AS XML)
INSERT INTO @Result
SELECT t.value('.', 'VARCHAR(100)') AS inVal
FROM @xml.nodes('/VALUE') AS x(t)
RETURN
END
GO
Create table #MYTEMP
(Id int ,
value nvarchar(100),
name varchar(50))
insert into #MYTEMP VALUES(1,'B,C,D','XYZ')
SELECT ID, fnResult.SpiltedString, name
FROM #MYTEMP
CROSS APPLY DBO.SplitString(value) as fnResult
DROP FUNCTION dbo.SplitString
DROP TABLE #MYTEMP

Please see the article in my signature about splitting strings. It will show you a better alternative than this type of xml splitter for splitting strings. It includes code almost exactly the same as this splitter and demonstrates a way that is WAY faster.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 8

fadewumi (4/22/2013)
is there any website to learn this sql database very well

Heh... you're on it now. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)