Whats the function to convert roman numerals to int? 😉

Are you doing this in Reporting Services?

If so, you need to compile the proc in sql, then select that procedure as the source of your dataset, then map your report...

Something like this might work.

CREATE PROC donkey (@MonthNum int, @Year int)

AS

DECLARE @query_head nvarchar(1000), @query_foot nvarchar(100), @sql_string nvarchar(1500)

SET @query_head = 'SELECT * FROM [dbo].[ProductRank~QD~1~'

SET @query_foot = RTRIM(CONVERT(char(2),@MonthNum)) + '~' +...

here's some:

http://www.jumpstarttv.com/Channel.aspx?cat=4a80fb97-198c-4277-ac24-e2cc77d53561

Not free, but cheap:

http://www.learnintegrationservices.com/VideoTutorials/

I recently had to do something similar and I have always used NOT EXISTS correlated subqueries. I experimented with several methods (sub query, outer join, in ()) and found something...

If you are using SQL 2005, can you use row_number() instead of the identity column?

Something like:

INSERT@ECFMaster (RowID , ECFID , Effective)

SELECTROW_NUMBER() OVER (ORDER BY ECF_ID,corrected_Effective_Date ),

ECF_ID,

corrected_Effective_Date

FROMEffectivereports.Effectivereports.ECFIndiaMaster

WHEREEmp_ID=@Emp_ID

You may be able to copy and paste the file spec and create a script to build a table with the required structure.

Then upload the file into a single column...

Can you dynamically construct a bcp statement?

Tommy Bollhofer (10/2/2007)

---

Hi Emily,

Is there an FW between the MSSQL server and the SMTP relay? If this is the case, can you confirm w/ IT that TCP 25 is open...

Do you have to update or can you insert ?

INSERT cross_tab_table

select id,

sum(CASE WHEN MM = 1 THEN TotalAmount ELSE 0 END) as JAN_TOTAL,

sum(CASE WHEN MM =...

I think you need to define relationships between the tables; foreign key/primary keys in the actual database or on the data source view.

If you are looking for training materials, you might consider looking here:

http://www.learnsqlserver.com/VideoTutorials/

http://www.learnintegrationservices.com/

I havent used any of the videos so I dont know how good they are, but they are...