Skip to main content
53,635 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
94 views

I have a specific stored procedure that executes in a SQL Server in about 0.250 seconds, when executed from SQL Server Management Studio, although it takes half a minute to display the resulting ...
Peter's user avatar
  • 1
0 votes
0 answers
45 views

I have an object BankingProvider with a many-to-one relation to a collection of objects CasinoBankingProviders which, in turn, relate to a Casino object. So it is an intersect table between a ...
Adam Hey's user avatar
  • 1,731
1 vote
2 answers
82 views

I have a set of database tables in Microsoft SQL Server "in the example flattened to keep this example easy" that is a bunch of time clock records for employees that looks like this. Call ...
John Wesley Gordon's user avatar
  • 920
-1 votes
1 answer
150 views

I have the below text in a column in a SQL Server table. "55-9988, Version 1.0 dated 07/20/2009 3684 for 66-0022 IB from Microsoft , for Monovalent A/king Influenza Subvirion Vaccine, Version 1.0 ...
Nebula Tech's user avatar
  • 11
5 votes
1 answer
103 views

I have a procedure in SQL Server that returns data. I use this in VB6, but in SQL returns data but in VB6 it doesn't, I lose the data. ALTER PROCEDURE [dbo].[SP_L_UIF_Novedades] @bigint_dni bigint AS ...
Franqo Balsamo's user avatar
  • 223
1 vote
4 answers
173 views

I have two tables in SQL Server: Product: contains product details (ID, ProductName, ...). ProductID ProductName 1 Product A 2 Product B ProductEan: contains multiple code for each product (ID, ...
StacQ96's user avatar
  • 39
2 votes
1 answer
97 views

Here are 2 examples with 2 indexes each, assuming all of these indexes have high usage should they be merged or kept separate? My first thought is only example #2 should have its indexes merged. ...
Joe Defill's user avatar
  • 531
1 vote
2 answers
110 views

I have a question about SQL Server 2008: how to concatenate with comma (,) for multiple columns with orders of columns? Table timeschedule: Id | Name | days |daysfrequency|scheduletime ---+-------+---...
Harinanth's user avatar
  • 23
0 votes
2 answers
159 views

Currently I'm doing a simple table copy using a linked server: DELETE FROM [LocalTable] INSERT INTO [LocalTable] SELECT * FROM [LinkedServer].[LinkedDB].[dbo].[RemoteTable] It currently takes 1 ...
Joe Defill's user avatar
  • 531
0 votes
1 answer
78 views

sample data/table is in the below SQL playground. https://sqlfiddle.com/sql-server/online-compiler?id=ecc05c23-cfa4-4546-9334-5286b88eb2a3 screenshot of the table below enter image description here ...
sabu's user avatar
  • 91
-1 votes
1 answer
64 views

I have an RShiny app connected to a SQL Server database that lets me update said database. I can update the database in both SQL & RShiny and display these updates in both UI's successfully. When ...
SteveS's user avatar
  • 67
0 votes
2 answers
191 views

The application is coded in .NET using ASP.NET webforms. I am trying to change the Priority code of several hundred order numbers. The new code to be assigned is what the user selects in the Drop down ...
kvj's user avatar
  • 27
0 votes
0 answers
1k views

I´m trying to run a FastAPI connected to SQL Server on a Docker container, but I´m getting this error when I execute the query. Error executing: (pyodbc.OperationalError) ('08001', '[08001] [Microsoft]...
Julian Toujas's user avatar
  • 1
1 vote
0 answers
110 views

I can't do anything with legacy database, can't migrate or update, I have to read some data from it. Personally, I'd love to migrate, but I can't. Is there any way to connect Laravel 11 on PHP 8.2 ...
Rustam Anvarov's user avatar
  • 11
-1 votes
1 answer
80 views

I am trying to add multiple values at once in existing table using query That column with NULL values "County" I want it populated with countries like Kenya, Uganda, Cameroon, Ghana. I have ...
Thomas Magono's user avatar
  • 3

15 30 50 per page
1
2 3 4 5
…
3576