00:00 - 22:0022:00 - 00:00
This process to convert columns into rows is actually called an UNPIVOT. You can do this a few different ways.
UNPIVOT: function:
;with cte as
(
select'Amount' as Amount,
('£'+ CAST(SUM(rc.[Fee Charge] +rc.[Fee Charge VAT] +rc.ExtraCharges+rc.ExtraChargesVAT+rc.OtherCharges+rc.OtherCharg...
This has been troubling me for days, I have a table with auto-increment, what I want is that the value of the increment value will be inserted in the same row. The problem is that when concurrent users are accessing the query, it will not copy the correct value.
Below is my query:
Table:
Crea...
Our production server is running SQL Server 2008 (non r2).
I'm working on investigating and issue that appears to be networking or connection related, where our web server is losing or dropping connections to the database server.
It would assist me greatly to have a method or counter that I c...
I have 30 + rows that I need transposed into 4 columns. Each column has a heading (AB, HH, Citz, PA)
How can I forward engineer a Workbench model with my given name of the database scheme?
Yes I can edit it in the editor window shown on the image, but what if I have 30 tables to export as SQL code?
Yes I can use find/replace tool before executing the exported SQL, but you can forget to use it...
2
I am connecting mysql on server A/ to a webapp located on server B/. Both servers are Ubuntu servers.
For security purposes, is there any way on server B to avoid showing the full path / IP address of server A/ to connect to as this is where the mysql database is?
Thanks!
On the moderator election page, hovering over the vote buttons produces the alerts you'd see when hovering over the vote buttons on a question. This behavior only occurs when hovering over the vote buttons for candidates you haven't currently voted for. See screenshots:
As you can see, the m...
this is how i reproduced
I cast my vote ,
getting same as other answer
undo that vote ,
now bug reproduced of question
In my opinion, the answer attempts to answer the question, but needs some improvement. It was obviously answered before there were stricter standards on answering.
Before flagging it, I would first try to ask the user to improve their answer by adding the relevant excerpts from the links as the...
consider the relational database....
employee(employee_name,street,city),
works(employee_name,company_name,salary),
company(company_name,city),
manages(employee_name,management)...............
Give an expression in the relational algebra and query in STRUCTURED QUERY LANGUAGE for each quest...
I have an ouptut that looks like
ID | Version | Date | Value | Value Type
1 | 1 | 2012 | 1 | x
1 | 1 | 2012 | 1.5 | y
1 | 2 | 2012 | 2.3 | x
1 | 2 | 2012 | 1.7 | y
I want the output to look like
ID | Version | Date | X | Y
1 | 1 | 2012 | 1 | 1...
when i try this sp
ALTER PROCEDURE [dbo].[spadminreg] @UserName NVARCHAR(50)
,@Password NVARCHAR(50)
,@UserTypeID INT
,@DepID INT
,@DesigID INT
,@emailaddress NVARCHAR(50)
,@PhoneNumber NVARCHAR(50)
AS
IF EXISTS ( SELECT Designation.DesigID
,Departme...0
A couple of times recently I've had downvotes on my questions that occurred within a few seconds of each other. I rarely get downvotes, so to get 2 so close together seems more than a coincidence.
Here are the timestamps and questions:
Timestamp Question ID
2014-02-18 21:40:58 140...
2
i want to join two tables with group by
select t.acno,t.name,count(Q.trans) as test,Q.transvalue,q.transdate
from dbo.test t
inner join dbo.testaqc q
on t.acno=Q.acno
group by q.trans
but i am receiving the error:
Msg 8120, Level 16, State 1, Line 1
Column 'dbo.test.acno' is inva...
I have a huge dataset to return in SQL Server( about 32 million rows) This is implemented in view and source code is as follows :
select
ISNULL(mle.MIdeer, mle.Ider)+ em.MemberId as Idenitifier
,ISNULL(
em.EffectiveDate
,(
SELECT TOP 1 EffectiveDate
FROM c
WH...
Mr. Peabody is a cartoon dog who appeared in the late 1950s and early 1960s television animated series Rocky and His Friends and The Bullwinkle Show produced by Jay Ward, collectively referred to as Rocky and Bullwinkle. Peabody appeared in the Peabody's Improbable History segments created by Ted Key, and was voiced by Bill Scott, while Sherman was voiced by Walter Tetley.
Plot
The cartoons are about Peabody, a beagle who is the smartest being in existence. Peabody has accomplished many things in his life as a business magnate, inventor, scientist, Nobel laureate, gourmand, and two-time ...
00:00 - 22:0022:00 - 00:00
