Click here to Skip to main content
14,367,083 members
   

Database

 
AnswerRe: Skeptical about Trigger! Pin
Mycroft Holmes15-Mar-13 0:58
memberMycroft Holmes15-Mar-13 0:58 
GeneralRe: Skeptical about Trigger! Pin
Jörgen Andersson15-Mar-13 3:16
protectorJörgen Andersson15-Mar-13 3:16 
GeneralRe: Skeptical about Trigger! Pin
Mycroft Holmes15-Mar-13 14:23
memberMycroft Holmes15-Mar-13 14:23 
GeneralRe: Skeptical about Trigger! Pin
Jörgen Andersson15-Mar-13 15:09
protectorJörgen Andersson15-Mar-13 15:09 
GeneralRe: Skeptical about Trigger! Pin
Thiru616-Mar-13 0:25
memberThiru616-Mar-13 0:25 
GeneralRe: Skeptical about Trigger! Pin
GuyThiebaut19-Mar-13 10:35
professionalGuyThiebaut19-Mar-13 10:35 
GeneralRe: Skeptical about Trigger! Pin
Jörgen Andersson19-Mar-13 11:28
protectorJörgen Andersson19-Mar-13 11:28 
QuestionDynamic Query for XML? Pin
kasimmohamed14-Mar-13 21:55
memberkasimmohamed14-Mar-13 21:55 
Hi all,

DECLARE @DocsList nvarchar(max);
SELECT @DocsList = STUFF(
(SELECT ', ' + quotename(Particulars)
FROM [101_SalaryParticulars]
GROUP BY Particulars
ORDER BY Particulars
FOR XML PATH(''))
, 1, 2, '');

I wants to change the above query dynamically. My table name will vary like '[102_SalaryParticulars]','[103_SalaryParticulars]' Etc.,
Software Engineer
AcSys IT Software Solution

AnswerRe: Dynamic Query for XML? Pin
Mycroft Holmes15-Mar-13 0:55
memberMycroft Holmes15-Mar-13 0:55 
GeneralRe: Dynamic Query for XML? Pin
Shameel15-Mar-13 2:14
professionalShameel15-Mar-13 2:14 
GeneralRe: Dynamic Query for XML? Pin
Eddy Vluggen15-Mar-13 2:29
mveEddy Vluggen15-Mar-13 2:29 
GeneralRe: Dynamic Query for XML? Pin
Mycroft Holmes15-Mar-13 14:20
memberMycroft Holmes15-Mar-13 14:20 
QuestionRepeating Field in SSRS report. Pin
Laurence123414-Mar-13 1:44
memberLaurence123414-Mar-13 1:44 
AnswerRe: Repeating Field in SSRS report. Pin
David Mujica14-Mar-13 2:54
memberDavid Mujica14-Mar-13 2:54 
GeneralRe: Repeating Field in SSRS report. Pin
Laurence123414-Mar-13 5:31
memberLaurence123414-Mar-13 5:31 
QuestionPersisted Primary Key? Pin
H JJ13-Mar-13 21:56
memberH JJ13-Mar-13 21:56 
AnswerRe: Persisted Primary Key? Pin
Mycroft Holmes13-Mar-13 22:18
memberMycroft Holmes13-Mar-13 22:18 
GeneralRe: Persisted Primary Key? Pin
H JJ14-Mar-13 0:14
memberH JJ14-Mar-13 0:14 
AnswerRe: Persisted Primary Key? Pin
Eddy Vluggen14-Mar-13 2:20
mveEddy Vluggen14-Mar-13 2:20 
GeneralRe: Persisted Primary Key? Pin
Jörgen Andersson14-Mar-13 8:21
protectorJörgen Andersson14-Mar-13 8:21 
QuestionWant to get data on weekly basis Pin
VishwaKL13-Mar-13 0:07
memberVishwaKL13-Mar-13 0:07 
AnswerRe: Want to get data on weekly basis Pin
Mycroft Holmes13-Mar-13 3:15
memberMycroft Holmes13-Mar-13 3:15 
AnswerRe: Want to get data on weekly basis Pin
Davidduraisamy13-Mar-13 21:44
memberDavidduraisamy13-Mar-13 21:44 
GeneralRe: Want to get data on weekly basis Pin
VishwaKL14-Mar-13 23:16
memberVishwaKL14-Mar-13 23:16 
GeneralRe: Want to get data on weekly basis Pin
Davidduraisamy14-Mar-13 23:23
memberDavidduraisamy14-Mar-13 23:23 

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.