SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Change Insert Statement into Update Statement

  Some time ago I asked how to import images into SQL Server. At that time I was using a new table to…

  r_slot

  1 replies

  13 years, 4 months ago

  By: r_slot

• Use the Table valued function in the query

  I have 3 tables and one table valued function: EmpHistory,EmpRank,Emp and fnEmpRank. The sample…

  deepeshdhake

  10 replies

  13 years, 4 months ago

  By: Sean Lange

• Working Day is Current Month

  Hi All, I'm looking for a way to create a query or function that calculates the number of working d…

  DBayliss

  3 replies

  13 years, 4 months ago

  By: Andy Hyslop

• Multiple Rows of Data To Single Row With One ID

  Hi, I'm trying to alter a table to contain data in a horizontal (row) format rather than a vertica…

  edgar58

  7 replies

  13 years, 4 months ago

  By: edgar58

• Multiple IP addresses but same SQL Server instance?!

  We have a SQL Server instance that I can access by logging into 3 different servers. I don't really…

  Abu Dina

  7 replies

  13 years, 4 months ago

  By: Joie Andrew

• Must Declare Scalar variables error

  I need help in understanding why I am getting the error "Must Declare Scalar variables" In the fol…

  codegizmo

  1 replies

  13 years, 4 months ago

  By: Lowell

• Stored Procedure to Add Details to a table

  Hi, I have a patient table, nurse table and a doctor table but would like to store the common detai…

  soulchyld21

  2 replies

  13 years, 4 months ago

  By: Grant Fritchey

• Relationship between tables

  Hi, this query returns almost all that I need, but NUMEROCCF from TPRD is missing. If I just add it…

  fodex7l

  2 replies

  13 years, 4 months ago

  By: fodex7l

• QUERY taking too much time in execution

  I have a scenario in which I have a table citymaster(cityid,cityname,stateid) which needs to be ge…

  kapil_kk

  16 replies

  13 years, 4 months ago

  By: kapil_kk

• Job - Scheduled update table in another databaes nightly - please review and comment on script / process

  Please review Newbie's code and plan: Comments welcome SQL 2008 - Database name FOO FOO has 2 dat…

  Mile Higher Than Sea Level

  1 replies

  13 years, 4 months ago

  By: Sean Pearce

• split column pipe delimited

  Hi All, I'm having trouble separating a single column into multiple columns where the pipe is the d…

  DBayliss

  10 replies

  13 years, 4 months ago

  By: Cadavre

• remote table update performance

  Hi all, I am having problem updating remote table. It just taking too long. I am new to SQL Server …

  RightOnTarget

  4 replies

  13 years, 4 months ago

  By: Igor Micev

• Trying to view properties of the Database

  When I right click on the database to view properties on any of the databases on the server I get t…

  D-SQL

  15 replies

  13 years, 4 months ago

  By: Gail Shaw

• Select Query to return all rows from one table

  Hi All, I have three tables tPeriod which has PeriodID int, PeriodDiscription char tTimeTable which…

  Jay B-317395

  5 replies

  13 years, 4 months ago

  By: Eugene Elutin

• Can i install sql server 2008 r2 on windows server 2008 r2 which has active directory users and computers

  Hello friends, Iam a newbie to sql server dba tasks, I want to install sql server 2008 r2 enterpri…

  vamsi056

  13 replies

  13 years, 4 months ago

  By: vamsi056