General

• Topics

  Started by

  Posts

  Last post

• How to read xml files from App.config file path?

  I have been on working windows console application to import xml data into database. I am new to co…

  iramasani 51018

  1 replies

  11 years, 9 months ago

  By: dmbaker

• Zip code --> Distance in google maps

  Hi, is there a Google SQL service where I could connect, query for two zipcodes and retrieve the di…

  si.brulotte

  6 replies

  11 years, 9 months ago

  By: newellk

• Accounting Database Design

  Hello everyone i am developing an accounts package for my company using Sql Server 2008 and VB.Net.…

  mandar.dasgupta

  2 replies

  11 years, 10 months ago

  By: dave-318819

• variable inside execute sql call

  hello i try within an exec-commands to recall a previously filled variable. usually i can merge the…

  rootsman

  5 replies

  11 years, 10 months ago

  By: John Mitchell-245523

• Timeline for learning SQL

  I was asked during a job interview about a timeline for learning SQL. I have worked with a data wa…

  sff12314

  4 replies

  11 years, 10 months ago

  By: RonKyle

• define the location of '-' in the comments

  Can anybody please help me on how to define the location of '-' in the comments? For example, I hav…

  yi.wang 12733

  3 replies

  11 years, 10 months ago

  By: yi.wang 12733

• recursive CTE in a view

  I am trying to build this view with a cte and I am getting the error msg: Msg 252, Level 16, State …

  GrassHopper

  2 replies

  11 years, 10 months ago

  By: ChrisM@Work

• Error 137 - you must declare the scalar variable

  Hi, I'm running a script against 16 registered servers (6 SQL 2000, 4 SQL 2005, 6 SQL 2008R2) withi…

  dokledon

  3 replies

  11 years, 10 months ago

  By: dokledon

• Source Control for Mixed RDMS/Dev Environment

  Greetings, After doing a search for the topic of "Source Control", I found quite a few answers that…

  N.B.

  1 replies

  11 years, 10 months ago

  By: N.B.

• SQL Query to subtract credit from Invoice Total

  Hi everyone, Basically I am building a report to calculate commissions for our sales force. We pay…

  connect

  2 replies

  11 years, 10 months ago

  By: connect

• Spliting a comma delimited parameter from Crystal

  Hi there, I'm new to SQL and to Crystal reports. I know that to pass a multiple value parameter to …

  LegoAddict

  8 replies

  11 years, 11 months ago

  By: Jeff Moden

• Trouble with date conversion

  I want to match the year field in a table and pull out all that are a year old. I'm trying to use t…

  jcobb 20350

  5 replies

  11 years, 11 months ago

  By: jcobb 20350

• If Statement in a View/Query

  Hello, I would like to create a SQL query that will make a decision based on date. For example, if…

  Meatloaf

  5 replies

  11 years, 11 months ago

  By: Meatloaf

• Trying to incorporate a Database Abstract Layer...

  I have a goal of creating a Database Abstract Layer (stored procedures and maybe views) as long ter…

  Gabriel P

  2 replies

  11 years, 11 months ago

  By: Rod at work

• Need Help on SQL query script on sum

  Hey guys, New to the site, new to writing SQL queries and have no background in this type of thing.…

  pongcs86

  9 replies

  11 years, 11 months ago

  By: batgirl