SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Two results

  I am looking to see the count of IDS, for both the sub categories separately . But don't know how t…

  sharonsql2013

  7 replies

  11 years, 10 months ago

  By: rho_pooka

• How do I get data for last 13 months grouped by Month

  Hi, I am very new to MDX. I have a cube and I am creating a SSRS report. The requirement I have…

  NickAsh

  1 replies

  11 years, 10 months ago

  By: Luis Cazares

• Returning multiple records when only one is specified

  Hi, can someone please explain something to me. SET @NAMEID = '14359' IF @ADR2 IS NULL AND @ADR3 IS…

  crazy_new

  22 replies

  11 years, 10 months ago

  By: crazy_new

• Access 2010 and MS SQL Server 08 r2

  So I am working on automating a LOT of programs that are currently stored in access db's. I want to…

  sl01

  4 replies

  11 years, 10 months ago

  By: pietlinden

• FINDING THE DATE WHICH IS NEAREST TO CURRENT DATE

  i need to find the date from a column , which is less than and is nearest to the current date .?? a…

  aeri_q

  7 replies

  11 years, 10 months ago

  By: barsuk

• Remove special characters from String

  Hi, When I run a select statement the output I get is: ;#Bank;# ;#Finance;# ;#Cash;# How to remove …

  sql_ques

  4 replies

  11 years, 10 months ago

  By: ChrisM@Work

• materialized view right course for a datamining query with 7 joins?

  I have a query that has 7 joins and aggregates data and runs daily. It takes about 2 minutes to ru…

  polkadot

  2 replies

  11 years, 10 months ago

  By: ChrisM@home

• FINDING THE DATE WHICH IS NEAREST TO CURRENT DATE

  i need to find the date from a column , which is less than and is nearest to the current date .?? a…

  aeri_q

  2 replies

  11 years, 10 months ago

  By: pietlinden

• OR Designer cannot show picture from image field

  Hi, all: I tried data binding using linq to sql (OR Designer) by drag-drop from AdventureWorkDW2012…

  arayametee

  2 replies

  11 years, 10 months ago

  By: arayametee

• Adding read only user issue

  I'm adding a new user to a sql server instance (SQL Server 2008 R2 standard edition). Added a new …

  jralston88

  2 replies

  11 years, 10 months ago

  By: Ed Wagner

• Get data from field in a previous record

  I am trying to add a field to a view that actually contains data from the record previous to the on…

  aberndt

  10 replies

  11 years, 10 months ago

  By: aberndt

• Clustered Index needed for Time lookup table?

  Hi, I've got a Time look up table that has one column whose values are the datetime stamp for every…

  polkadot

  7 replies

  11 years, 10 months ago

  By: Evil Kraig F

• Trigger

  Hi, Can anyone please help my with the following trigger. ALTER TRIGGER [dbo].[PAT_2_AJS] ON [dbo].…

  crazy_new

  22 replies

  11 years, 10 months ago

  By: Greg Edwards-268690

• Left join with "soft" condition

  Hello everybody, I need to join two tables based on patient ID and dates.The first table has the pa…

  lindaman2

  4 replies

  11 years, 10 months ago

  By: lindaman2

• Referral Dates Nightmare

  Hello Guys, I am somewhat new to SQL. I really need some help with the following query. I have thre…

  jsayerweb

  16 replies

  11 years, 10 months ago

  By: ChrisM@Work