Topics
Started by
Posts
Last post
Hello Community, I have the following logic: Find customers who didn't place orders from 2019-02-01…
14 replies
At work I am working with one of our contractors. She was trying to add a new record to the one of …
2 replies
I inherited a manually produced report where I take the results of a TSQL query, and save it to a s…
1 replies
Trying to get a query to work on a couple of joined tables and I'm having some issues with it. I es…
6 replies
This query requires ActualTotal to be ordered with largest value top however as you can see from th…
2 replies
SQL Server 2016 cursor and query: select * from table1 where col1 = '1' and col2 = '00001' and col3…
8 replies
When creating a simple query to compute a running sum/total for each row using a window function [S…
4 replies
Hi, running this declare @code VARCHAR( 50 ) = '748.019876'; select [code1] = @code, [code2] = CONV…
6 replies
Hi all, If you had the string "CREATE VIEW <something> AS SELECT * FROM <sometable>;" H…
11 replies
Querying sys.dm_db_partition_stats for a table and getting the following items back, assuming I wan…
11 replies
Hi All, I have a need to replace, in various views, the SELECT statement that produces the results …
2 replies
Dear Experts I have a table that accumulates daily stats, defined so: CREATE TABLE [dbo].[Stats2] …
3 replies
Ahoi, i have a set of 7 int columns in a table. My goal is im trying to create a unique key/integer…
26 replies
We have a table with the following values for some column: Column1 ------- 123 71 1844 …
5 replies
Hi, I want to list al tables that contains only _ar_ in the name (archive tables) I have tried the …
2 replies
Viewing 15 topics - 766 through 780 (of 3,091 total)
You must be logged in to create new topics.