Viewing 15 posts - 1 through 15 (of 17 total)
If a user knows the right login and the right location to use, they can connect with any tool at all.
yeah, that why i need for help. With simple...
October 13, 2020 at 2:43 pm
hello, can you reconmend some way to solved that ?
If i split proc, that is nightmare about number of proc and manage them, one proc one action, usally a table...
October 11, 2020 at 2:05 am
hello, it's relation to myoriginal question here, because i have some test with stuff query in sql 2008.
CREATE PROCEDURE test@kind NVARCHAR(10), @id NVARCHAR(10),@startday date, @endday dateASBEGINSET NOCOUNT...
October 10, 2020 at 2:06 pm
hello guys, is it ok if i write many jobs in a storeprocedure ? Like this:
ALTER PROCEDURE test@kind NVARCHAR(10)ASBEGINSET NOCOUNT ON;IF @kind = '1'BEGINSELECT * FROM dbo.tbl1ENDIF...
October 10, 2020 at 2:18 am
hello, my storeproc, need to change for 2017 ?
SET XACT_ABORT ONBEGIN TRANBEGIN TRY ...
October 8, 2020 at 1:32 am
hello, guys, i have some test with string_agg in sqlserver2017. It's seem to be best solution ever. With xml path quey run 30s, string_agg run 2s, oh my god. Perfect.
October 7, 2020 at 2:46 am
yes, i decide pivot in sql query. Now, problem is dynamic query as my post #3790843. The infomation in your website is very detailed
, but it's seen very complicated for...
September 30, 2020 at 1:34 am
thank erland, many loop in code, it's not good for performance, and i need write some code use dictonary and split to get finally result.
I think i dont need to...
September 29, 2020 at 3:38 pm
hello, if you dont mind, can you recommend some way to do it client side, i used c#.net.
September 29, 2020 at 1:39 am
hello, if you have better way or query please tell me. And I worry about sql injection with EXECUTE(@sql).
September 25, 2020 at 6:53 am
Hello guys, can i custom number of column in pivot that is not need to be add permission "select" for user.
I have code:
DECLARE @column NVARCHAR(MAX)SELECT @column =...
September 25, 2020 at 1:49 am
With Mr.Brian code, run on temp data is so good. But i run code on real database table which have 100k record, it's bad horribly performace, too slow. Please...
September 19, 2020 at 8:31 am
thanks Erland and Mr.Brian, i run yours code with display estimated execution plan, Erland code with 98%, Mr.Brian with 2%. Why it so different performace.
Anyway, both code is give me...
September 18, 2020 at 3:32 am
yes, next question is #3763756
add column price in table1, column kind in table2.
June 17, 2020 at 3:37 am
how to get result like yellow
June 17, 2020 at 2:24 am