--Question 11 .No of Employees Joined in each year, output of this query should be “Year”, “No Of Employees Joined”

select

distinct DateOfJoin,

COUNT(EmployeeID) No_Of_EmployeesJoined

from...

Tkq for ur quick rply @padhis .... Can u plz alobrate the Use of source control in brief 🙂

Is their any other way by doing ths in quary...

What i understand is two persons EXEC same Store Procedure same time....Isit ur qus ?

to ans that let me conform these points.:-)

1.They both EXEC in the same session or same...

anandha31 (12/6/2011)

---

Dear Sujeet,

Thanks for your reply. Actually I want to know when data are inserting / updating / deleting into the table and by whom...

kyle.doouss (12/6/2011)

---

Sorry I have not created a package yet.

Below is what I am trying to do.

1. The website sends a file to the ftp site (say tab delimited) ...

Kevin Drysdale (12/5/2011)

---

Using Import/Export Wizard. This is a test database. Taking it straight to the table. I did drop and recreate the table. Same thing. I can try creating a...

kyle.doouss (12/6/2011)

---

I faced now issues regards exporting a view to a flat file and sending it to the FTP site. Thanks for your clear instructions it worked first time!!

I...

WC...If u face any issues post it 🙂

kyle.doouss (12/5/2011)

---

Thanks. I have been having a look at it. Never realised there was this tool.

Do you have an example of what you have done similar to what...

sanjayasamantaray (11/25/2011)

---

Hi ,Thanks,

I can not use import and export wizard since

it is a manual process.

In my case there will be lot of clients.Each client will have a database and Client...

Can u plz explain a bit in detail 🙂 ....

Sry apologize me.....What i need is to load it like this ''1029097.9'' is their any way help me

What i xactly need is to remove all the fields after the...

Thanks 4ur rply guys......What i need is to load it like this '1029.9579' is their any way help me

steveb. (10/31/2011)

---

The precision and scale of your datatype is not large enough to support that number at that accuracy.

Your current dataype can support Five digits in front of the...

Tks for ur rply is it possiable to use cast or convert function their...