Viewing 15 posts - 1,531 through 1,545 (of 2,452 total)
domingo.sqlservercentral (3/26/2014)
2014-03-25 12:31:00.000StationIDAnnie LennoxDave StewartEurythmicsDave StewartEMI1IDshortinfo
2014-03-25 13:33:00.000TrafficBob Dylan, Louis ArmstrongPaul McCartney, Bob DylanGlenn Miller, Pet Shop BoysWarner2TRAFFICshortinfo
2014-03-25 14:38:00.000CarpetPaul McCartney, Bob Dylan, Mike...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 4, 2014 at 2:44 pm
Sean Lange (4/4/2014)
domingo.sqlservercentral (4/4/2014)
... and? Please...
Well you gave us a bunch of data and said "here is my results". Results of what? Presumably a query.
The problem is that...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 4, 2014 at 12:32 pm
jrp12 (4/3/2014)
Hello DBA'sjust wondering who is managing maximum number of Databases?
PLEASE REPLY
Thank You
what is your definition of "managing".....??
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 3, 2014 at 3:48 pm
Briceston (3/24/2014)
Thanks for the replies guys, however, I had figured out the answer shortly after my post. My apologizes for not updating the thread.
Glad to hear you solved the issue.
for...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 24, 2014 at 12:09 pm
have you looked at the T-SQL CASE statement....this may provide what you require
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 23, 2014 at 1:49 pm
would help if you could provide DDL...(do you know how to do this?.....create table statement / insert data statement)
what is the significance of the "TYPE" code...you provide "A","B","P"...does this mean...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 23, 2014 at 10:27 am
are your billed amounts and payment amounts/adjustments in separate tables?
can you provide more details on the table structure (DDL create statememts)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 23, 2014 at 9:05 am
ivar_SQL (3/23/2014)
Here Michael has total 26 Business points for his total trips and based on that he should get 6 promotional points for the first 20...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 23, 2014 at 7:47 am
a proof of concept on 1 million rows of test data
USE [tempdb]
GO
/*Drop and Create a test table */
IF OBJECT_ID('tempdb..tblRedeems_TST', 'U') IS NOT NULL ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 23, 2014 at 7:11 am
ivar_SQL (3/23/2014)
I am working on a rewards program and I have a table whenever customer completes a trip, his total fare,business points earned for that particular trip and respective...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 23, 2014 at 6:29 am
for clarification...are you asking for an update on business/promo points on the entire table or are you expecting that points will be automatically calculated on a new row being...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 23, 2014 at 4:59 am
food for thought.......note index
SELECT TOP 5000000
TranID = IDENTITY(INT, 1, 1)
INTO Table1
FROM ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 18, 2014 at 1:44 pm
sample data would help us help you....do you know how to provide this?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 17, 2014 at 9:22 am
SELECT house_no
FROM <yourtable>
ORDER BY REPLACE(house_no, '-', '')
you have asked this question numerous times......can you please explain why the solutions provided have...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 15, 2014 at 10:20 am
have we been here before ???
http://www.sqlservercentral.com/Forums/Topic1520462-3077-1.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 15, 2014 at 9:09 am
Viewing 15 posts - 1,531 through 1,545 (of 2,452 total)