You could right click on the table in SSMS and select SCRIPT TABLE AS / SELECT To / New query editor window.

That will build a SELECT query for you containing...

If you're using full cache, I am not certain that the index will help (it's loading all the columns into memory anyway) - but worth a test.

The index would, however,...

The same comment applies as from your last thread. There is no guaranteed row order in SQL tables, therefore you cannot ask for 'the first occurrence' unless you define an...

ganeshkumar005 (8/24/2012)

---

for 'D1234', the first time it appears while reading from top, the value against it is 1001. I want this row in result. And skip the others if 'D1234'...

ganeshkumar005 (8/24/2012)

---

I have a table:

D12341001

A11224001

D12342001

C13425001

B19646001

A11223001

you can see leftside values D1234 and A1122 are repeated. Now I want the result as very first numerical ID returned when I meet the alphanumeric...

Charmer (8/24/2012)

---

i read the article Phil,

Could you please give me your idea for my condition?

My situation is , Look up or...

Consider changing the cache mode. See here.

raghuldrag (8/23/2012)

---

select slno,goals_type,entrydate,

goals,date_of_commitment,kpi,

weightage,goals_review_date

--into #temp

from LIMS..GOALSDTL_Audit where accyear>='20110101' and accyear<='20120101'

and empcode=002244 order by slno

how to create procedure for dis..... while i am crearting procedure its...

Koen Verbeeck (8/23/2012)

---

The easiest solution would be executing the stored procedure in the OLE DB Source, but not storing the results in a temp table but sending them to the...

I've used the File Watcher task in the past for situations like this. See here.

In summary, you execute your package with the FW task as the first task in the...

MSzI (8/23/2012)

---

I would suggest:

IF EXISTS (SELECT 1 FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N'[ABC_SCHEMA].[ABC_TABLE]') AND [Type] IN (N'U'))

DROP TABLE [ABC_SCHEMA].[ABC_TABLE]

Because:

1. It's safer to check the schema in witch the...

What language is this that you are coding in?

Actually, my name is now 'Pro' 🙂

n79799 (8/22/2012)

---

If you really want to directly check for a config file's availability, you can have a script task at the beginning of you package, which checks for the file...

You appear to have written your entire question in the subject line, leaving the body of the question blank - but you are new, so please be aware in...