Viewing 15 posts - 1,231 through 1,245 (of 2,452 total)
yusufm 48726 (5/22/2015)
Column 'Company.CompanyName' is invalid in the select list because it is not...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 22, 2015 at 4:15 am
yusufm 48726 (5/22/2015)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 22, 2015 at 4:08 am
Alessandro Andreatta (5/19/2015)
;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 -...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 19, 2015 at 7:35 am
SSRS Newbie (5/14/2015)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 14, 2015 at 10:05 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 14, 2015 at 3:40 am
tooba111 (5/13/2015)
Can You Please guide...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 13, 2015 at 11:36 am
tooba111 (5/13/2015)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 13, 2015 at 10:55 am
Second row should be without Amount (4,Sam,P,,2) Because we don't want to calculate the same amount twice.
am a little confused on what you intend to do with your requested...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 13, 2015 at 10:42 am
sonu_mhl (5/11/2015)
HiI have below data & i want record with value 6 & 2013 should be returned. Both the fields are numeric
U_MonthU_Year
122012
12013
22013
32013
42013
52013
62013
Thanks
does this work?
SELECT TOP 1
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 11, 2015 at 9:25 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 10, 2015 at 6:59 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 9, 2015 at 8:37 am
can you please provide create table statements for this data
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 9, 2015 at 8:24 am
J Livingston SQL (5/8/2015)
New Born DBA (5/6/2015)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 8, 2015 at 10:43 am
crowegreg (5/8/2015)
Previously, I would import an...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 8, 2015 at 10:28 am
crowegreg (5/8/2015)
Thanks for the reply.I should have written I'm importing Excel spreadsheets on a weekly and monthly basis. I'm hoping their is some other way than using SQL import/Export wizard.
for...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 8, 2015 at 10:20 am
Viewing 15 posts - 1,231 through 1,245 (of 2,452 total)