If you are planning to sync to database tables between two different databases, you must be thinking of incremental data loads. In your case as I see it, may be...

Inner Join is the fastest way, if you are referring to a single user at any time.. see below code

SELECT c.PermID

FROM Users a

INNER JOIN UserType b ON a.UserID = b.UserID

INNER...

see this article I wrote on how to create a basic SSRS report using parameters http://sqlsaga.com/ssrs/how-to-create-a-basic-ssrs-report-with-parameters/[/url]. In your case I don't think you need the parameters.

SSRS again, not SRSS :D...

see this..

DECLARE @Input TABLE

(

Store_Number INT,

Store_Owner VARCHAR(32)

)

INSERT INTO @Input VALUES(542, 'Jaklin Givargidze'), (542, 'Raymond G. Givargidze'), (557, 'Hui Juan Lu'), (557, 'Tong Yu Lu')

SELECT DISTINCT Store_Number,

STUFF((SELECT ','+Store_Owner

FROM @Input...

This should work...

;WITH CTE AS (

SELECT ROW_NUMBER() OVER (Partition BY SalesOrder ORDER BY SalesOrder) AS RNum, *

FROM Table1

)

SELECT SalesOrder, ItemName, Price, Category

FROM CTE

WHERE Rnum = 1

See this article I wrote...

@TS : see this... http://www.codeproject.com/Articles/635956/How-to-export-data-from-database-tables-to-an-XML

you might have to change it to a table valued function may be and see if it can serve you the purpose. see this article http://www.sommarskog.se/share_data.html

You just gave a high level detail of your question. If you are just trying to load data into a SQL Table from a CSV file using SSIS, here is...

You can use two variables, one to store the current file name and to concatenate the file name. The way you do it is using an expression builder to the...

Daniness,

see if this works for you.. might be a starting point atleast..

;WITH CTE AS

(SELECT case when ath_stlmnt_instr_id is null then (select ae.stlmnt_line_instr_id from Accting_body ae where ae.header_id = ath_header_id and

ae.body_id...

Phil Parkin (4/13/2014)

Repeatedly hitting the database engine with queries which have nothing to do with data is not a good practice, in my opinion. You are generating unnecessary network traffic...

You can achieve that kind of a report in the image(which looks like a 3-D style report for me, may be wrong too). If you want to visualize more glossy...

As suggested above, if you can have the track of file every time you are saving to a table in the database (one simple Execute sql task can do), you...

Can you not use a lookup transformation instead of Merge? It's always good over Merge with the type of activity you are doing.

Thanks Jeff.. The indexes you specified are present. I have ended up with like the same query. I was thinking if there is any better approach than using the cross...