SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• DATE Comparison in HAVING Clause

  I am getting incorrect results while trying to get the all dates less than the current date The que…

  honey47

  3 replies

  14 years, 9 months ago

  By: honey47

• Oracle provider not found

  Hi friends, I'm creating Linked server to Oracle. I installed Oracle client 10g and set up ODBC c…

  newbieuser

  1 replies

  14 years, 9 months ago

  By: newbieuser

• Try to build a SQL error string, but

  DECLARE @Desc VARCHAR(5000) BEGIN TRY -- Generate a divide-by-zero error. SELECT 1/0; END T…

  Digs

  4 replies

  14 years, 9 months ago

  By: Ken McKelvey

• Last Day of any Month

  Hi Folks, How to get the Last Day of any month, .bUT FOR EVERY MONTH I SHOULD GETLast DAY EXAMPLE;…

  lefrancisco1

  20 replies

  14 years, 9 months ago

  By: dfine

• How can I get this selection in one TSQL run ?

  IF OBJECT_ID('tempdb..#Data') IS NOT NULL DROP TABLE #Data; create table #Data([ID] [Int],[Sub][Int…

  Digs

  13 replies

  14 years, 9 months ago

  By: Jeff Moden

• Quirky Update TSQL skill required on this calc

  Some data for you IF OBJECT_ID('tempdb..#priceData') IS NOT NULL DROP TABLE #priceData; create tab…

  Digs

  3 replies

  14 years, 9 months ago

  By: Jeff Moden

• Number of Records affected

  Is there a way that in SSMS query window I can determine how many records are effected by an update…

  jayoub

  5 replies

  14 years, 9 months ago

  By: Lamprey13

• Cross Tab with nvarchar()

  Hello, I'm wondering if it is possible to make a cross tab query with the data mentioned below. It …

  r_slot

  3 replies

  14 years, 9 months ago

  By: r_slot

• SQL Upgrade 2000 to 2008

  Hi Guys Has anyone done a database upgrade from 2000 to 2008. Im planning to upgrade to 2005 but I…

  youngoz

  13 replies

  14 years, 9 months ago

  By: Nadrek

• How to run 2 queries every month

  I am a Newbi DBA and I manage a db that requires that i run two update queries around the first of …

  jayoub

  9 replies

  14 years, 9 months ago

  By: gkerscher

• Parse text in a string

  I have a column with these values The Website is mysite1.com because it is my site. The Website is …

  Black Mamba

  13 replies

  14 years, 9 months ago

  By: Jeff Moden

• sqldumper.exe

  Hi all I'm trying to execute a package. While executing the package SQLDumper.exe pop up comes and …

  kevin4u06

  1 replies

  14 years, 9 months ago

  By: anand_vanam

• get Data previous on the same row for 4 previous columns

  IF OBJECT_ID('tempdb..#priceData') IS NOT NULL DROP TABLE #priceData; create table #priceData(quote…

  Digs

  4 replies

  14 years, 9 months ago

  By: Digs

• replicating records w/o using a cursor

  I have a project where I need to create multiple records out of the same data (exact duplicates) ba…

  josh.wayne

  4 replies

  14 years, 9 months ago

  By: ChrisM@Work

• How to not show duplicates?

  Hi, I have the following: ID Name Email ----------------------- …

  KS-321165

  5 replies

  14 years, 9 months ago

  By: mberry