SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Converting a MySQL query

  Hi Guys I'm new to SQL Server 2000 and am trying to convert some of my php code that previously us…

  Lucas Young

  1 replies

  20 years, 5 months ago

  By: Frank Kalis

• GetDate ?

  Hi all, I seem to be experiencing problems with a view i've written in SQL server. I have put this …

  Mitch-157840

  8 replies

  20 years, 5 months ago

  By: PhilPacha

• Using SQL to CONVERT an int with Thousand Seperator!

  I need some assistance with this SQL statement: SELECT (CONVERT(varchar, CAST(SUM(S526960.tappMonth…

  Salvatore Conti Jr.

  7 replies

  20 years, 5 months ago

  By: rschaeferhig

• reading transaction logs

  Now I thought this wouldn't be so difficult or require a thousand dollar add-in.  How does one…

  Jolyn Prater

  2 replies

  20 years, 5 months ago

  By: Greg Charles

• Importing Data Automatically AND Run SQL task too

  Hi all, I am a complete newbie to this and thus have no idea what i am doing. This is the problema…

  Connor Brannigan

  5 replies

  20 years, 5 months ago

  By: Russell Woodham

• BCP datafile load in specific table columns

  Hi All I have this little holdup at BCP data file load in specific table columns andit is like…

  SQLIndia

  3 replies

  20 years, 5 months ago

  By: SQLIndia

• Update using multiple columns

  I want to update 2 columns the table OPT_SalesForecastDetail using the following  SET  de…

  Sanjay Masawan

  1 replies

  20 years, 5 months ago

  By: Kathi Kellenberger

• Deadline Tomorrow - Limiting the zero value in averaging a row of data

  I need to average a row of data, while checking for zero values, however, I only want to eliminate …

  kfschaefer

  7 replies

  20 years, 5 months ago

  By: Bob Monahon

• sql returning no records when search field left blank

  building a real-estate search page and one field is "schools" when the scools field is left blank m…

  travis vanstaaveren

  7 replies

  20 years, 5 months ago

  By: Phil Parkin

• Duplicates in import file

  I'm trying to use Bulk Insert or the DTS import wizard to import 7 million records into a new table…

  Becky Beavers

  6 replies

  20 years, 5 months ago

  By: Becky Beavers

• This should be a simple update statement (I think!)

  Hi, I feel like this should be fairly simple but I just can't seem to get it! I basically want to u…

  sharon macdonald

  4 replies

  20 years, 5 months ago

  By: Thomas F. Maloney-197390

• Avoiding row deletion with a trigger

  Hi everybody, I'm moving from Borland Interbase and I'm a newby in SQL Server. I have a table with…

  João Miguel Domingos

  2 replies

  20 years, 5 months ago

  By: João Miguel Domingos

• Stored Procedure :: Multiple Users

  A developer has created a stored procedure that runs a query across mulitple databases, currently t…

  MB5919

  3 replies

  20 years, 5 months ago

  By: Jeff Moden

• Best way to get next "Quote#"

  Hi, Iam converting an old in-house Indexed flat file system to .net & SQL. Ive got a lot of it …

  Charlie Whitcraft

  1 replies

  20 years, 5 months ago

  By: Accent Care

• Listing of tables using extended properties

  How can I extract a list of tables from a database that have specific values in an extended propert…

  dean gross

  2 replies

  20 years, 5 months ago

  By: jarretg