Got job opportunity for SSIS Developer. Also have another for Database Developer but haven't started the process. With SSIS Developer, salary will be lower than the DB Developer.

Which one would...

Feel free to share your experiences as well.

Thanks.

Thanks Koen for providing insights.

I had worked with SSRS. Little experience with SSIS. No experience with SSAS. My experience is on building databases and reports of web applications.

I'm also...

Strange thing that has been observed using the same query. It works on my local host (SQL 2008 R2) while it does not on dev environment (SQL Server 2005 Express).

I...

Moved this thread to General Discussions: http://www.sqlservercentral.com/Forums/Topic1388283-149-1.aspx

Hi there,

Have you tried putting END keyword in CASE?

CASE WHEN <column> IS NOT NULL THEN 'Text' END

Just trying to help.. 😛

Hi there,

I was also faced with the same situation a week ago.. GROUP BY did the trick.. I'm not sure if this would be performance-wise so try testing it to...

Hi there,

This may also work.. See if this helps..

;WITH cte AS

(

SELECT [Date], [Level], ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS id

, ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) - ROW_NUMBER() OVER...

Quatrei.X (9/13/2010)

---

also, which is more important, Scan count or logical reads???

I don't really know which among these is the best implementation or maybe you guys could provide something better. "mine...

I think using XML datatype model would be more efficient.. I need to test them both though..

The query that...

Hi there,

Is this what you're trying to do?

select * from Table1 WHERE column1 NOT IN (

SELECT column1 FROM Table2

UNION ALL

SELECT column1 FROM Table3

UNION ALL

SELECT column1 FROM Table4

)

Hope this helps.. 🙂

When i was searching for EAV, I came across with this article by Joe Celko (thanks!):

http://www.simple-talk.com/sql/t-sql-programming/divided-we-stand-the-sql-of-relational-division/

This presents different methods for relational division.. To my surprise, the topic under...

@joe,

Thank you for showing me the right direction.. So, this is called EAV model.. I'll stay away from this method and migrate to XML.. With proper xml indexes,...

@Quatrei

Thanks you very much for your help.. Your code is much cleaner and faster now! And this also does not use dynamic SQL.. 😀

However, I just have this one challenge...

I used EXCEPT and INTERSECT to avoid dynamic SQL.. Will this impose performance issue than its dynamic SQL counterpart? Please advise.. I would really appreciate your input..

Thanks.. 🙂