|
|
-
prince Question Received 9 Months ago through ASK | 1 Point
Kindly refer the below link, It is **T-Sql Server 2005** question. for adding dynamic columns in a temporary table. Here 2 temp tables are there as tabl1 and table2 and result is in "output table". here my rows are getting converted in columns. Using plain...
|
|
|
|
|
-
santosh Question Received 1 Years ago through ASK | 1 Point
ALTER proc [dbo].[getTriggerNamesbyId]
@id int,
@returnval nvarchar(500) output
as
begin
set @returnval= (select TriggerPointDescription from ClaimTriggerInfo where TriggerPointID=@id )
return (@returnval)
end
Above is my stored procedure but when ...
|
-
Satya Jayanty (@sqlmaster) Commented 1 Years ago through Ask | 10 Points
Hi Nitin
Somehow this question appeared in my profile just 2 days ago... not sure if you already got a response or not. Otherwise I will be more than happy to explain further....
|
-
Satya Jayanty (@sqlmaster) Replied 1 Years ago through ASK | 1 Point
Hi Nitin
Somehow this question appeared in my profile just 2 days ago... not sure if you already got a response or not. Otherwise I will be more than happy to explain further....
|
0
·
0% ·
0
|
|
-
Satya Jayanty (@sqlmaster) Replied 1 Years ago through ASK | 1 Point
Hi
I sent you direct response on this Question, hope it cleared your doubts....
|
0
·
0% ·
0
|
|
-
Satya Jayanty (@sqlmaster) Commented 1 Years ago through Ask | 10 Points
Hi
I sent you direct response on this Question, hope it cleared your doubts....
|
-
sirknth Question Received 1 Years ago through ASK | 1 Point
table name: test
below are the columns and records
Terminal VIN Loadnum FOH ROH Date
60 A 1 38 48 20120103
60 B 1 38 48 20120103
60 ...
|
-
nitinjaine Question Received 1 Years ago through ASK | 1 Point
Hello Mate,
I want to Create A store Procedure which can work for underneath:
Q. User pass either an single word string or a long string seprated by commas, procedure will take that string and spilit the whole string from commas then it wil...
|