General

• Topics

  Started by

  Posts

  Last post

• SQL Server 2008 random generator

  Curious how it somethimes takes a long time for the obvious to sink in! The random number generato…

  dioscoredes

  1 replies

  14 years, 6 months ago

  By: Ron McCullough

• Inserting records into table does not keep the same order as inserted

  I have a single column table that I am inserting data into nightly. Once this data is in the table…

  jamey8420

  5 replies

  14 years, 6 months ago

  By: jamey8420

• Calculating Open incidents per month

  We have Incidents in our system with Start Time and Finish Time and project name (and other info) …

  hninel

  12 replies

  14 years, 6 months ago

  By: spaghettidba

• Need help with script

  I had two tables Table a table b Name VARCHAR NumericalNam…

  sql2k8

  7 replies

  14 years, 6 months ago

  By: Jeff Moden

• Query for dollars in text

  I am querying a varchar field that has textual content with numberic information. I want to query …

  GrassHopper

  3 replies

  14 years, 7 months ago

  By: Patrick_Fiedler

• Should be an easy question about escape charachters.

  I am doing a project for a client that parses the sms log of an iPhone. I have developed a program …

  sepich.eric

  2 replies

  14 years, 7 months ago

  By: nheller

• stored procedure-multiple steps

  create PROCEDURE [dbo].[CalChestSum] with recompile AS SET NOCOUNT ON begin declare @Da…

  Frances L

  3 replies

  14 years, 7 months ago

  By: Frances L

• Access F/E to SQL Server: Netherlands, Comma decimal point misunderstood for money/currency fields

  Hi All, Windows Server 2008 SQL Server 2008 Windows XP MS Access 2003 Our app has an MS Access fron…

  jkptkm

  2 replies

  14 years, 7 months ago

  By: jkptkm

• Transaction log growth

  There is a job running that does an INSERT of all rows from a view into a table. The transaction lo…

  Carol Adams

  3 replies

  14 years, 7 months ago

  By: sjimmo

• SQL Statement Insert..

  i have a table of the Following CREATE TABLE Customer (CustNo VARCHAR(6) NOT N…

  davidfoley84

  8 replies

  14 years, 7 months ago

  By: GSquared

• Code Page issues perhaps?

  Hi Folks, I have a problem with the pound striling symbol '£' in my ssis packages that produce tex…

  SALIM ALI

  1 replies

  14 years, 7 months ago

  By: SALIM ALI

• Check if table exists

  Hi i have a query as below, INSERT INTO CarnetMaster.GlassLookupCapacitySpecs …

  Vinay Theethira

  1 replies

  14 years, 7 months ago

  By: Gail Shaw

• Best way to get SQL Server 05 query results into Excel

  I have a few queries that I need to make available to non-IT end users. Need to have them input a …

  spikenology-616218

  1 replies

  14 years, 7 months ago

  By: WayneS

• numeric(7,2) with EJB3 BigDecimal ?

  Hi all: I'm writing a J2EE application with EJB3, and SqlServer 9. I'm using the Merlia JDBC drive…

  tjclifford

  1 replies

  14 years, 7 months ago

  By: tjclifford

• Builds, Deployments, Test Data, Oh My.....

  ok, So lets start by saying I've been around the block a bit, but still, as of yet, dont have what …

  GregoryAJackson

  7 replies

  14 years, 7 months ago

  By: GregoryAJackson