Topics
Started by
Posts
Last post
Hi Guys, How do i group the below code so it gives e a total duration for each person for each day.…
1 replies
MOTEL (motelID, motelName, town) ROOM (roomID, motelNo, type, cost) BOOKING (motelNo, guestID, date…
3 replies
Hello everybody. I am trying to insert some data in table Production.WorkOrder. There are some da…
7 replies
Is there a better way to extract to 3 single columns from one full name column: Lastname, FirstName…
12 replies
I've been tasked with turning this SQL into a stored procedure to populate an Aggregation table (on…
5 replies
Hi there I would like to cast a NVARCHAR(MAX) variable string to an XML variable as follows: declar…
5 replies
We have a dev that used to use SSMS in order to debug code that was related to SQL. I guess MS has…
5 replies
Hi All, I'm using Visual Studio 2019 to get data from a Oracle Database and transfer it to a SQL 20…
2 replies
I've got a table with LOTS of data. It's a tree-structure (using hierarcyId datatype) and I want a …
1 replies
Hi there I have a table for which archiving functionality is required. Now I have thought of writin…
2 replies
Hi all I'm new to sql server 2019, so any help would be greatly appreciated. I'm trying to enter va…
6 replies
Hi all! I want to create a stored procedure that returns a result based on the value of some DateTi…
6 replies
Hi All, Looking for answer on what do I expect to happen on very first day for PL SQL job role, giv…
6 replies
Newbie to this .. will learn .. am motivated. When I do a script for creating a new database I get …
8 replies
I'm hoping someone has seen this before because I've been doing this for years and never had this p…
2 replies
Viewing 15 topics - 1,336 through 1,350 (of 1,791 total)
You must be logged in to create new topics.