Topics
Started by
Posts
Last post
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
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
I need to get the counts for the number of records that meet specific criteria. Here's a scenario …
7 replies
Hi, I'm trying to figure out how to get the nearest date from table2 using the date from table1. He…
13 replies
I have a table (TableCOunts) that stores the name of the tables and the row counts. and the individ…
2 replies
Hallo, ich lade mir einen Katalog (ca. 800.000 Datensätze) aus einer anderen, entfernten DB (über V…
5 replies
I have a query that I run daily to pull data from a table but I only wish to take out the rows of d…
10 replies
Hi Friends, One of my colleague asked me a wired scenerio that the output he is looking f…
2 replies
Viewing 15 topics - 4,966 through 4,980 (of 10,638 total)
You must be logged in to create new topics.