SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Select bottom 25%

  Hi, I'm trying to find the best way to break the following numbers up by quartile percentage, parti…

  Marcus Farrugia

  11 replies

  11 years, 4 months ago

  By: MMartin1

• String Checking

  I have a string 'ACDIPFJZ' In my table one of the column has data like PFAG ABCDEFHJMPUYZ KML JC RP…

  rajan.nithin

  3 replies

  11 years, 4 months ago

  By: Dwain Camps

• BAckups in default location without SQL job

  Hi Team, We configured jobs to run everyday on F drive . I am seeing some backups in default locati…

  Lavanyasri

  7 replies

  11 years, 4 months ago

  By: Gail Shaw

• SQL script GROUPING

  Hi I have table CREATE TABLE #RESULT ( Name Varchar(32), Quantity Int, Volume Flo…

  nwtsqlserv

  2 replies

  11 years, 4 months ago

  By: nwtsqlserv

• UPDATE table

  Hello to all, I need to create a query that updates table as follows: -- tables involved -- [Parts]…

  sargon.le.grand

  5 replies

  11 years, 4 months ago

  By: sargon.le.grand

• HTTP Streaming in SQL

  Hello, is it possible to take a URL that is stored in a database and stream the actual document to …

  oradbguru

  2 replies

  11 years, 4 months ago

  By: Scott Coleman

• Restore Snapshot works in SSMS not in SSIS

  Hi, I have an SSIS package running under a proxy. the basic process is 1) Take Database Snapshot 2)…

  jon.lunn

  4 replies

  11 years, 4 months ago

  By: jon.lunn

• Creating an alphabetical list with letter header

  Hello, I am looking for a way (if possible) to create a query that will produce an alphabetical lis…

  Meatloaf

  6 replies

  11 years, 4 months ago

  By: Meatloaf

• create trigger on update and on insert

  Hi, I have this table CREATE TABLE [dbo].[CARTOES]( [COD_ID] [int] IDENTITY(1,1) NOT NULL, [CODC…

  river1

  6 replies

  11 years, 4 months ago

  By: satnam.singh 44358

• Cannot open user default database. Login failed.

  Hi all, SQL Server 2008R2 on Windows server 2008. Last night many scheduled jobs failed with "Canno…

  RightOnTarget

  2 replies

  11 years, 4 months ago

  By: ScottPletcher

• OLE DB provider "SQLNCLI10" for linked server "(null)

  Hi guys, I am keep getting this error message when I am trying to connect to one SQL Instance whic…

  SQlLogic

  7 replies

  11 years, 4 months ago

  By: MMartin1

• Alter the schema from one view causes the need to alter the other

  Hi, I have a view like: select * from column1, column2, column3 view name - teste1 I have another v…

  river1

  12 replies

  11 years, 4 months ago

  By: MMartin1

• Divide by zero error encountered.

  Hi, I am finding an error while i am dividing value. Some times Val1 is not available and some time…

  smer

  19 replies

  11 years, 4 months ago

  By: MMartin1

• How to update multiple records using LEFT and CHARINDEX

  Hi, I am an amateur with SQL and much better with ASP. I have 10,000 records in a SQL Server DB and…

  justyn 5660

  2 replies

  11 years, 4 months ago

  By: justyn 5660

• Create a table dynamically with sparse columns by select into from a stored procedure

  Hi, I want to create a table dynamically with sparse columns by selecting the records coming from a…

  arunkumarcg

  11 replies

  11 years, 4 months ago

  By: Eirikur Eiriksson