General

• Topics

  Started by

  Posts

  Last post

• Nested CASE statement with in operator

  Select PeriodKey, Sum(dbo_nelnet.LNLCUP) AS Balance, Case when BRQSTA in('MA','RI','CT','VT','NH') …

  gregtlaughlin

  3 replies

  13 years ago

  By: ChrisM@Work

• Eliminating rows with a change

  EDIT: Topic should have been Eliminating rows WITHOUT a change. I have the following table... DECL…

  TrippBlunschi

  8 replies

  13 years ago

  By: TrippBlunschi

• SQL data and field comparison fo two tables in differnt DB's

  ------------------------------------ ALTER procedure [dbo].[DataComparision] @Server1 varchar(50), …

  gprias

  4 replies

  13 years ago

  By: Gail Shaw

• how to find a Server .. IS Physical machine or Virtual Machine

  Is there any way to find the server is Physical machine or Virtual machine Thanks John

  John Paul-702936

  25 replies

  13 years ago

  By: Matimba

• What's wrong with this MS SQL statement?

  CREATE TABLE asdfasdf234134 (id autoincrement,firstname varchar(155),lastname varchar(155),email va…

  gabe_attoun

  7 replies

  13 years ago

  By: paul.knibbs

• concatenating the date with arabic

  i am concatenating the string , date with arabic column but string and arabic not concatenating t…

  balaji.k.ramanar

  1 replies

  13 years ago

  By: Sean Lange

• Classic asp, quotation marks and SQL SP

  I have a .asp form that uses text and textarea for input. I use SP's to update MS SQL 2005 tables.…

  steveg-941384

  15 replies

  13 years ago

  By: Sean Lange

• select distinct?

  hi all, newb here I have several records in a view that aren't duplicate records, but have matching…

  bjh47960 3345

  2 replies

  13 years ago

  By: bjh47960 3345

• Joining Columns

  I have two columns same db, different tables, one is varchar( S 12345) and the other is int (12345)…

  kbnyny

  1 replies

  13 years ago

  By: Steve Jones - SSC Editor

• Rewriting Stored Procedure from Cursor to SET-based

  I'm not a developer but am tasked with rewriting a SP to be set-based. This particular goodie takes…

  kwe477

  3 replies

  13 years ago

  By: Lynn Pettis

• Version Control Software Recommendations

  Any recommendations on a good version control software to manage our Stored Procedure changes and Q…

  mreynold

  3 replies

  13 years ago

  By: MVDBA (Mike Vessey)

• OUTPUT issue with sp_executesql

  Hi, I wonder if anyone can answer this/help. I am trying to select a blob of XML and then put this …

  lassell

  5 replies

  13 years, 1 month ago

  By: RBarryYoung

• sum, percent do able ?

  Example, I need to get all the records weekly start from last 2 Sunday 00:00:00 AM to last Saturday…

  sabercats

  9 replies

  13 years, 1 month ago

  By: sabercats

• Question about using a cursor or sql in application

  I use a dot.net application to do some import and arranging of data. there for I use some stored pr…

  w.musch

  1 replies

  13 years, 1 month ago

  By: Sean Lange

• Where between and not between?

  Hi all, How do i get a report weekly from 00:00:00 Sunday (last 2 Sunday) to 23:59:59 (last saturda…

  sabercats

  4 replies

  13 years, 1 month ago

  By: sabercats