[font="Verdana"]try this ...

--Declare @strSql nvarchar(4000)

Begin

Create table #TempTab (SNO int, Activity nvarchar(100), [Client] nvarchar(1000), [Delivery Head] nvarchar(1000), [PDC] nvarchar(1000), [Project Manager] nvarchar(1000), [Team Member] nvarchar(1000), [Tech Supp] nvarchar(1000))

--print @strSql

--exec sp_executesql @strSql

SELECT...

[font="Verdana"]does it throwing any error? Or whether do you able to connect to DB or not ?

Meantion some more details.

By the way, at UserId add domain name. i.e. UserID should...

[font="Verdana"]Hopes it will help you a lil bit.

http://support.microsoft.com/kb/316005

Mahesh[/font]

[font="Verdana"]Really not getting what do you mean. If possible, psecify with the desired o/p with real life example.

Mahesh[/font]

[font="Verdana"]Johann, look at the below SProc, I tried to update.

ALTER PROCEDURE [dbo].[sp_getpageidsforedb]

@projectid int

AS

Set Nocount On

Begin

create table #ebdindex (

[indexid] [int] IDENTITY (1, 1) NOT NULL ,

[stringid] [nvarchar](4000)COLLATE Latin1_General_CI_AS,

[trans]...

[font="Verdana"]

Samuel Vella (4/15/2008)

---

Mahesh Bote (4/15/2008)

---

No need to write separate select for assigning values for multiple variables. Within the single Select this can be done and even it is faster than...

[font="Verdana"]

Samuel Vella (4/15/2008)

---

declare @HasAnyRows int

DECLARE @COL VARCHAR(50)

DECLARE @Section int

SELECT @Section = 1

SELECT @HasAnyRows = 0

IF @HasAnyRows <= 0 and @section = 1

SELECT...

[font="Verdana"]Something seems to be contrast in what you required and what you have already written. You have two date parameters in your Store Procedure. The same you have used in...

[font="Verdana"]

Jeff Moden (4/14/2008)

---

You don't need XML for this... you can just do an INSERT with the understanding that there is no real good way to return the UniqueIdentifiers to the...

[font="Verdana"]No you can't view. You need to select the specific database.

Mahesh[/font]

[font="Verdana"]

try this ...

Select * Into {New Table Name} From {Old Table Name}

This will create new table with the data and structure of old table. And if you want only structure...

[font="Verdana"]Ashok, this can be done through using XML. What we do is, we build single XML string and we pass it to the SProc. Inside the SProc such string treated...

[font="Verdana"]

A query is covered if all the columns it uses come from one or more indexes. These...

[font="Verdana"]

set @account=isnull((select TOP 1 min(g.account) from guest g, z_property z where (g.room=@room_code and g.status='I') or (g.room=@room_code and g.status='O' and CONVERT (datetime,departure,1) ' + ' CAST (out_time as datetime)...

[font="Verdana"]Do you have MDAC 2.7 (Microsot Data Access Component) or later version installed on machine. If no, install it and try again.

Let us know.

Mahesh[/font]