Topics
Started by
Posts
Last post
Team, I have a set of data for perticular day.Plesae help me in writing a sql query to get the av…
2 replies
Hi All I have a data warehousing scenario related to Updates and SCD. In our ETL procedure, we cur…
2 replies
I received some great suggestions, but didn't get quite what I wanted mainly because I didn't provi…
1 replies
SELECT DISTINCT RepairSheetH.RepairSheetNr, Vehicle.unitnr, Vehicle.groupid, Vehicle.brandId, Veh…
14 replies
I'm working on a dynamic SQL builder and came across the following by accident. -- Some backgrou…
4 replies
Hello comunity I have build this current CTE query to have a drilldown information to know from the…
1 replies
I have a table which has id and statement columns, statement column contains statement like insert …
1 replies
Ok, I have a question. I need to select data from a table where a specific value appears for a use…
7 replies
SELECT YEAR(OrderDate) ASOrderYear, SUM(CASE WHEN DATENAME(Q,OrderDate) =1 THEN TotalDue END)AS Q1…
11 replies
I have a list of Statuses A B C D E F G H I and list of Phases 1 2 3 4 5 A,B fall under 1 C,D,E fal…
15 replies
I've got a peice of dynamic sql which passes in the Server and Database name to create a fully qual…
3 replies
Hello, Here is my situation; I have a stored procedure that will be executed 'ad-hoc' as a report. …
3 replies
Hi, I've a database with 635 SPs. 495 have QUOTED_IDENTIFIER OFF and 140 have ON. Is there any way …
1 replies
There is a setting on my database that causes the followwing to error out: CREATE TABLE [dbo].[AG_B…
3 replies
My requeirement is Am having a batch_id in table1, based on batch_id having 10 records in table2. …
2 replies
Viewing 15 topics - 4,966 through 4,980 (of 10,647 total)
You must be logged in to create new topics.