SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• New SQL Server Database with security

  Hi All, we have SQL Server that has several databases and users can access the databases, the probl…

  dnonyane

  8 replies

  11 years ago

  By: Gail Shaw

• Trouble in Using Stored Procedure in Excel

  Good Evening Guys, I would like to kindly ask if i am missing a step in retrieving Data to excel us…

  Stylez

  1 replies

  11 years ago

  By: dbalmf

• database stages

  Hi Can anyone let me know what are the different stages of a sql db after restart. Regards Atulyan

  atulyan.aries

  2 replies

  11 years ago

  By: Grant Fritchey

• CAST for DEcimal

  I am using CAST to convert into decimal and find the percentage, but it rounds the value to the nea…

  sharonsql2013

  5 replies

  11 years ago

  By: David Webb-CDS

• Afficher le résultat de la procédure DetailRapport sous excel

  Bonjour je suis débutante en SQL SERVER MANAGEMENT STUDIO 2008. dans mon projet je voudrais affiche…

  wantedbutter

  5 replies

  11 years ago

  By: Matt Miller (4)

• Problem using bcp

  I am attempting to import data from a text file customtextout.txt (data in file is separated by a c…

  ordnance1

  2 replies

  11 years, 1 months ago

  By: Lowell

• add query field

  while adding the Data sets , In field Option we get add query field and calculated filed. I figure…

  super48

  4 replies

  11 years, 1 months ago

  By: g.britton

• Linking three databases so they show data right (please help a sql newbie!)

  I am new to sql server so I appreciate all help i can get in this matter. what I want in a success…

  scott.foss

  1 replies

  11 years, 1 months ago

  By: djj

• Case with Int and Varchar

  I am trying a case statement but get the error : "Conversion failed when converting the varchar val…

  sharonsql2013

  4 replies

  11 years, 1 months ago

  By: sharonsql2013

• SQL newbie: How to extract all columns from multiple tables and save to a new table

  I have four tables. Table1 has four columns, Table2 has 3 columns, Table3 has eight columns and Tab…

  Ashish Dutt

  6 replies

  11 years, 1 months ago

  By: SQL_Baby

• Avoiding duplicates from file import

  Hi I am building an automated process to import delimited text file data to a master table. As part…

  FishD

  12 replies

  11 years, 1 months ago

  By: MMartin1

• dot notation where all columns are not referenced

  I have come across a few tables that are created using dot notation, but not all of the columns are…

  mcinvalek

  7 replies

  11 years, 1 months ago

  By: Lynn Pettis

• Protecting authorship of sql code.

  What are the recommended steps to insure the code that I create, is portable to me in authorship an…

  lkent

  2 replies

  11 years, 1 months ago

  By: Jack Corbett

• Help with Error:Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

  SELECT DISTINCT(USER_ID) FROM marketing_dataset WHERE EMAIL_CAMPAIGN IN (SELECT TOP 1 with ties SUM…

  saurabh.kumar

  3 replies

  11 years, 1 months ago

  By: Koen Verbeeck

• Grant Select Permission for All tables

  Hi All, I have given one of the DB as a Read only access for all the tables using Windows Authentic…

  arooj300

  3 replies

  11 years, 1 months ago

  By: Gail Shaw