hi,

first can u create one function to use below code.

CREATE FUNCTION SPLIT(@VAL VARCHAR(MAX))

RETURNS @T1 TABLE(COL1 VARCHAR(MAX))

AS

BEGIN

WHILE CHARINDEX(',',@VAL)>0

BEGIN

INSERT INTO @T1 VALUES(SUBSTRING(@VAL,1,(CHARINDEX(',',@VAL))-1))

SET @val=SUBSTRING(@VAL,(CHARINDEX(',',@VAL))+1,LEN(@VAL))...

whev ever i had run package through command prompt below sitution.

when ever i have created connection in project level

that time package was failed.

when ever i have created connection in package...

i am saying how i mapped configuration in ssis package.

when ever i had run that package in bids it is excuting suceessfully.

when ever i will run through command prompt that...

thanks for gave replay.

actualy cube was deployed s1 server.

i have sehedule job s2 server.

in server s2 the sql server agent was working.

how i will use environment variable in command prompt..

try two plackages run parallel.

because right now u got error was connection related error.whenever totrying connecting multiple connection same database then connection error will come.

Excution1: P1->P2

...

use below code.

declare @TBLCOLOR TABLE

(ID INT, COLOR VARCHAR(20))

Insert into @TBLCOLOR

SELECT 1,'RED'

UNION ALL

SELECT 2,'BLUE'

UNION ALL

SELECT 3,NULL

UNION ALL

SELECT 4,'GREEN'

UNION ALL

SELECT 5,'BLACK'

UNION ALL

SELECT 6,NULL

DECLARE @COLOR VARCHAR(20)=NULL

SELECT * FROM @TBLCOLOR

--WHERE ISNULL(COLOR,'U') IN(CASE WHEN...

in Stored procedure also declare @var datetime

---

ssrs

exec S_t @Date

Sql server

Create Proc S_t(@Date datetime)

as

select * from table_name)

where date in(@Date)

end

check ...

Do you have index on ID column ?

if there is no index on id column then create non cluster index on id column

after that

try below code.

DECLARE @T1...

Please select parameter type is datetime.

adv of nolock it is removing dead lock.

for live data nolock option don't use.

if you normailly not live data that time nolock will more useful.

nolock option it good for reading data.

pls create index on ORDER_DATE,COMMIT_NO column

after that pls excute below code.

select * from

(SELECT *,ORDER_DATE+COMMIT_NO new_id

FROM TABLE A (NOLOCK))k

WHERE new_id

NOT IN

(SELECT...

pls use below code...

declare @t1 table(fname varchar(50),lname varchar(20))

insert into @t1(fname,lname) values('sql','server')

insert into @t1(fname) values('ravi')

insert into @t1(lname) values('kumar')

select *,case when (fname is not null) and (lname is not null) then fname+'.'+lname

...

create linked server try to use that linked server..

In that report take one more table item After you will do grouping on product next comun use count funcation............