Topics
Started by
Posts
Last post
Hi SQL Gurus, I have a below table with column names ACCOUNT, QTR1, QTR2, QTR3, QTR4 ACCOUNT QTR1 Q…
11 replies
Hi, SQL Server has the MERGE statement and some people advise to use it instead of IF EXISTS with I…
14 replies
I have a question, Here is my query, SELECT SID FROM chartdDB WHERE ADate = @ADate AND SID NOT IN …
18 replies
Hi, Please let me know how to retrieve the number from Attribute column based on IndexKey using use…
9 replies
Hi there, I'd be grateful if someone could help:) I have a BoM issue. The table below shows the com…
16 replies
(received this from a developer - Anything stand out here??) This statement used to run with the CO…
4 replies
hi, I am looking for a custom script to get the details from all the servers while running the scri…
6 replies
Hi, I have a table with 1.000.000 or more. It stores the stocks for each product on a store. Imagin…
4 replies
CREATE TABLE Issue ( id int not null identity(1,1) primary key, name varchar(10) ) CREATE TABLE Jrn…
125 replies
Hi I have a table C1 C2 10 20 10 30 30 20 40 50 20 60 50 70 80 …
44 replies
Hey guys, Is there a static way to get the last day of the each month from the past quarter? I know…
11 replies
I'm unfamiliar with creating Logins and Im trying to run the following query CREATE LOGIN [CORP\NC…
3 replies
Good Day To All, I'm working on a budgetreport that ask the user to enter the up to date. If the us…
11 replies
Does an UPDATE query overwrite existing values if the already existing value is the same as the one…
159 replies
I am creating report for displaying continuous absent for more than 2 days.Query is build and worki…
1 replies
Viewing 15 topics - 5,131 through 5,145 (of 10,647 total)
You must be logged in to create new topics.