yusufm 48726 (5/22/2015)

---

When I try to use group by company name or account number then I get the error

Column 'Company.CompanyName' is invalid in the select list because it is not...

yusufm 48726 (5/22/2015)

---

Hi,

I have got a query that I am working on but I can't get it working properly.

I am trying to group account number and company name so they...

Alessandro Andreatta (5/19/2015)

---

i think this is works

;WITH CTE AS (

SELECT

rownum = ROW_NUMBER() OVER (ORDER BY p.dt1),

p.Dt1,p.Dt2

FROM Intervalli p

)

SELECT

CTE.dt1, CTE.Dt2,

nex.dt1 Ndt1,

nex.dt2 NDt2

FROM CTE

LEFT JOIN CTE prev ON prev.rownum = CTE.rownum -...

SSRS Newbie (5/14/2015)

---

Hello All,

I've a excel spreadsheet with 650 records with unique PONumbers. I need to pull data from SQL server based on the PONumbers. I don't want to run...

this seems to be oversimplified......are your initial rows always, always formatted like you present ...or are there others?

for example

2 T & M Lambert xxx

3 Mr T, Mrs M and Miss...

tooba111 (5/13/2015)

---

Luis I really apreciate your help. I am sure I am missing something. After I running Sample Query I am getting Error "Invalid Object Name dbo.Tally"

Can You Please guide...

tooba111 (5/13/2015)

---

Sorry for the confusion.

Let me try to explain what I am trying accomplish.

Here is my source data that I am receiving from customer every day in .txt

ID,Fname,Lname,Amount,Visit

1,Smith,D,125,1

2,James,C,145,3

3,Norman,S,121,1

4,Sam,P,111,2

In above...

am a little confused on what you intend to do with your requested...

does this work?

SELECT TOP 1

...

again assuming you are on SQL 2008....search this site for Jeff Moden and his articles and code for "Quirky update"....this may help you. There are some absolute rules to...

thanks for updating your code

now...you say you have been working on this for a few days....care to share what you have tried so far?

my initial thought is some form of...

can you please provide create table statements for this data

J Livingston SQL (5/8/2015)

---

New Born DBA (5/6/2015)

---

I have this query which runs every night pulls 800,000+ records. I just wanted to know if there is a way to make it...

crowegreg (5/8/2015)

---

I've been using an Access DB that consists of a front end DB and a back end DB. I've upsized the back end to SQL.

Previously, I would import an...

for...