nicolas.pages (3/10/2008)

---

Hi,

I am wondering if it is possible to create a temp table with a parameter that would contain the number of columns of the temp table. All the columns...

abansil (3/10/2008)

---

The Database Engine service could not resolve the specified file location. Either the location does not exist, or the current login account does not have access to it....

abansil (3/10/2008)

---

The Database Engine service could not resolve the specified file location. Either the location does not exist, or the current login account does not have access to it....

The "s" table alias is restricted to your insert statement, and does not go into the begin statement or higher. E.g. you could have a second insert/select statement in the...

rrhode (3/10/2008)

---

Thanks very much for the speedy reply. This the result I got from print (@w_sql)

CREATE VIEW GI.vGI_CL_200712_EBVG_RJ_Test

AS

DELETE *

FROM ( SELECT * FROM GI.vGI_CL_200712_EBVG_RJ_Test

WHERE ACRMVTTYP_CDE...

Whoknow (3/10/2008)

---

Hi all,

I have 2 tables as below

Company: id, CompanyName

Employee: id, CompanyID, EmployeeName

as you guys can see that Employee.CompanyID is a foreign key link to Company...

Mohan Kumar (3/8/2008)

---

Hi Sarvesh,

I understand you have performed backup of database not imported data. If it is then following command will help you to restore .csv file:

restore database Test from...

You could also use the COLLATE keyword...

guptaopus (3/10/2008)

---

Hi,

I would like to use a stored procedure that calls other stored procedures and use a

temporary table to pass the results back and forth.(from Parent to child)

anybody help me...

rrhode (3/10/2008)

---

I hope I am in the right forum.

I am running the stored proc below that creates a view.

Is the code I`m using valid??

CODE:

set @w_sql = 'CREATE VIEW ' +...

shogg (3/7/2008)

---

Thanks for the quick reply.

So in 2000 I should create a temp table and insert to that temp table? Since I am in a function it wont let...

metoseeu (3/6/2008)

---

Hi

My objective is to display all the record information of a particular column in single cell.

tablename

Iden Code

2BB

4BB

4CH

Result should be something like ----BB,BB,CH.

I used the...

I'm sure we could...

You...

Sorry, on SQL Server 2000 you cannot use table variables for inserting into, so here is a version with temporary tables:

DECLARE @RET_VAL DECIMAL(13, 2) ;

DECLARE @Formula AS VARCHAR(255) ;

-- function...