SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• GeoCode with Bing Using an SP/Function

  Does anyone have or know of a SP/Function for using MS Bing to bulk geocode a table of addresses? …

  shane.barney-793593

  1 replies

  14 years, 10 months ago

  By: Brandie Tarvin

• HELP IN MODIFYING STORED PROCS

  Hi, i have a requirement where i need to delete some columns in a table ,i need to identify differ…

  sqldobki

  3 replies

  14 years, 10 months ago

  By: Brandie Tarvin

• Profiler user defined template location

  Does anyone know where the user defined templates are stored? Apparently not with the shipped temp…

  GreyBeard

  2 replies

  14 years, 10 months ago

  By: GreyBeard

• Connect to multi db's and servers

  Hi, We have several databases within a main db server (MainServer). We also have two other (for now…

  Michael Lee-158245

  4 replies

  14 years, 10 months ago

  By: Michael Lee-158245

• Averaging based on a condition TSQL

  CREATE TABLE #TblTemp( IdINT, Price DECIMAL(18,9)) INSERT INTO #TblTemp…

  work.dev

  4 replies

  14 years, 10 months ago

  By: work.dev

• Trigger doesnt work when using sp_executesql

  Hi I have a .net application that uses sp_excutesql to insert and update posts in my db. I also ha…

  Andreas Håkansson

  4 replies

  14 years, 10 months ago

  By: Lowell

• sqlserver 2000 to 2008

  Hi friends, I have a plan to upgrade my DB's from sql2000 to 2008, but i don't know what will happe…

  ashkan sirous

  4 replies

  14 years, 10 months ago

  By: Johan Bijnens

• Changing status of db to OFFLINE

  Can someone help me with the tsql on this? i created a test table and want to set the status to OFF…

  rmatthias001

  3 replies

  14 years, 10 months ago

  By: rmatthias001

• Many to Many relationship amoung lookup tables?

  I'm developing a multi-page web application (ASP.NET 3.5, Visual Studio 2008, VB 2008). I plan to d…

  Tracy.Smith 3816

  3 replies

  14 years, 10 months ago

  By: GSquared

• Urgent help needed to convert 100 rows into 100 columns

  Hi all I am new to SQL SERVER. Please help me how to write a cursor/ procedure to convert rows into…

  thejask08

  6 replies

  14 years, 10 months ago

  By: thejask08

• Calling a Stored Procedure inside a stored procedure

  I would like to call and execute a stored procedure (Stored Procedure A)inside another stored proce…

  Marv_SQL

  21 replies

  14 years, 10 months ago

  By: Jeff Moden

• Help - find values in table 1 NOT in table2

  Please help. I'm a newbie at this and I know this should be easy (and probably is). I have two tabl…

  ibanez59

  7 replies

  14 years, 11 months ago

  By: ibanez59

• how can I join 2 tables into a new table

  I would like to take 2 tables and join them both tables are exactly the same except for the file na…

  Larry Coe

  9 replies

  14 years, 11 months ago

  By: nigel.

• Affected tables in DB

  Hello all, I am dealing with database migration, but i don't have the source code for the new appli…

  MpriorJ

  7 replies

  14 years, 11 months ago

  By: Grant Fritchey

• Help Selecting Records

  I have a table that contains the following fields: - Date SalesPerson OrderReference OrderStatus Wh…

  bdgjcd

  5 replies

  14 years, 11 months ago

  By: nigel.