select xso.packing_no ,max(xso.seller_id) from dbo.table as xso with(nolock) where xso.packing_no in ( select distinct [value] from string_split(@packing_no, ',') ) group by xso.packing_no -- 영문순으로 정렬 order by case when max(xso.seller_id) like '[a-za-z]%' then 0 else 1 end , max(xso.seller_id)
Utils.IsNumeric = function(value) { var ValidChars = "-.,0123456789"; var IsNumber = true; var Char; if (typeof (value) == "undefined") return false; if (typeof (value) != "number" && value == "") return false; for (i = 0; i < value.length && IsNumber == true; i++) { Char = value.charAt(i); if (ValidChars.indexOf(Char) == -1) { IsNumber = false; } } return IsNumber; }; //자연수값 Utils.IsNumber = fu..
A.swift @State private var currentIndex: Int = 0 B(currentIndex: self.$currentIndex) B.swift @Binding var currentIndex: Int init(currentIndex: Binding) { _currentIndex = currentIndex } TabView(selection: self.$currentIndex) { ForEach(self.wordEntityExtend.indices, id: \.self) { index in VStack { Text("\(self.currentIndex)") } } } .tabViewStyle(.page(indexDisplayMode: .never))
DataTable filteredDT = dt.Clone(); try { var queryGroupByPacking = ( from virtualTable in dt.AsEnumerable() group virtualTable by new { packing_no = virtualTable.Field("packing_no") } into newTable select new { packing_no = newTable.Key.packing_no }).Take(parcel_count); foreach (var packing in queryGroupByPacking) { foreach (var item in dt.Select(string.Format("{0} = '{1}'", "packing_no", packin..
confirmDelivery: async function () { var selectedPackingNo = []; var failure = []; const distinctPackingNo = Array.from(new Set(selectedPackingNo)); for (const value of distinctPackingNo) { if (await Page.confirmDeliverySync(value) == "Failure") { failure.push(value); } } if (failure.length > 0) { UIUtil.alert(String.format("There are some delivery confirm error error packing[{0}]", failure.toSt..
세로행 -> 가로행으로 변경 CREATE TABLE Sales ( Salesperson VARCHAR(50), Region VARCHAR(50), Sales INT ); INSERT INTO Sales (Salesperson, Region, Sales) VALUES ('John', 'North', 100), ('John', 'South', 150), ('John', 'East', 75), ('Mary', 'North', 200), ('Mary', 'South', 50), ('Mary', 'East', 125); SELECT Salesperson, [North], [South], [East] FROM ( SELECT Salesperson, Region, Sales FROM Sales ) AS SourceT..
let isChecked = $('#takenBefore').prop('checked'); console.log(isChecked); // true (if checked at the time) is() vs prop()? So, what's the difference between is() and prop() in this context? Both methods appear to work in much the same way from our perspective. So, what's the difference? is() has a bit more overhead processing and parsing than prop(). Even considering the fact that prop() doesn'..
- Total
- Today
- Yesterday
- system.io
- nl2br
- System.Diagnostics
- 문자 자르기
- 상품 등록
- FileUpload
- In App Purchase
- App Store
- Task
- 공백제거
- trim
- .submit()
- html tag
- 명령어
- await
- 앱 스토어
- MainActor
- 제품 등록
- 진수 변환
- 특정 문자를 기준으로 자르기
- mssql
- async
- 아이폰
- hyper-v
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 |