Dear SQL users,
I have a need to refresh tables from Source to Target. there is no particular 'ke…
1 hour, 19 minutes ago
By: Phil Parkin
I have two columns (Col3 and Col4). I need a SUM of these two columns, but only when …
8 hours, 5 minutes ago
I have the following Episode table example:
Where DischDate = "2020-02-20" means - client has…
19 hours, 52 minutes ago
What are the things you consider when you create a new table and define data types of each columns?…
1 day, 10 hours ago
By: MVDBA (Mike Vessey)
How can i get the counts of how many records updated and how many inserted with Merge
3 days, 17 hours ago
I have two tables namely Vendors & Visits.
Create Table Vendor (VendorId BIGINT IDENTITY(1,1) N…
3 days, 19 hours ago
Scenario 1 works just fine
DECLARE @XMLT XML = '<Header>
4 days, 4 hours ago
By: Mr. Brian Gale
Currently i am processing records in SQL Server itself.
Any recommended in-memory database, whi…
4 days, 10 hours ago
By: Grant Fritchey
I like puzzles, I like T-SQL coding, I like to show off :-), so why not combine these.
5 days, 11 hours ago
I'm trying to improve a VIEW which is made of several UNION ALLs, something like this:
5 days, 14 hours ago
I want to copy the .xml code from an existing SSIS Package to use later.
I go to the SSIS…
6 days, 2 hours ago
By: Jeffrey Williams 3188
In the following table, there can be multiple records per order (indicated by OrderID). There is …
6 days, 3 hours ago
By: Matt Miller (4)
Below is the create table script and the insert into statement. …
6 days, 23 hours ago
Error on executing rename statement in a table. Not able to debug this. Please help.
1 week ago
Currently using SQL Stored Procedure to write a script
joining multiple to form a data and insert i…
Viewing 15 topics - 1 through 15 (of 994 total)
You must be logged in to create new topics.