can u post the script

am (11/3/2008)

---

Guys,

I have an employee table in which each employee is categorized by employee type (up to 100 types). Currently I have 50 mill rows

in the table I run...

Aspet Golestanian Namagerdi (11/4/2008)

---

Hi,

I have query that ,when I try to run it, takes a very long time. But during the runtime if I cancel the running of that...

siddartha pal (11/4/2008)

---

We are facing some issue with Sql Server 2005 Database Mail Queue functionality using "msdb.dbo.sp_send_dbmail" system stored procedure. After some time email functionality goes into suspended mode. SQL...

vyas (11/4/2008)

---

Hi

I am planning for New Database Design. The major scope of this project is storing and viewing the documents of the clients. I will like to have your...

WayneS (11/3/2008)

---

I've set up Database Mail on my development server to test it out.

When I fire off a job that sends an email, I won't get the email for several...

khaysmer (10/31/2008)

---

OK I have a database I am working on the I had to place a sql server agent on to execute the stored procedure on. I told it to...

Manie Verster (11/3/2008)

---

Hi there,

I would like to know if it is feasible to do database mirroring on a 2GB database? This is the only database we have in the company...

aswanidutt.dasara (11/3/2008)

---

hi

sorry i forgot it , this is the updated one

ex:

create proc sp_books_outlet

@booknames varchar(100) output

as

select @booknames =b_name from historical.books

declare @booknames varchar(100)

exec historical.sp_books_outlet @booknames output

select @booknames

thanks for the...

Sridevi (11/3/2008)

---

CREATE TABLE Table1(A INT, B VARCHAR(10))

GO

CREATE TABLE TABLE2(C INT, D INT, E VARCHAR(10))

GO

Table1 DATA:

A B

------

1 XX

2 YY

Table2 DATA:

C ...

Sridevi (11/3/2008)

---

Hi all,

I have two tables with one to many relationship. Can i get the line table data separated by comma within a single select statement in sql 2005.

Eg:

Table 1:

A...

aswanidutt.dasara (11/3/2008)

---

hi

i am new to sqlserver. i want to know, how to get the values(data) from the column into a declared variable in stored procedures. here is the example...

deveshbhargava (11/2/2008)

---

I have a table with columns Item,FLQ1,FLQ2,FLQ3,FLQ4,SAS1,SAS2,SAS3.). In the table, I have each item associated with a unique id, and that unique id is linked to a separate...

madhu.arda (11/2/2008)

---

Hi,

can we move resource database mdf to one drive and ldf to other drive(resource database mdf to master database mdf location n resource database ldf to master database's ldf...

billross (10/16/2008)

---

I have a Doctor table and child tales of Specialties and Offices.

I want to put the specialties inline, but repeat the whole Doctor record for each office record. So...