there's a data set with around 6 millions of records. Each record has the same number of fields. There are 8 fields totally:
ID Title Color Date1 Date2 Date3 Date4...
There should be a way to filter these records by title and all date fields (or, 'columns' in RDBMS terms).
The size of t...
I just got my head around left outer joins, and I am practicing PIVOTS.
I am wondering whether it is possible to convert this query into a pivot?
SELECT mydrawercustomer.customerface,
mydrawerordertype.ordertypeface,
mydrawerorder.LM,
Datediff(hour, a1.playdate, a2.playd...
Is it possible to restore database from the latest .bak file using sql script?
I am attempting to set up a development machine. One of the components is SQL Server 2008 R2.
I log in into the machine as local administrator and then I am trying to use windows authentication to log in into local instance of SQL Server. When I try to change password for sa I get error:
C...
I have a new SQL Server 2012 instance and when I run the following command I get an error.
ALTER SERVICE MASTER KEY REGENERATE
Error:
Msg 15329, Level 16, State 1, Line 1
The current master key cannot be decrypted. If this is a database master key, you should attempt to open it in the se...
I want to do a mssql date range to return the data for an hour time range. Meaning, I want to return the data for the last hour, but not for the last hour from the current time.
Declare @today datetime
set @today=GETDATE()
select * from table1 where
datetime>= DATEADD(hh,-2,@Today)
For examp...
Did you just create the UDFs?
You may need to refresh the Intellisense(if you don't know how, just quit SSMS and open it again)
I am pretty new to SQL Server, I am trying to do this... Not sure what I am doing wrong
Here is my schema:
CREATE TABLE [Product_AGGREGATION](
[Product_ID] [int] NULL,
[ITERATION] [int] NULL,
[EQUIPMENT_USED] [varchar](8) NULL,
[MODEL_USED] [varchar](25) NULL,
[SERIAL_NUMBER] [v...
Since you have a DataTable already, and since I am assuming you are using SQL Server 2008 or better, this is probably the most straightforward way. First, in your database, create the following two objects:
CREATE TYPE dbo.MyDataTable -- you can be more speciifc here
AS TABLE
(
col1 INT,
col...
I cant seem to see why this query is failing, in my group by clause I have the columns that are in my select yet im still getting the error. Why is this? Below is my query;
SELECT c.customer_first_name, c.customer_last_name, MAX(SUM(cost_line))
FROM customers c LEFT OUTER JOIN orders o USING(cus...
