Threads de Naomi N
-
1 Votos
SSMS 18.4 scripting error?
Hi, In Azure DB (SSMS 18.4) I tried to script first the Key and then the Index using right click on the Key (Index), then 'DROP and CREATE' object option and in both cases I ...Respondido | 13 Respostas | 64 Exibições | Created by Naomi N - há 8 horas 34 minutos | última resposta por pituach - há 1 hora 30 minutos
-
0 Votos
Alphabetical data update
Helllo, Is there way I can update Sales rep data for customer by Alphabetical ? For example. Customers between A to Z has a different Sales ...Pergunta | 2 Respostas | 54 Exibições | Created by JinalContractor - há 11 horas 42 minutos | última resposta por Rachel_Wang - há 1 hora 52 minutos -
0 Votos
Save Query Results To HTML File
0 Group By SubString([Route],1,1),[Pick_Area] PaulPergunta | 2 Respostas | 34 Exibições | Created by Paul 2 U - há 16 horas 55 minutos | última resposta por Dawn Young - há 2 horas 26 minutos -
0 Votos
SSIS 2012
I am not familiar with .net language. I am trying to build a package to transfer data from an XML file. When I create HTTP connection manager and followed the instruction given in the ...Pergunta | 2 Respostas | 38 Exibições | Created by Panchanadam - há 13 horas 54 minutos | última resposta por Mona Lv - há 2 horas 44 minutos -
0 Votos
scripting database objects
Hi , i have a local instance of 2017. Today i spent a lot of time scripting a subset of a 2014 instance (2 dbs) so i could run the created objects (tables, indexes, syns, user defined data ...Pergunta | 4 Respostas | 39 Exibições | Created by db042190 - há 8 horas 8 minutos | última resposta por pituach - há 2 horas 48 minutos -
0 Votos
T-SQL to update top 1 row of each client.
Hi, I have a table with below column(id(int),clientid(int),contactid(int),usertype(int),address(varchar)), clientid and contactid together is unique key. I want ...Resposta Proposta | 5 Respostas | 283 Exibições | Created by SA260884 - há 13 horas 9 minutos | última resposta por Lily Lii - há 3 horas 4 minutos -
0 Votos
are the newer string functions as efficient as using clr to shred strings
hi we are migrating to 2019 enterprise from 2014 and i was shocked to see 2 clr assemblies, one with what is probably a regular string splitting function and the other with a long string splitting ...Pergunta | 21 Respostas | 1011 Exibições | Created by db042190 - quarta-feira, 1 de abril de 2020 12:50 | última resposta por Erland Sommarskog - há 7 horas 5 minutos -
0 Votos
405 method not allowed(postman)
id==e.id)); entities.SaveChanges(); ...Resposta Proposta | 7 Respostas | 189 Exibições | Created by Sai Pranav - sábado, 28 de março de 2020 15:14 | última resposta por DA924x - há 8 horas 53 minutos -
0 Votos
Trying to figure out a pattern so I can utilize an index if possible
Hi everybody, I have this expression in UPDATE command set flag = 1 where cast(left(charColumn,3) as int) not between 201 and 989; It works but ...Pergunta | 1 Respostas | 48 Exibições | Created by Naomi N - há 11 horas 29 minutos | última resposta por Naomi N - há 11 horas 10 minutos -
0 Votos
Adding query parameter to NpgsqlCommand results in Exception
The project I'm working on is a WinForms project written in C#, connecting to a PostgreSQL database using the Npgsql Framework. I'm binding a DataTable to a DGV with this ...Pergunta | 4 Respostas | 129 Exibições | Created by Mark Yorkovich - há 14 horas 7 minutos | última resposta por Kareninstructor - há 12 horas 15 minutos -
0 Votos
How to use ISNULL in my dynamic pivot
see my pivot which is working but [Values] field is some time null. so i want to use isnull([Values],'') and show empty string when [Values] is null -- ...Pergunta | 1 Respostas | 43 Exibições | Created by Sudip_inn - há 13 horas 19 minutos | última resposta por Naomi N - há 13 horas 9 minutos -
0 Votos
Facing some issue for my Dynamic Pivot
see my code DECLARE @Columns as VARCHAR(MAX) DECLARE @SQL as VARCHAR(MAX) DECLARE @Ticker as VARCHAR(10) SET @Ticker='TER' SELECT ...Pergunta | 1 Respostas | 41 Exibições | Created by Sudip_inn - há 13 horas 22 minutos | última resposta por Naomi N - há 13 horas 13 minutos -
0 Votos
SELECT * Result into a string ?
Hi ! This is for an attempt at a trigger script that will be on many *different* tables, thus I do not know number of columns, their names or their data types. That is why I ...Resposta Proposta | 13 Respostas | 324 Exibições | Created by Softscand - quarta-feira, 1 de abril de 2020 09:49 | última resposta por Naomi N - há 15 horas 0 minutos -
1 Votos
Data would be truncated and NTEXT question
I have a table with a few columns. I try and change the data in a integer column and receive the error the data would be truncated. 1. How could i find out which column its ...Respondido | 6 Respostas | 78 Exibições | Created by Pure Deal - segunda-feira, 6 de abril de 2020 13:03 | última resposta por Naomi N - há 15 horas 8 minutos -
2 Votos
alternatives to NOT IN filter
Hi All, I have a query that extracts sales orders (SO) that do not have any Invoices (INV). Sales order is indirectly linked to invoices through delivery (DEL). So my current ...Pergunta | 5 Respostas | 89 Exibições | Created by sonny2727 - segunda-feira, 6 de abril de 2020 20:23 | última resposta por Naomi N - há 15 horas 14 minutos -
0 Votos
Sum 2 weeks of sales starting at first sale that is on or after specific date
I wrote the following query which pulls sales units for the first 2 weeks the inventory has been in stock. My company uses a SQL Server database. I want it to ...Resposta Proposta | 17 Respostas | 410 Exibições | Created by GigaFluxx - terça-feira, 31 de março de 2020 16:09 | última resposta por Naomi N - há 15 horas 20 minutos -
0 Votos
Rolling Date within Where Clause
=2017 Any idea how I can amend this please to say where start_date (rolling 36 months) start_date ...Pergunta | 3 Respostas | 181 Exibições | Created by Bone_12 - quinta-feira, 2 de abril de 2020 15:28 | última resposta por yuxi666 - há 21 horas 44 minutos -
0 Votos
Efficient way of Delete from Huge table
Dear All, we have a purge job which is causing low PLE and huge logical reads , this job is deleting data older than 4years on daily basis from a huge table (500million ...Pergunta | 2 Respostas | 101 Exibições | Created by Lakshmi Kiran Reddy Vennapusa - segunda-feira, 6 de abril de 2020 13:40 | última resposta por Rachel_Wang - terça-feira, 7 de abril de 2020 03:37 -
0 Votos
call stored procedure but use parameter to insert data like object
Hi All. I'm new in C#. I have post where some people help me to solve problem how to call stored procedure and save entered data. I would like to modify the code and ...Resposta Proposta | 16 Respostas | 306 Exibições | Created by zleug - quarta-feira, 1 de abril de 2020 14:37 | última resposta por Naomi N - segunda-feira, 6 de abril de 2020 19:33 -
4 Votos
Is there a way to continue where we left?
Hi everybody, I created a package to load data from 3 txt files (two of them are huge and cannot be opened by any editors). I was running the package and it loaded 18 mln rows out ...Respondido | 11 Respostas | 328 Exibições | Created by Naomi N - domingo, 22 de março de 2020 19:42 | última resposta por Yitzhak Khabinsky - segunda-feira, 6 de abril de 2020 19:24 - Items 1 to 20 of 22257 próximo ›
