Hi,

I added one more join and it workf fine

SELECT A.ROOL_NO, A.NAME, PHYSICS, CHEMISTRY, MATHS, TOTAL

FROM STUDENT A

INNER JOIN

(SELECT ROOL_NO, [P] AS PHYSICS,[C] AS CHEMISTRY,[M] AS MATHS

FROM

(SELECT ROOL_NO,SUBJECT,MARKS

FROM STUDENT_NUMBER...

Thanks to all.. I got book what is suggested by grant ..

Thanks!

small correction...

Hope this works....

select a.userid, c.username, b.teamname from userteam a join

(select userid, teamid, max(created) created from userteam group by userid, teamid)x

on a.userid = x.userid and a.teamid = x.teamid and...

use SUBSTRING function

SUBSTRING(name,2,2) = 'ab'

Hope it will work out...

Thanks!

Hi,

Here is solution:-

1) Source :- Flat file use DT_STR for Date column

2) Derived Column :- Replace this with using

SUBSTRING([Column 2],4,4) + "/" + SUBSTRING([Column 2],5,2) + "/" + SUBSTRING([Column...

hI,

Use Derived column and put

SUBSTRING([Column 2],4,4) + "/" + SUBSTRING([Column 2],5,2) + "/" + SUBSTRING([Column 2],7,2)

in expression and data_type DT_DATE

Thanks!

Hi,

Issue with date column... use DT_STR and then in derived column use substring to include // so date will become 2007/04/05 and then transfer data to destination...

it will work...

Use execute sql task component in control flow if you only need result set coming from this query or

use look up table make table b as lookup if you...

Select TableA.ID,TableA .Name,Val,access

from TableA,TableB

Where TableA .id = TableB.Id

Thanks!

I think SUBSTRING(ENCT_HDR_BATCH_ID, 4, 4) is wrong

use SUBSTRING(ENCT_HDR_BATCH_ID, 4, 1) and then try it...

as 4,4 will take space i think... so use 4,1 so it will take only P...

Could you provide some sample data .. It might help to understand problem in better way...

Thanks!

use data conversion transformation component insted of dervied column..

Thanks!

This link will be ur answer...

http://wiki.sqlis.com/default.aspx/SQLISWiki/Row%20Count%20Transformation.html

Thanks!

Thanks..

Do we have any tool in sql server to identify which transcation or select statement is taking time ?

I have SP with 100 of select statement then how to proceed...

Thanks steveb..

I also only have this approach in my mind but as some of my head is asking that couls you have any approach which is better than this...