nguyenl71 39244 (2/2/2015)

---

Yes, I have try to use the File system task to copy the file to other folder c:\OutputClient\....xls but how can I append the format date like this....

I know that you are new here, so I'll try not to be too hard on you :-), but ...

Saying that a proposed solution 'does not work' is not very...

atul.jadhav (2/2/2015)

---

Dear Expert

I have below code which send email from SQL Table "testing$" with use of store procedure

but I am not getting any email, please check where is the error

and...

Could the table have been locked by another process?

+10!

Sean beat me to it again!

It would be a good idea to post the error message text. And to fix the fact that only single-row updates are handled.

bouazizimedridha (1/30/2015)

---

Hi,

Description :

I opened an existing package in visual studio 2012, and noticed on the OleDBDestination component that the selected DataAccessMode was "Table or View". The duration of the load...

atul.jadhav (1/30/2015)

---

Dear expert

I am using import/export wizard to upload excel in sql table

I have primary key in my table

and all primary key value has been change every day

i.e. I have...

sm_iransoftware (1/30/2015)

---

Because I read somewhere , PK and Clustered index, can be separate (These two do not necessarily Be one thing)

And it's better that clustered index related to Bussiness...

sm_iransoftware (1/29/2015)

---

I run this query on my database.

Most of the result are : PK_ ... ?

Why?

(note that in all our tables , we insert an id column - identical -...

umarrizwan (1/28/2015)

---

DECLARE @dbid INT

SELECT @dbid = DB_ID(DB_NAME())

SELECT OBJECTNAME = OBJECT_NAME(I.OBJECT_ID),

INDEXNAME = I.NAME,

I.INDEX_ID

FROM SYS.INDEXES I

JOIN SYS.OBJECTS O

ON I.OBJECT_ID = O.OBJECT_ID

WHERE OBJECTPROPERTY(O.OBJECT_ID,'IsUserTable') = 1

AND I.INDEX_ID NOT IN (

SELECT S.INDEX_ID

FROM SYS.DM_DB_INDEX_USAGE_STATS S

WHERE S.OBJECT_ID...

prasadau2006 (1/28/2015)

---

Hello Friends,

I need help with the following query, this query is taking more than 20mins to complete. I'm using a left join to

pull the data.

Query:

Insert into dbo.SecondTable

Select b.*...

A quick note: starting a CTE with a semicolon is like starting a sentence with a '.'

toraghubiz (1/28/2015)

---

Table Dept has two columns (did(int) , dname(varchar)).

Table emp has five columns (eid(int), mid(int), nme(varchar), did(int), city(varchar)).

Now I need to get the names of all departments having more than...

DonlSimpson (1/27/2015)

---

I know this is fairly radical, but I enforce an alphabetic order to the column list in the schema. My only concession is pk first.

I got...