Topics
Started by
Posts
Last post
Greetings, I am trying to fill in NULL values in a column (Advice) with the value from the closest…
7 replies
Hello all. I hope everyone's ok I have this query: SELECT cont, type, month01, month02, month03...…
4 replies
I have two tables in this format below; Table Transfer Id Stage Amount TransactionNumber bnumbe…
5 replies
I create a sql query to create a feed file, my issue is that the file have a header and detail. The…
2 replies
Hi Expert, Have 2 columns where column A which is id having multiple duplicate records this is my i…
3 replies
Hi, I have this SQL fragment SELECT COL1, CASE WHEN Table1.COL2 = 0 then 'ZERO' WHEN Table1.COL2 = …
5 replies
Hi Folks EncryptByKey (Key_GUID('Name_SymKey'), @dex) @dex has 9000 char length error: Msg 8152, …
1 replies
I am having some kind of proprietary database with the file extension of .DSE i would like to impor…
3 replies
Hello everyone, I have a situation where I need to create something most likely like LAG - AVG func…
10 replies
Hi there We have created a database (empty) on Azure called 'Logger_Groups_CI' We then created a us…
5 replies
In my stored procedure, I have something like WHERE W.Warehouse=@WH1 It works well when it is simpl…
6 replies
Hi, this is my Query. create table #emp( sal int) insert into #emp(sal) values (1000),(2000),(3000…
2 replies
Hi all, i've to refactor a database with several tables with around 100.000.000 records each one. E…
15 replies
Hello all I am sorry to bother but I really can't find the solution for this one. I have an account…
5 replies
Hello everyone, I have a situation where I am trying to organize 2 case statement into 1. There are…
4 replies
Viewing 15 topics - 571 through 585 (of 1,784 total)
You must be logged in to create new topics.