Viewing 15 posts - 136 through 150 (of 150 total)
I am looking where user either enters the loan number and gets the name of the dealership or enters the name of the dealership and gets all the loans associated...
August 31, 2015 at 3:21 pm
Is row number statement still required in the select statement?
August 25, 2015 at 4:07 pm
Thanks for the fast reply.
the current result set contains only 500 values, I don't think it would ever go higher than that. what would be the difference in the syntax...
August 25, 2015 at 3:25 pm
thanks guys..this forum is really helpful
August 21, 2015 at 1:00 pm
I am looking at my personal machine, so the path below it is pointing to be has to be the server.
C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
I know this might sound to...
August 21, 2015 at 10:14 am
I did checked the hide options and there is nothing hidden in the folder also.
August 21, 2015 at 9:51 am
Thanks, the following query gives me
C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
Is it possible that it is being referenced to the above folder but the files are somewhere else?
August 21, 2015 at 9:32 am
Thanks for all effort guys,
I am still getting an error message on the FROM, outer apply clause(Incorrect syntax near the keyword from)
OUTER APPLY (
SELECT
COUNT(*) AS FundedLastYear,
COUNT(CASE WHEN a.DateDetailDisposed <...
August 20, 2015 at 9:38 am
I apologize guys..I posted in the wrong section. I have R2 and it is giving me an error
'DATEFROMPARTS' is not a recognized built-in function name'
any other techniques to write...
August 20, 2015 at 8:08 am
Thank you so much, I will try tomorrow and see if its working, seems like you already tested it and it is working. what output are you getting?
August 18, 2015 at 6:43 pm
Viewing 15 posts - 136 through 150 (of 150 total)