|
|
-
Ramireddy Commented 2 Months ago through Ask | 10 Points
Hi Balakrishna,
Try this URL below. URL that jacob gave has an extra space character in it.
http://media.beyondrelational.com/images/...
|
-
Ramireddy Commented 8 Months ago through Ask | 10 Points
Hi Niya,
Before using a variable in a expression in right hand side, you should first assign a value.
Here you are using str1 and str2, before you are assigning the values to str1 and str2.
you need to initialize those variables to some value ...
|
-
Ramireddy Commented 9 Months ago through Ask | 10 Points
In the execution plan, you can see "Index Scan" and "Index Seek" iterators, when you see the properties of that iterator, you can see index name....
|
-
Ramireddy Commented 9 Months ago through Ask | 10 Points
Hi Suyambu,
As you are using dynamic template in repeater, its controls are not persisted between postbacks. One suggestion is remove that "If Not Page.IsPostBack" condition. In Page_load directly call FillRepeater() event.Then when you export the ex...
|
-
Ramireddy Commented 9 Months ago through Ask | 10 Points
Duplicate post. Question is answered [here][1]
[1]: http://beyondrelational.com/modules/3/ask/questions/16101/sql-query.aspx...
|
-
Ramireddy Commented 9 Months ago through Ask | 10 Points
Hi Suyambu,
Can you show your entire code in code-behind page. Probably in post back, page might be refreshing and repeater might be re-binding. Can you confirm that, in page load event, you are checking the condition.
If(!IsPostBack)
...
|
-
Ramireddy Commented 9 Months ago through Ask | 10 Points
Duplicate of this thread.
It's answered [here][1]
[1]: http://beyondrelational.com/modules/3/ask/questions/16096/t-sql-server-2005-question-for-adding-dynamic-columns-in-a-temporary-table.aspx...
|
-
Ramireddy Replied 9 Months ago through ASK | 1 Point
Hi Prince,
To have double pivot(pivot on 2 columns), you need to make 2 individual pivot queries and join together.
CREATE TABLE #table1
(
ID INT IDENTITY(1,1),
Name VARCHAR(100)
)
INSERT INTO #table1 VALUES ('John')...
![]()
|
0
·
0% ·
0
|
|
-
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 p...
|
-
Ramireddy Replied 12 Months ago through ASK | 1 Point
If your problem is solved, please mark the question as solved....
![]()
|
0
·
0% ·
0
|
|