Click here to Skip to main content
15,790,440 members
Home / Discussions / Database
   

Database

 
AnswerRe: writing complex queries in Sql Pin
Mycroft Holmes8-Apr-18 13:57
professionalMycroft Holmes8-Apr-18 13:57 
AnswerRe: writing complex queries in Sql Pin
CHill609-Apr-18 0:33
mveCHill609-Apr-18 0:33 
AnswerRe: writing complex queries in Sql Pin
Eddy Vluggen9-Apr-18 3:16
professionalEddy Vluggen9-Apr-18 3:16 
QuestionConfiguring multiple properties or values in SSIS Package using Package Configuration file Pin
indian1432-Apr-18 15:18
indian1432-Apr-18 15:18 
QuestionTrying to insert values into Table Variable in Dynamic Sql Pin
indian1432-Apr-18 14:17
indian1432-Apr-18 14:17 
AnswerRe: Trying to insert values into Table Variable in Dynamic Sql Pin
Mycroft Holmes2-Apr-18 15:22
professionalMycroft Holmes2-Apr-18 15:22 
GeneralRe: Trying to insert values into Table Variable in Dynamic Sql Pin
indian1433-Apr-18 8:49
indian1433-Apr-18 8:49 
AnswerRe: Trying to insert values into Table Variable in Dynamic Sql Pin
Richard Deeming3-Apr-18 9:44
mveRichard Deeming3-Apr-18 9:44 
indian143 wrote:
@Results Results READONLY

There's a slight clue in that line to suggest that you can't write to the table valued parameter. Smile | :)
Table-valued parameters must be passed as input READONLY parameters to Transact-SQL routines. You cannot perform DML operations such as UPDATE, DELETE, or INSERT on a table-valued parameter in the body of a routine.

If you need to write to the table, use a temp table instead. It looks like you at least started trying to do that - one of the commented-out lines refers to #results instead of @results.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: Trying to insert values into Table Variable in Dynamic Sql Pin
indian1434-Apr-18 13:35
indian1434-Apr-18 13:35 
GeneralRe: Trying to insert values into Table Variable in Dynamic Sql Pin
Richard Deeming5-Apr-18 9:06
mveRichard Deeming5-Apr-18 9:06 
QuestionMysql database problem Pin
Member 1375522730-Mar-18 19:12
Member 1375522730-Mar-18 19:12 
AnswerRe: Mysql database problem Pin
A_Griffin30-Mar-18 22:41
A_Griffin30-Mar-18 22:41 
GeneralRe: Mysql database problem Pin
Member 1375522730-Mar-18 22:55
Member 1375522730-Mar-18 22:55 
GeneralRe: Mysql database problem Pin
A_Griffin30-Mar-18 23:12
A_Griffin30-Mar-18 23:12 
GeneralRe: Mysql database problem Pin
Victor Nijegorodov30-Mar-18 23:45
Victor Nijegorodov30-Mar-18 23:45 
GeneralRe: Mysql database problem Pin
jschell31-Mar-18 8:29
jschell31-Mar-18 8:29 
GeneralRe: Mysql database problem Pin
Victor Nijegorodov31-Mar-18 21:56
Victor Nijegorodov31-Mar-18 21:56 
AnswerRe: Mysql database problem Pin
jschell31-Mar-18 8:34
jschell31-Mar-18 8:34 
QuestionSSIS package and package in a SQL server agent Job Pin
VK1927-Mar-18 9:27
VK1927-Mar-18 9:27 
GeneralRe: SSIS package and package in a SQL server agent Job Pin
CHill6027-Mar-18 23:09
mveCHill6027-Mar-18 23:09 
GeneralRe: SSIS package and package in a SQL server agent Job Pin
VK1928-Mar-18 3:06
VK1928-Mar-18 3:06 
GeneralRe: SSIS package and package in a SQL server agent Job Pin
CHill6029-Mar-18 13:27
mveCHill6029-Mar-18 13:27 
AnswerRe: SSIS package and package in a SQL server agent Job Pin
#realJSOP29-Mar-18 9:54
mve#realJSOP29-Mar-18 9:54 
QuestionApplication stopped working after backup and restoring the Database with another name Pin
indian14326-Mar-18 9:55
indian14326-Mar-18 9:55 
AnswerRe: Application stopped working after backup and restoring the Database with another name Pin
Richard Deeming26-Mar-18 11:00
mveRichard Deeming26-Mar-18 11:00 

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.