SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• newbie question - how to connect to local server?

  hi all, i am brand new to using SQL server. I just installed SQL server 2008 enterprise edition on …

  bkmj1mtym

  2 replies

  15 years, 8 months ago

  By: SQLRNNR

• NTEXT field as input parameter for Stored Procedure

  I am using SQL 2008. I have a stored procedure that I am passing 2 parameters into. One parameter i…

  kimber42003

  4 replies

  15 years, 8 months ago

  By: sheila.filteau

• Time For A View?

  Hello. I have a PROJECT_TBL that has id references to other tables. IE. resource_id for the RESO…

  jmiaebrown

  4 replies

  15 years, 8 months ago

  By: jmiaebrown

• Syntax error converting the varchar value 'Staffing' to a column of data type int.

  I have the below code that I am trying to write, but it is giving me the above error message: inser…

  frcoley

  2 replies

  15 years, 8 months ago

  By: ChiragNS

• Trying to determine access from table that only shows rows with None or ReadOnly permissions if no row full access

  I have a table named LSA_COMMAND_PERMISSION that an application uses that has 3 columns ROLE_NAME, …

  ed.mitchell

  3 replies

  15 years, 8 months ago

  By: Ron McCullough

• Dropping Tables

  Hi All, I'm quite new here and my skills on SQL are limited :/ I normally setup the server, install…

  scott.lucas-1068252

  9 replies

  15 years, 8 months ago

  By: scott.lucas-1068252

• Convert to decimal

  Hi, I have a query that returns the number of instances of a particular value. e.g. the number of t…

  andy.woodward

  2 replies

  15 years, 8 months ago

  By: andy.woodward

• moving sql servers to a new ou

  im doing a migration project that involves moving 15 sql servers from an old ou to a new ou with ne…

  dhealy

  6 replies

  15 years, 8 months ago

  By: dhealy

• Database Diagram - How to interpret the symbols that explain table relationships

  I hate to ask such a simple question, but I have not been able to find out the meaning behind the l…

  meichner

  6 replies

  15 years, 8 months ago

  By: meichner

• view size for database-files, and export it to table.

  Hi everyone, can u please help with a script that does following; I need a resultset that shows me…

  ArashS

  3 replies

  15 years, 8 months ago

  By: george sibbald

• only get the forst match from table 2

  I have 2 tables with table 1 containing columns m_ID(int), description and table 2 containing m_ID(…

  OJDev

  9 replies

  15 years, 8 months ago

  By: Grant Fritchey

• Turning multiple rows into a view of multiple columns, calculating a value

  I have a fairly simple table for storing sales data with the following columns: Store#, Year, Week,…

  rosewood

  3 replies

  15 years, 8 months ago

  By: LutzM

• Using SSIS for Date Specific File handling

  :alien: Hello, For background purposes, I am a 20+ year IT vet from the mainframe world migrating…

  rixster

  6 replies

  15 years, 8 months ago

  By: Jeffrey Williams

• Want to use WHILE loop in Stored procedure

  I have a stored procedure that will take date period as one of the input, say, from 20th Dec to 27t…

  amitabhssinha

  13 replies

  15 years, 8 months ago

  By: ChrisM@home

• Error in converting from datediff(,,) to Varchar()

  While converting from Datediff(second,date1,date2) to varchar() I am getting following error : "Syn…

  amitabhssinha

  4 replies

  15 years, 8 months ago

  By: LutzM