Agree XD

Yeah, I already thought of dynamic sql, but didn't like the idea since my procedure is a long one and it'll make the script less readable and harder to update...

Well actually :hehe: just a bit for some aesthetics, hahaha. yeah, not really important.

See, my boss liked how my script produces print outputs, and having the default SQL error output......

:w00t: Yeah, I've thought about binary, just thinking... wonder what's on their mind why they decided to implement this. XD

Hi,

just read the forum today. I know your gonna use XML already but... :hehe:I still wanna have fun with this just for additional knowledge.

DECLARE @student TABLE (id int, fieldname varchar(max),...

Hi there,

I tried this one:

SELECT ID FROM @student s

EXCEPT

SELECT sf.ID FROM @student s

INNER JOIN @Search_Parameter sp ON (s.fieldname=sp.fieldname AND s.value=sp.value)

RIGHT OUTER JOIN @student sf ON (sf.id=s.id AND sf.fieldname=s.fieldname)

WHERE s.id IS...

Just noticed something small but not really that important.

rename E6 to E8 ???

just noticed hehehe XD

thanks for the function ^__^

agree

Hi there,

I'm not quite sure if this is a good implementation but atleast it doesn't use sub query.

--//SAMPLE TABLE

DECLARE @tbl TABLE

(

Value DECIMAL(5,2)

)

--//SAMPLE DATA

INSERT INTO @tbl

SELECT 112.34

UNIONSELECT 256.78

UNIONSELECT 390.12

UNIONSELECT 434.56

UNIONSELECT 178.90

UNIONSELECT...

:w00t: COOL! Thanks a lot everyone.

:hehe: I haven't used SET STATISTICS TIME (ON|OFF) before. Thanks 😀

that's the one you guys used right? or is there a tool or something like...

Jeff Moden (6/29/2010)

---

WayneS (6/28/2010)

---

I believe I saw a follow-up post from Jeff where he...

:w00t: First of all, thanks kingston, steveb and skcadavre

I saw the links using tally via table and CTE

I have 2 follow up questions.

Question 1:

Use tally table or CTE... which is...

Kingston Dhasian (8/26/2010)

---

Yes. You can surpass the limit by setting the value for MAXRECURSION as 0.

OPTION (MAXRECURSION 0)

But always make sure you don't go into an infinite loop by using...

hmmmm...

:hehe: I was planning to create a generic function which gets a comma separated list of words in a string and use CTE to seperate those strings to table rows.

:-)...

Hi There,

(edited my post)

--// SAMPLE PROCEDURE

CREATE PROCEDURE dbo.usp_my_stored_proc

@value1 INT,

@value2 INT,

@value3 INT

AS

BEGIN

SELECT @value1 AS 'Value1'

...