Hi

Thanks for the reply. I am able to get the data from execute sql task and link to Dataflow task.

Data flow task will have Excel data source...

Hi,

Thanks for the reply. I created variable and mapped to the results of execute sql task.

Execute SQL task is on Control Flow and my data retrieval from...

Hi

Thanks for the reply.

I have created the full text index on the table.

When I issued a query like

select * from tablename where contains(*,'Lon')

Its not retrieving anything. When I type...

Hi

Thanks for the replies. I have tried this and got the result as I want.

select provinceid, case when provinceid = 0 then '|__ ' + description else '| ...

Hi,

thanks for the reply. I got it.

Hi friends,

I got the query. I did as

SELECT

(

CASE WHEN m.Id = 1 THEN 0 WHEN m.TempId = 2 THEN

(

SELECT s1.D - s1.A FROM #TempResult s1 WHERE s1.Id...

Hi,

Thanks for the reply. Actually, this report is generated from 3 temp tables. The columns are as mentioned in my prev post. I can put one identity column...

Hi

Thanks for the reply.

My table definition is

Month Demand Capacity

Jul-2008 100 150

Aug-2008 200 210

Sep-2008 150 ...

Hi,

Thanks for the reply. Your suggestion could be fair if I am doing it manually. But, my task is to be done as a job in sql...

Hi,

Thanks for the replies. I did with global temporary table.

Any how the SP will execute only once and as a job.

So, global temporary table is fair enough.

thanks again...

Hi,

Thanks for the replies. I am posting the code where I got error

CREATE TABLE #TempTable

(

Demand NUMERIC(8, 0),

Capacity NUMERIC(8, 0),

...

Hi,

I've checked in Active Monitoring. The process is blocked by my own processid. STATE is in SLEEP mode. WAIT TYPE is PAGEIOLATCH SH

The problem is at...

Hi all,

thanks for the replies.

If I add extra drive, how can I split data files to share D drive and new drive?

Even I have compressed database or any other, at...

Hi

Thanks for your replies.

Yes, I will follow normal forms. Where do I make a note of all the constraints?

Is there any specific format?

Is there any modeling language to...

Hi,

I have another constraint. Among all type factors, I can have ByColorAndSize.

Means, White -> S -> 500

...