Hi,

So you mean that we need to create Table / Process for logging in the Exeution Status of the Procedure.

Is that correct ???

Can you please help me with a partition / File swap concept. please

I just want to clarify, you're looking to setup table partitioning within the schema of the database to multiple filegroups, correct?

> Yes I am trying to Partition my table, here....

You guys are the Best....!

Thanks The issue is resolved....!

Below is the Query Solved the Problem:

declare @string varchar(500)

set @string = '-1 * [ALL_1] + [BAL] - [SAL]'

declare @pos int

declare @piece varchar(500)

declare @EXIS_VALUE VARCHAR(100)

declare @string_new varchar(500)

--Need to tack a delimiter...

declare @string varchar(500)

set @string = '-1 * [ALL_1] + [BAL] - [SAL]'

declare @pos int

declare @piece varchar(500)

declare @EXIS_VALUE VARCHAR(100)

declare @string_new varchar(500)

--Need to tack a delimiter onto the end of the input...

When we get the Following String as In put

-1 * [SAL] - [BON] - [COMM]

need to check for the Data from the Below Table.

Columns:

--------

SAL

COMM

Once you search through the table...

Need to Solve this Query issue ??? 🙁

Thanks all for helping on this: below is procedure which does the Trick

Create procedure USP_TEST

@NAME NVARCHAR(20)

AS

BEGIN

IF object_id(N'tempdb..##TEMP_TEST') is not null

DROP table ##TEMP_TEST;

DECLARE @cols AS NVARCHAR(MAX),

...

Need Small help on the Below Query

Dynamic SQL has Column names which are not part of table, how to handle this to complete the process with out Error.

Ex: SAL =...

Tanks Lowwel, it is perfectly working.

But my problem is that I may not be able to use the Global Temp table.

Can we Have the local temp / Genral table in...

Msg 156, Level 15, State 1, Line 6

Incorrect syntax near the keyword 'INTO'.

🙁

Can you help me with the Exact query.

DECLARE @cols AS NVARCHAR(MAX),

@query AS NVARCHAR(MAX),

@cols2 AS NVARCHAR(MAX);

SET @cols = STUFF((SELECT distinct ',' + QUOTENAME(c.PAYMENT_TYPE)

...

I will try to Explain you the Scenario and need Suggestion:

1. I have te table which is Similar to TEST_SRC for which will tipically has 4000 to 5000 Payment types,...

Yes I understand that, but need of time I need to complete it as per the Request.