SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Getting a count of how many times each value from a list of values is used

  I have a table which contains 2 columns and stores a list of values which are used (as a "lookup ta…

  Jason Miller-427226

  1 replies

  17 years, 5 months ago

  By: toniupstny

• Deleting records based on results of a View

  I have a view who's resulting rows contain the info of records I need to delete from a certain tabl…

  Jason Miller-427226

  2 replies

  17 years, 5 months ago

  By: Jason Miller-427226

• Coding convention for writing a stored procedure script (ALTER or DROP-CREATE)

  I'm writing a set of stored procedures for a new project and I cannot decide between the following …

  bmgun

  2 replies

  17 years, 5 months ago

  By: bmgun

• SQL change properties error

  Hi, I am trying to change the default location of new databases for my MS SQL server 2000 thro…

  Alvin-250072

  10 replies

  17 years, 5 months ago

  By: Key DBA

• Multi-part identifier could not be bound

  I am trying to query a database with 3 tables: Person(PersonID, Birthday, Gender) Procedure(PatID, …

  Steve Hughes-299553

  12 replies

  17 years, 5 months ago

  By: Gail Shaw

• Get records each day in month

  Hi all Happy new year 2008 I have records save on date when transactions made,Table has …

  bsasiju

  2 replies

  17 years, 5 months ago

  By: Jeff Moden

• How to debug T-SQL

  I still count myself as a Newbie even though I have moderately good skills in database design and a…

  goodguy

  6 replies

  17 years, 5 months ago

  By: goodguy

• T-sql question

  I have a table with purchase order info. There are several records with the same p.o number but kep…

  Jerry Tienter-162701

  4 replies

  17 years, 5 months ago

  By: Jeff Moden

• adding 3 columns into a new column in an existing table

  I have an existing table where i have add1, add2, add3 as columns. Now i want to add all the 3 into…

  Senthilkumar-215205

  6 replies

  17 years, 5 months ago

  By: Jeff Moden

• Using INSERT between dates?

  I've used update to add data to records that fall between 2 dates, is it possible to use INSERT in …

  mick burden

  11 replies

  17 years, 5 months ago

  By: Jeff Moden

• converting to date format

  Hello everyone! I have a table that have a field type nvarchar(6) and it suppost to be dates, the …

  Maique

  7 replies

  17 years, 5 months ago

  By: Madhivanan-208264

• T-SQL

  Hello I have a huge database and i need to know how i can list the tables within a database, so to …

  b_boy

  6 replies

  17 years, 5 months ago

  By: Madhivanan-208264

• Help Passing Table Name as Stored Proc Parameter

  I created the following Stored Procedure however when I try to Exec and pass a value for the table …

  bshulam

  2 replies

  17 years, 5 months ago

  By: bshulam

• calculate number of days

  Hi all, I am a newbie here and I 'd like to learn how to: a) I want to create a stored procedure th…

  tony appleby

  2 replies

  17 years, 5 months ago

  By: Jeff Moden

• Server and service manager

  Hi guys, I'm sure this is a very very easy thing for you guys, looks like im really hopeless in get…

  dileep_ratnayake

  6 replies

  17 years, 5 months ago

  By: dileep_ratnayake