Topics
Started by
Posts
Last post
I have a simple table where I need to exclude any dates that weren't within 3 days of the max date.…
7 replies
When trying to create / save / execute a single .sql file containing multiple DDL operations, such …
5 replies
Morning Guys, The following query is complaining about having no join predicate on a nested loop ED…
12 replies
The question is: What is @@trancount after this SP is executed? I don't understand why the answer…
4 replies
Hello community, I have a little challenge to accomplish, but i need your help. i have a varchar fi…
13 replies
Hello folks, I am trying to maintain SCD type 2 based on merge statement and here are my cases and …
18 replies
Dear All, I have a win form c# 4.5 app which connects to SQL server 2016 DB, most of the functions …
4 replies
Here is the scenario: A school send messages to students and message templates are saved with varia…
2 replies
Hi, I have to compare XML contents in column A in Table A in Database A with XML contents in column…
6 replies
Can you help? I have a table like below. ID SrNum Status Time 1 1 …
2 replies
Users want a value spread across multiple columns... approximately 110 columns by month. So…
6 replies
Hello everyone Here we go with this topic. I have some confusion about why we get 2 different execu…
4 replies
CREATE VIEW [dbo].[vwstudent] AS DECLARE @Date datetime2 SELECT @Date = value FROM dbo.configuraito…
5 replies
Hey all, I'm trying to update table rows when a row's "myCount" value is less than other rows withi…
6 replies
I would be grateful if someone could help. I have a simple table in SQL 2016 CREATE TABLE [dbo].[Me…
4 replies
Viewing 15 topics - 1,246 through 1,260 (of 3,091 total)
You must be logged in to create new topics.