SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Carriage return problem

  Hi everyone. I'm having a problem exporting a view to a text file. There is a column in my view ca…

  bjohnson-660281

  2 replies

  15 years, 8 months ago

  By: bjohnson-660281

• Rollback not working over Linked Server

  I am doing an BEGIN TRANSACTION in Stored Procedure in SQL 2005 I am using an OPEN QUERY Call to an…

  mhilligas

  2 replies

  15 years, 8 months ago

  By: PaulB-TheOneAndOnly

• Calculation of points

  Dear Friends, I have to calculate the business points a user obtains by referring other members. Fo…

  KnowledgeSeeker

  7 replies

  15 years, 8 months ago

  By: SQLRNNR

• Trigger not working as expected

  Hi everyone. I have a table called "casemain". This table includes permit number, permit status, a…

  bjohnson-660281

  3 replies

  15 years, 8 months ago

  By: bjohnson-660281

• SQL Statement to retrieve date from two weeks ago

  I am assuming I would use the dateadd function but how would I retrieve the date from two weeks ago…

  tripower

  2 replies

  15 years, 8 months ago

  By: Lynn Pettis

• Your own SPID

  Hello, How do you find out your own SPID?

  idiescreaming

  19 replies

  15 years, 8 months ago

  By: Gail Shaw

• Update Statement Creates Unwanted Nulls

  Let's say xTest has 9 records and no nulls. xUpdate has 6 records. I am updating locations for 6 …

  maricled

  4 replies

  15 years, 8 months ago

  By: maricled

• Obtain Values for Chart

  Hi folks, I'm trying to obtain the count of Experience Levels (high, low, medium & no experien…

  bpmosullivan

  8 replies

  15 years, 8 months ago

  By: Nabha

• Case When Then Error

  I have the following case statement: case pt.intPointTypeID when 1 then convert(varchar(100), tet.d…

  saurabh.kumar

  3 replies

  15 years, 8 months ago

  By: Adi Cohn-120898

• Question about query error received

  I have a question about some code that I wrote. I don’t understand why I got an error message and …

  Kit G

  6 replies

  15 years, 8 months ago

  By: ChrisM@Work

• Table design/select statements - rows to columns (T-SQL)?

  Hi, I have a question regarding converting row values to columns and hope that someone could help m…

  christian.rosberg

  5 replies

  15 years, 8 months ago

  By: christian.rosberg

• Will it cause a problem to create a new snapshot after replication has already been setup and initial snapshot was previously created?

  Replication was already setup and initial snapshot was created at that time. Replication had failed…

  mkaukonen

  1 replies

  15 years, 8 months ago

  By: andrewkane17

• Values from row to columns as indicator

  [font="Verdana"]Please can someone help me? I would like to create output table as below from follo…

  pramen

  9 replies

  15 years, 8 months ago

  By: Jeff Moden

• DataTable to Excel using C#

  Hi Guys, I already established connection to Excel 2007 using the following connection string: stri…

  kenchidon

  5 replies

  15 years, 8 months ago

  By: kenchidon

• Will not write out the rest of my query

  I have written a query na d add to take out the CRLF's but now it stops and will not export the res…

  SQL Girl

  6 replies

  15 years, 8 months ago

  By: WayneS