Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Flattening many records into one
mflancour, many thanks, followed your guide, and with a bit of googling got it sorted. Am very pleased .... thanks for your help. jp- jp777
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Flattening many records into one
ok, table description as above 4 sample records '3562134' '20-01-2007 15:23:07' 99 'N' '3562134' '20-01-2007 15:24:10' 101 'N' '3562134' '20-01-2007 15:28:33' 103 'N' '3562166' '20-01-2007 15:28:33' 140 'N' desired output for these records 3562134 103 15:28:33 101 15:24:10 99 15:23:07...- jp777
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Flattening many records into one
I have a table as below product char(10) date datetime points integer(9) flag char(1) my requirement is to show the last (by date) 10 points (with dates) on one line, for all products example product points date points date points date (for 10) product2 points date...- jp777
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
-
SQL Hope you can help
Alex / Zathras, now I pretty much have this sql performing how I want it, I am attempting another one. Same Table as above; product char(10) date datetime points integer(9) flag char(1) but the requirement is now to show the last (by date) 10 points (with dates) on one... -
SQL Hope you can help
I must have cocked up somewhere. I'm reading into a dataset then into a datagrid, and have somehow changed something thats forcing the datetime into a date format. Its a stored procedure I'm running, which when I run the sql from in a sql session works fine, but is not in the application... -
SQL Hope you can help
Alex, Thanks, this works well. I am running on SQL Server, and calling through a C# windows application. Interestingly, when I run this in a sql query screen and select * then I get the field date passed back as datetime (which it is), but when run as a script the select * returns the... -
-
SQL Hope you can help
Zathra, struggling to get yours going, I have many records in one day (differing times), and I think yours is presuming one record per day. AlexCuse, yours is fine except it only flags the latest record, not both. I will play with both, and then decide which to use. Thanks again for... -
SQL Hope you can help
Thanks for the replies guys, I'll try them both tomorrow and let you know how it goes. Thanks for your time. -
SQL Hope you can help
Hi, I have a table; product char(10) date datetime points integer(9) flag char(1) I want to read the latest (by date) 2 records for each product and add a flag to each if the points value has changed. To be honest I don't have much sql and am completely stuck Thanks for...
