Hello Sir,

I will improve my communication

Hello Eirikur Eiriksson,

Why no string as follow?

AA11

AA11,CL

.................

......................

.............................

And so on?

Yes Sir. But please make it...

My table and data as following,

USE [SPKU_DB_KR]

GO

/****** Object: Table [dbo].[Kumpulan_Wang_OUTPUT] Script Date: 20/8/2016 3:58:25 PM ******/

DROP TABLE [dbo].[Kumpulan_Wang_OUTPUT]

GO

/****** Object: Table [dbo].[Kumpulan_Wang] Script...

Hello Guys,

Actually, I want computer to create Dynamic Parameter when User Select All Kumpulan_Wang(kwang_code). Without computer program, I have to write Dynamic Parameter by myself. The sample of parameter within...

Hello,

This is fn_split

CREATE FUNCTION [dbo].[fn_Split](@text varchar(8000), @delimiter varchar(20) = ' ')

RETURNS @Strings TABLE

(

position int IDENTITY PRIMARY KEY,

value varchar(8000)

)

AS

BEGIN

DECLARE

It's works. Thank you Sir

Owh. Ok. Just want to audit my SQL with yours.

Thank you Sir

Hello,

This is the table design, and set of data

CREATE TABLE [dbo].[tmpaccthist_2013_2014_Test2](

[cmpy_code] [nvarchar](50) NULL,

[acct_code] [nvarchar](50) NULL,

[chart_code] [nvarchar](5) NULL,

[pusat_kos] [nvarchar](10) NULL,

[year_num] [int] NULL,

[period_num] [int] NULL,

[open_amt] [decimal](18, 2) NULL,

CONSTRAINT [tmpaccthist_2013_2014_Test2_UQ1] UNIQUE NONCLUSTERED...

Owh Sorry. Will do the correction

Tq to all

sgmunson (11/18/2015)

---

Ummm... answering your questions requires understanding exactly what such a dynamic query is supposed to accomplish, and I don't see that stated anywhere in your post. Also,...

Ok Sir. Will try to create more excellent story telling and what to achieve

Sorry for inconvenience

Hello Sir,

Your guidance is my inspiration

Update test_Chart_Code SET group_chart_code_1 = chart_code / 100 * 100

It's work. Thanks