SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• daily report

  I have to supply a daily report. I have written the correct query in T-SQL. Is there a way to use…

  inevercheckthis2002

  7 replies

  11 years, 4 months ago

  By: CKX

• Performance issue related to Memory shortage?

  Apologies if this isn't posted in the correct section - please redirect me if appropriate. I've rec…

  Ngramstad

  2 replies

  11 years, 5 months ago

  By: Ngramstad

• Comparing records to previous records in query

  Hi, Here is a sample table: CustomerID------InvoiceID------Total ----95---------------3546--------#…

  tarr94

  11 replies

  11 years, 5 months ago

  By: rxm119528

• Question about Parsing and Case Statement

  I have to write a SQL script where one of the requirement is DeliveryIDcharacters 1-7 not equal to …

  saifmahatab

  1 replies

  11 years, 5 months ago

  By: Luis Cazares

• Microsoft Query

  I know this is the wrong forum to post but I have no idea where to post and this is just a shot in …

  david.john.gilligan

  23 replies

  11 years, 5 months ago

  By: Don Urquhart

• Creating an 'application user' with datareader role using SMSS (not too simple)

  Well, I have installed SQL Server Management Studio 2012, and, I am wondering how to create a new u…

  Jon80

  3 replies

  11 years, 5 months ago

  By: SQLRNNR

• Complex query - converting Excel to SQL Server query - would prefer a view

  Hi, I've got an Excel "application" that I'm converting to Access front end (FE)/SQL Server back en…

  Scott In Sydney

  3 replies

  11 years, 5 months ago

  By: Scott In Sydney

• Question about VARCHAR(MAX)

  I am looking at some queries that were written by someone else and I just want to ask if I'm accura…

  thomashohner

  8 replies

  11 years, 5 months ago

  By: Evil Kraig F

• Corresponding column value to MAX() of a different column?

  Hopefully I can explain properly what I'm trying to do here. I'm not very experienced in SQL so may…

  TommyDuggs

  3 replies

  11 years, 5 months ago

  By: Lynn Pettis

• Total Novice needs help with script

  I receive error message "Msg 4147, Level 15, State 1, Line 64" on my script when I run it. It tells…

  victor.a.sharps

  1 replies

  11 years, 5 months ago

  By: Luis Cazares

• SQL scheduled job failing post-migration

  Hi All, One of our software vendors has mandated a migration to a 64 bit server. A few of our sched…

  alicesql

  4 replies

  11 years, 5 months ago

  By: alicesql

• Trace Script

  Hi All, I am using DB with SQL SERVER Authentication privilege. If something will go wrong , suppos…

  arooj300

  3 replies

  11 years, 5 months ago

  By: Ed Wagner

• Restore DB .bak file help

  HI guys so I am still setting up my home machine. I have installed SQl Server 2008 R2 and all Servi…

  thomashohner

  8 replies

  11 years, 5 months ago

  By: thomashohner

• stop long-running job

  Hi all, I am trying to write a script to stop a job if it runs outside of "normal" duration. Here i…

  RightOnTarget

  4 replies

  11 years, 5 months ago

  By: RightOnTarget

• notify when a particular field changes

  Hi everyone. I need to be able to list a record set where a particular field has changed, I've writ…

  mick burden

  17 replies

  11 years, 5 months ago

  By: Umer Akram