Topics
Started by
Posts
Last post
Hello, I have this sample data below: CREATE TABLE MyTable ([Address] varchar(100), [MD] VARCHAR(10…
11 replies
Hi,Please refer to the attached image for your kind perusal.For example the product in level …
3 replies
I have the SQL Service on Automatic restart on a machine and the agent is restarted only on instanc…
4 replies
I'm guessing this is possible, but just checking. We have an app that creates and deletes tables(no…
4 replies
I have eight dates and these are in ascending order. But all or some of them can be null.Is there a…
10 replies
Hi Guru's I had a poor performing query that took and average almost 4 seconds to execute. In …
7 replies
Hello, I am back, want to say thank you again John M. for the assistance, with that logic i was abl…
2 replies
Hello, i may be over thinking this, but i have a situation where we have a requirement for a part, …
2 replies
I have a query below that is working fine, but I'm needing to connect it to another database within…
10 replies
Hello, I have this test table: CREATE TABLE #T2 ( VARCHAR(100))INSERT INTO #T2 ()VALUES ('https://…
12 replies
I have a working script but would like to use a variable in the script to save me having to amend t…
5 replies
HelloI want to prepare a stock list of last entry , first entry DECLARE @IN TABLE (STOCK INT,ID INT…
10 replies
Hello Good Evening SUM(Principal1) + SUM(BankInterest) + SUM(TAltrate) + SUM(PanaltyCharge) A…
4 replies
CREATE TABLE #MyTemp( YearCol INT , MonthCol INT , RegionName VARCHAR(200) , …
3 replies
Hi Everyone, After reading on this topic and being advised to use DateDiff I wrote a Function that …
8 replies
Viewing 15 topics - 721 through 735 (of 4,984 total)
You must be logged in to create new topics.