Click here to Skip to main content
15,891,529 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: ASP.net master page redirect Pin
raju melveetilpurayil30-Jun-10 21:19
professionalraju melveetilpurayil30-Jun-10 21:19 
Questionvirtual directory session issue in asp.net Pin
Harry@NewDelhi30-Jun-10 18:51
Harry@NewDelhi30-Jun-10 18:51 
AnswerRe: virtual directory session issue in asp.net Pin
Venkatesh Mookkan30-Jun-10 19:46
Venkatesh Mookkan30-Jun-10 19:46 
QuestionName the table in Dataset Pin
indian14330-Jun-10 13:21
indian14330-Jun-10 13:21 
AnswerRe: Name the table in Dataset Pin
PSK_30-Jun-10 17:13
PSK_30-Jun-10 17:13 
GeneralRe: Name the table in Dataset Pin
indian14330-Jun-10 19:44
indian14330-Jun-10 19:44 
AnswerRe: Name the table in Dataset Pin
Prosanta Kundu online30-Jun-10 20:08
Prosanta Kundu online30-Jun-10 20:08 
QuestionXML issue Pin
bigphish30-Jun-10 4:57
bigphish30-Jun-10 4:57 
I am trying to insert dataset as xml datatype,although the query is working fine, I am getting error in the application.
error:Cannot drop the table '#temp2', because it does not exist or you do not have permission.

I have tried alot to fix this..every thing in my query seems fine.adding the Query below:

create table #temp2 (JobID int,winnerId int,Title Nvarchar(50),FirstName nvarchar(50),LastName nvarchar(50),
Destination nvarchar(50),DateBooked datetime,DateDeparture datetime,Operators nvarchar(50),PhoneHome nchar(25),
PhoneWork nchar(25),Address nvarchar(200),TCAT nvarchar(50),Notes nvarchar(50),LastModifiedBy nvarchar(50),LastModifiedDate datetime)

	insert into #temp2


	SELECT  
		Data.Col.value('JobID[1]','int')as JobID,
		Data.Col.value('WinnerID[1]','int')as WinnerID,
		Data.Col.value('Title[1]','nvarchar(50)')as Title,
		Data.Col.value('FirstName[1]','nvarchar(50)')as FirstName,
		Data.Col.value('LastName[1]','nvarchar(50)')as LastName,
		Data.Col.value('Destination[1]','nvarchar(50)')as Destination,
		convert(datetime, left(Data.Col.value('DateBooked[1]','varchar(50)'),10)) as DateBooked,
		convert(datetime, left(Data.Col.value('DateDeparture[1]','varchar(50)'),10)) as DateDeparture,
		Data.Col.value('Operators[1]','nvarchar(50)')as Operators,
		Data.Col.value('PhoneHome[1]','nchar(25)')as PhoneHome,
		Data.Col.value('PhoneWork[1]','nchar(25)')as PhoneWork,
		Data.Col.value('Address[1]','nvarchar(200)')as Address,
		Data.Col.value('TCAT[1]','nvarchar(50)')as TCAT,
		Data.Col.value('Notes[1]','nvarchar(50)')as Notes,
		Data.Col.value('LastModifiedBy[1]','nvarchar(50)')as LastModifiedBy,
		convert(datetime, left(Data.Col.value('LastModifiedDate[1]','varchar(50)'),10)) as LastModifiedDate



	FROM @Winnerpersonal.nodes('/NewDataSet/WPersonal') AS Data(Col)


	insert into tbl_WinnerPersonal(JobID,Title,FirstName,LastName,Destination,DateBooked,DateDeparture,Operators,PhoneHome,PhoneWork,Address,TCAT,Notes,LastModifiedBy,LastModifiedDate)
	select @JobID,Title,FirstName,LastName,Destination,DateBooked,DateDeparture,Operators,PhoneHome,PhoneWork,
	Address,TCAT,Notes,LastModifiedBy,LastModifiedDate from #temp2	where WinnerID < 0
drop table #temp2 


CAn any one know wherer I went wrong??
AnswerRe: XML issue Pin
Not Active30-Jun-10 5:10
mentorNot Active30-Jun-10 5:10 
AnswerTry not dropping the temp table Pin
David Mujica30-Jun-10 5:36
David Mujica30-Jun-10 5:36 
AnswerRe: XML issue Pin
Ennis Ray Lynch, Jr.30-Jun-10 7:34
Ennis Ray Lynch, Jr.30-Jun-10 7:34 
QuestionROLE Management Pin
Amit Patel198530-Jun-10 4:31
Amit Patel198530-Jun-10 4:31 
AnswerRe: ROLE Management Pin
Ennis Ray Lynch, Jr.30-Jun-10 7:36
Ennis Ray Lynch, Jr.30-Jun-10 7:36 
QuestionPage.PreviousePage Problem Pin
sjs4u30-Jun-10 3:02
sjs4u30-Jun-10 3:02 
QuestionHow to view/edit microsoft documents via online Pin
cocoonwls30-Jun-10 1:55
cocoonwls30-Jun-10 1:55 
AnswerRe: How to view/edit microsoft documents via online Pin
Not Active30-Jun-10 2:31
mentorNot Active30-Jun-10 2:31 
GeneralRe: How to view/edit microsoft documents via online Pin
cocoonwls30-Jun-10 21:54
cocoonwls30-Jun-10 21:54 
AnswerRe: How to view/edit microsoft documents via online Pin
Peace ON30-Jun-10 2:56
Peace ON30-Jun-10 2:56 
GeneralRe: How to view/edit microsoft documents via online Pin
cocoonwls30-Jun-10 21:58
cocoonwls30-Jun-10 21:58 
QuestionRepeaterItems Problem Pin
-Muc_30-Jun-10 1:18
-Muc_30-Jun-10 1:18 
QuestionImplementing an ASP.NET app with ASP classic [modified] Pin
Tim Carmichael29-Jun-10 2:57
Tim Carmichael29-Jun-10 2:57 
AnswerRe: Implementing an ASP.NET app with ASP classic Pin
R. Giskard Reventlov29-Jun-10 3:02
R. Giskard Reventlov29-Jun-10 3:02 
AnswerRe: Implementing an ASP.NET app with ASP classic Pin
Not Active29-Jun-10 3:56
mentorNot Active29-Jun-10 3:56 
QuestionRequires extended permission: share_item in facebook Pin
praveenkumar_mca29-Jun-10 1:52
praveenkumar_mca29-Jun-10 1:52 
QuestionCOM objects-asp.net Pin
Morgs Morgan29-Jun-10 1:15
Morgs Morgan29-Jun-10 1:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.