Viewing 15 posts - 1,666 through 1,680 (of 2,452 total)
;WITH jls
AS
(
SELECT ROW_NUMBER ( ) OVER ( PARTITION BY date ORDER BY date ) AS RN
, *
FROM #tmp
WHERE (seqno...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 7, 2013 at 6:15 am
kk.86manu (5/7/2013)
I am trying to delete a record from a table using a stored procedure.While executing the SP i am getting the below error.
"The query processor ran out of...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 7, 2013 at 5:09 am
if you are intending to add rows then use MERGE as Sean suggests.
If you are only intending to update data then just use UPDATE with a join on the tables.
some...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 5, 2013 at 10:56 am
play area...see if this makes any sense and can be worked upon
SELECT TOP 1000000
TranDate = Dateadd(dd, Abs(Checksum(Newid()))%Datediff(dd, '2011', '2014'), '2011'),
ProdID ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 4, 2013 at 2:10 pm
this article may help you
http://www.sqlservercentral.com/articles/IsNumeric/71512/
SELECT col,
case when col NOT LIKE '%[^0-9]%' then col else '' end,
case when col LIKE '%[^0-9]%' then col else '' end
FROM ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 4, 2013 at 12:03 pm
Motz (5/4/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 4, 2013 at 7:27 am
adonetok (5/2/2013)
Yes, I am working as programmer in Access, VB, VB.NET and SQL server for a few years. Now, need to learn DW.
assuming your company already has a data warehouse...are...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 2, 2013 at 2:15 pm
adonetok (5/2/2013)
Boss assigned me to work as data warehouse manager.I am new.
Where to start? Please recommend me some links and tools.
you say you are "new"....what previous experience have you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 2, 2013 at 2:00 pm
Hi Craig.......run on my laptop
hope this helps
kind regards
Microsoft SQL Server 2012 - 11.0.2218.0 (Intel X86)
Enterprise Evaluation Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)
TestSource ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 30, 2013 at 12:41 pm
sarwaanmca (4/29/2013)
hi Friends..i got the Result ...
Select EmpID,EmpName,Department,max(Age),MAX(salary) fromEmployeeDet
group by EmpID,EmpName,Department
Thanks for Your valuable Guidance
Regards,
Saravanan.D
consider this
create Table EmployeeDet (EmpID int,EmpName Varchar(100),Department varchar(100),Age int,salary int)
insert into EmployeeDet values (1,'Arun','Accounts',25,25000),(1,'Arun','Accounts',23,21000),(1,'Arun','Accounts',26,22000),(1,'Arun','Accounts',29,27000), (1,'Arun','Accounts',35,20000)
insert...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 29, 2013 at 1:07 pm
good link here
http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 29, 2013 at 12:47 pm
steve4134 (4/29/2013)
I believe this is saying Last day of previous month and first day of current month ? Can someone please confirm ?Steve
DATEADD(month, -1,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(GETDATE())-1),GETDATE()),101))
and
DATEADD(month, -1,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,GETDATE()))),DATEADD(mm,1,GETDATE())),101))
run...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 29, 2013 at 12:43 pm
sarwaanmca (4/29/2013)
what Ever You Take its ur wish...thats not a problem...
you take it first record of the EmpID....
ok...so what do you say is the first record for Arun?
ordered by...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 29, 2013 at 12:15 pm
sarwaanmca (4/29/2013)
I Having Table For The Following Structure..
create Table EmployeeDet (EmpID int,EmpName Varchar(100),Department varchar(100),Age int,salary int)
insert into EmployeeDet values (1,'Arun','Accounts',25,25000),(1,'Arun','Accounts',23,21000),(1,'Arun','Accounts',26,22000),(1,'Arun','Accounts',29,27000)
insert into EmployeeDet values (2,'kumar','Production',23,18000),(2,'Arun','Production',27,30000),(2,'Arun','Production',31,19000)
insert into EmployeeDet values (3,'saran','Sales',22,38000)
insert into...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 29, 2013 at 12:05 pm
Lynn Pettis (4/29/2013)
J Livingston SQL (4/29/2013)
EdVassie (4/29/2013)
If your reseller is a Microsoft Gold artner then Microsoft accept full liability for any advice they give..
Hi any pointers to official /...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 29, 2013 at 10:08 am
Viewing 15 posts - 1,666 through 1,680 (of 2,452 total)