Viewing 15 posts - 2,071 through 2,085 (of 2,452 total)
any good....
SELECT TOP (3) WITH TIES *
FROM ClientRequests
ORDER BY Requests DESC
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 18, 2012 at 5:55 am
hmm... Oracle maybe??
http://stackoverflow.com/questions/278189/oracle-string-concatenation-operator
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 17, 2012 at 12:52 pm
- At end of the survey, a tally is needed to show a breakdown of how the questions are answered.
TABLE: ANSWERS
AnswerId int Primary Key
Answers nvarchar(2000)
with a nvarchar answer...how do you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 15, 2012 at 2:10 pm
OK...so are you able to provide the "create table" script please.?
we will then know what datatypes we are dealing with.
good luck
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 15, 2012 at 10:32 am
does this work for you
SELECT cast(MEMBER_ACCT.mbr_1st_nam as varchar(50)) +' ' + cast(MEMBER_ACCT.mbr_lst_nam as varchar(50))AS FullName
FROM MEMBER_ACCT
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 15, 2012 at 9:41 am
In SSMS....find your table...right click...script table as....create to...new query window
copy and paste results here
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 15, 2012 at 9:19 am
Please provide create script for table MEMBER_ACCT and some representative data.
should be easy to solve then
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 15, 2012 at 9:04 am
note...7 year old thread
🙂
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 13, 2012 at 10:00 am
The total would be 4 codes......
and they are...???
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 10, 2012 at 2:41 pm
here's a post that may give some ideas (J Moden)
http://www.sqlservercentral.com/Forums/Topic1220939-391-1.aspx#bm1223418
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 10, 2012 at 11:44 am
does this help?
http://www.sqlservercentral.com/scripts/T-SQL/67149/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 9, 2012 at 7:55 am
SQL Kiwi (1/8/2012)
J Livingston SQL (1/8/2012)
....some initial tests on a test server had the update run in 17 secs with "new" QU..."old" QU takes 64 secs.
Well yes, but I do...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 8, 2012 at 7:15 am
ChrisM@home (1/8/2012)
Jeff Moden (1/7/2012)
Absolutely incredible, Paul. Great bit of research...
No kidding. What Paul's modestly neglected to mention is the 5-fold performance lift provided by removing the table spool from...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 8, 2012 at 6:20 am
Jeff Moden (1/7/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 8, 2012 at 1:59 am
as I spawned this thread...thought it only polite to report back
based on my pc (with the memory of a toaster) .......
using traceflag 652=ON.....works every time
using WITH (INDEX(0)) in the cte...works...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 7, 2012 at 11:59 am
Viewing 15 posts - 2,071 through 2,085 (of 2,452 total)