SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Can't locate large file taking up space on C drive of SQL 2008 R2 sharepoint server

  When I look at the C drive properties of this server, which is used only as a Sharepoint - Intranet…

  harrietf

  7 replies

  11 years, 1 months ago

  By: harrietf

• LIKE and IN in same where clause

  I am trying to create a report with multiple value parameters which has individual names as well as…

  sharonsql2013

  1 replies

  11 years, 1 months ago

  By: Xedni

• Align values from separate columns into same rows

  Hi, If I have a table like this: idval1val2 ---------------------------- 1red NULL 1blueNULL 1…

  emelmarz

  4 replies

  11 years, 1 months ago

  By: Luis Cazares

• ERRORLOG messages from sys.messages

  Hi folks, Direct (and very basic I guess) question: All texts from sys.messages marked with is_ev…

  Radiance

  6 replies

  11 years, 1 months ago

  By: Radiance

• removing/redirecting duplicates in ssis

  how to remove/redirect duplicates in ssis case- columns: id, name, address, phone id is same but na…

  siri_rmsi

  1 replies

  11 years, 1 months ago

  By: Koen Verbeeck

• Function - 4 dates - Business rule evaluates and returns business case - Evaluation requested

  I have 3 Views that use the Over Partition By to supply the latest date. Date1 is the Permit Applic…

  Mile Higher Than Sea Level

  6 replies

  11 years, 1 months ago

  By: Mile Higher Than Sea Level

• CASE or IF ... THEN around INSERT statements

  I have a bunch of INSERT statements around which I want to use CASE or IF .. THEN. -- Test for @Me…

  JJR333

  1 replies

  11 years, 1 months ago

  By: JJR333

• How to extract values from a column which has multiple delimiters?

  I have a table which has a cloumn "PersonNames" and few of the values are - 124546: Sam; 548464: D…

  unmesh2903

  16 replies

  11 years, 1 months ago

  By: Luis Cazares

• Variable to hold an array of strings

  How can I use a variable with AND NiveauZPT IN ('1','2','2+','3','4','5') I would like to edit th…

  JJR333

  3 replies

  11 years, 1 months ago

  By: Ed Wagner

• table variables vs physical tables performance

  Hi Guys I have run into a strange issue . I have a Stored Procedure which is having couple of inner…

  sunil88_pal88

  4 replies

  11 years, 1 months ago

  By: Gail Shaw

• SELECT FROM SUBQUERYS

  The first Select From works ok on its own. For some reason I cannot get the last (3th) column (see …

  JJR333

  8 replies

  11 years, 1 months ago

  By: JJR333

• SQL server newbie

  Hi. I've just started a new job and working with Access databases, but these are getting very close…

  jonen

  18 replies

  11 years, 1 months ago

  By: Mile Higher Than Sea Level

• How to get the latest record before a defined value in a field

  Hi all! I have this table: CREATE TABLE [dbo].[DutyRosterShiftHisto]( [Comment] [char](120) NULL, …

  Edvard Korsbæk

  2 replies

  11 years, 1 months ago

  By: nigel.

• Case in SQL

  Is there a better way to approach this ? Sorry there was an error earlier . Case when Server…

  sharonsql2013

  5 replies

  11 years, 1 months ago

  By: Jeff Moden

• Using IN operator to find id exist or not

  CREATE TABLE [REV_BINDERS2]( [OFFICE_ID] [int] NOT NULL) insert into REV_BINDERS2(OFFICE_ID) selec…

  selpoivre

  8 replies

  11 years, 1 months ago

  By: Lynn Pettis