|
|
-
Alpesh Patel Liked 5 Months ago through Just Learned | 1 Point
Today I came across the problem.
When One my SP has Insert Into Table Exec SP_Name and doing same another SP using the Main SP.
The moment I am getting the error "An INSERT EXEC statement cannot be nested."
To resolve the Issue
Do the steps.
**...
|
-
Alpesh Patel Learned 5 Months ago through Just Learned | 1 Point
Today I came across the problem.
When One my SP has Insert Into Table Exec SP_Name and doing same another SP using the Main SP.
The moment I am getting the error "An INSERT EXEC statement cannot be nested."
To resolve the Issue
Do the steps.
**...
|
-
Alpesh Patel Posted 5 Months ago through Just Learned | 5 Points
Today I came across the problem.
When One my SP has Insert Into Table Exec SP_Name and doing same another SP using the Main SP.
The moment I am getting the error "An INSERT EXEC statement cannot be nested."
To resolve the Issue
Do the steps.
**To ...
|
-
Alpesh Patel Learned 5 Months ago through Just Learned | 1 Point
The trick is to append `.0e0` to the string and if it returns 1, the value is a whole number (no decimal fractions).
DECLARE @val VARCHAR(100)
SELECT @val = 'a'
SELECT ISNUMERIC(@val + '.0e0')
-- Returns 0
SELECT @val = '25'
SELECT ISNUMERI...
|
-
Alpesh Patel Liked 5 Months ago through Just Learned | 1 Point
The trick is to append `.0e0` to the string and if it returns 1, the value is a whole number (no decimal fractions).
DECLARE @val VARCHAR(100)
SELECT @val = 'a'
SELECT ISNUMERIC(@val + '.0e0')
-- Returns 0
SELECT @val = '25'
SELECT ISNUMERI...
|
-
Alpesh Patel Commented 5 Months ago through Just Learned | 1 Point
You can not view over there. You can Include in existing or new report using Report Builder 3.0...
|
-
Alpesh Patel Liked 6 Months ago through Just Learned | 1 Point
SQL Server 2008 R2 has new feature to Deploy Report parts.
i.e You report has Table, Chart, Image etc then You can Deploy there report Whole and in parts as well.
To do that Go to Menu Report-> Publish Report Parts (Select The part you want to Dep...
|
-
Alpesh Patel Learned 6 Months ago through Just Learned | 1 Point
SQL Server 2008 R2 has new feature to Deploy Report parts.
i.e You report has Table, Chart, Image etc then You can Deploy there report Whole and in parts as well.
To do that Go to Menu Report-> Publish Report Parts (Select The part you want to Dep...
|
-
Alpesh Patel Posted 6 Months ago through Just Learned | 5 Points
SQL Server 2008 R2 has new feature to Deploy Report parts.
i.e You report has Table, Chart, Image etc then You can Deploy there report Whole and in parts as well.
To do that Go to Menu Report-> Publish Report Parts (Select The part you want to Deploy...
|
-
Alpesh Patel Learned 6 Months ago through Just Learned | 1 Point
Synonyms word says all. To hide the actual name or object from the user.
Using this feature you can hide the linked server objects and directly use it in you database.
To do that follow the steps
1. Create link server.
2. Create synonums and provi...
|