SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Sql Qurey Subtract Data on Hourly basis

  Hi Experts I want to write a query on hour basis. My time always starts from 0:00 hrs and end on 24…

  smer

  19 replies

  10 years, 4 months ago

  By: Luis Cazares

• Reporting service issue

  Hi All, SQL Server Reporting Service is running under local system, but when i changed service from…

  arooj300

  3 replies

  10 years, 4 months ago

  By: Sam77

• Simple SQL Query - Or So I thought.

  Hi all, Bit of a noob, still lots to learn lol Trying to do a many to many query as follows: SELE…

  mattmacmillan

  9 replies

  10 years, 4 months ago

  By: Gail Shaw

• How to get the max value of a column?

  Hi, I wanted to find the max value of a column. I have the following table structure OrderIDTaskI…

  rajagopalanseeth

  4 replies

  10 years, 4 months ago

  By: Alvin Ramard

• ldf shrink issue

  We have a standalone SQL Server 2008 R2 instance (standard edition). The database was installed wi…

  jralston88

  5 replies

  10 years, 4 months ago

  By: jralston88

• Compare field to results from another table

  I have a stored procedure that runs and it returns all items in our system that are flagged with on…

  DaveK2014

  4 replies

  10 years, 4 months ago

  By: Jack Corbett

• SQL DB slow after restore

  I just want to understand what happens. I restore databases again and again in my developement cyc…

  Edvard Korsbæk

  8 replies

  10 years, 4 months ago

  By: free_mascot

• Bulk insert from Excel

  Hi, I have two columns in an Excel spreadsheet: productid and colour. These columns are populated w…

  ma701ss

  11 replies

  10 years, 4 months ago

  By: ma701ss

• IT cost tracker

  Hi Guys, I think I originally posted in the wrong section, I'm a newbie to sql and need some help a…

  imran.shah

  1 replies

  10 years, 4 months ago

  By: pietlinden

• need summarized info in the sql join queries

  _______________________ AVAILABLE DATA:Attached screenshot + description __________________________…

  Tiya

  16 replies

  10 years, 5 months ago

  By: mailtosindu.shri

• grateful

  Hello, i would be so grateful is somone could help me with this. Table data Order : Line : Catego…

  jonas_ljungby

  2 replies

  10 years, 5 months ago

  By: jonas_ljungby

• xp_cmdshell --> "Access is denied."

  Hi all, I am trying to copy a backup file from sql server 2008R2 to sql server 2012 running: EXEC …

  RightOnTarget

  10 replies

  10 years, 5 months ago

  By: Maxxxie74

• I need to make a sql login also be a db user with the same name

  I need to make a sql login name also become a database user with the same name. How do I make the l…

  rpk7309

  2 replies

  10 years, 5 months ago

  By: Lowell

• Concatenation of three fields with conditional parenthesis around last two fields for a field in a View

  The single record view uses this: ISNULL(dbo.APD_Stips1.Stip_Abv, N' ') + N' ' + N'(' + ISNULL(dbo.…

  Mile Higher Than Sea Level

  4 replies

  10 years, 5 months ago

  By: Mile Higher Than Sea Level

• Cannot return correct value in SQL statement

  I need to create a commission report. basically if you are a certain salesperson 0 commission, if…

  randyetheridge

  3 replies

  10 years, 5 months ago

  By: Luis Cazares