Topics
Started by
Posts
Last post
I have three Tables which I want to Join . I wrote down the Inner Join Query , But It is giving me …
2 replies
I have two tables named order and order_line...orderline is related to order by orderid.Calculates …
4 replies
"EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';” “EXECUTE IMMEDIATE 'ALTER SESSION DISABLE …
1 replies
Hi,Pasted at the very bottom of this post is the T-SQL I wrote to unpivot, and format, some da…
2 replies
Hi, I have a variable that shows the date as month and year only. It has data format like 2018-11. …
9 replies
I have a SP as follows:CREATE PROCEDURE dbo.MyProcedure @StartDate Datetime, @EndDate Datetime, @Re…
8 replies
I am trying to find all stored procedures called by jobs. I have modified SELECT DISTINCT SPROC=SPE…
8 replies
Hello SQL guru's i have an order by statement like so: ORDER BYSuppliers.Descr,ItemGroups.Descr,Ite…
7 replies
A store sells products. Products have attributes grouped into types. (Ex. Product 'shirt' has size …
3 replies
I am using SQL Datawarehouse for my database Find the V,T,C in sequence for a given detail group by…
1 replies
Hi can anyone offer input on the below code. Assuming the below SP is accessed via dapper.net (dapp…
4 replies
Hi, I have an (simplified) application with the roles 'roleAdmin' and 'roleUser'. Members of the ro…
3 replies
I am curious to know, if there is any way to remove zeroes from numeric column without convert…
14 replies
Hi All, I would like to calculate the work week starting from the Sunday of the week in which …
10 replies
In the below given schema and data, we need to find the time waited for each vehicle and number of …
4 replies
Viewing 15 topics - 1,006 through 1,020 (of 1,544 total)
You must be logged in to create new topics.