Topics
Started by
Posts
Last post
Hi All, I was given a windows 8 workstation and sql server 2008 r2 was installed in it because it i…
1 replies
I have created a table Emp_Salary Create Table Employee_Salary ( EmployeeID Int, FirstName Varchar(…
6 replies
Excel Formula =+((+MAX(B2:B9)-B2)+(+(C2-(MIN(C2:C9)))))/2 Can this be converted to SQL? Excel Table…
22 replies
Hi, I have imported data into a database from an excel file and some of the columns contain va…
4 replies
I run a DBCC nightly on all my SQL DB's, but now I'm trying to ensure the fragmentation levels are …
14 replies
Hello, I'm trying to merge or concatenate 2 columns together. one is alphanumeric and the other is …
2 replies
Let me start by saying this is the first time I have tried to install any version of SQL Server. I…
1 replies
Hi All, I am getting an error while updating SQL Server 2008 R2 SP2 CU11 as 'patch installer failed…
6 replies
Hello I'm new to SQL. I'm getting the hang of it, but still hit snags from here to there. I have a …
23 replies
So I've found this: http://sqlmag.com/t-SQL/pivoting-without-aggregation I tried to mimic this for …
24 replies
We have a SQL Server 2008 Enterprise Edition SP3 64 bit environment. We're migrating SQL Server 20…
5 replies
I have the following two tables: CREATE TABLE eventhistory ( Event_id number not null, Event_De…
3 replies
I have a table Studentgrades Create Table Studentgrades ( StudentID Int, FirstName Varchar(100), C…
1 replies
DECLARE @sql nvarchar(max) SET @sql = N'SELECT TeamID' SELECT @sql = @sql + ',MAX(CASE WHEN row…
4 replies
I have created a table Employee with empID and Salary. Using the case statement I tried to add a co…
7 replies
Viewing 15 topics - 856 through 870 (of 5,050 total)
You must be logged in to create new topics.