Viewing 15 posts - 331 through 345 (of 1,048 total)
you must specify an ORDER BY clause with your select query with TOP...
Without specifying ORDER BY sql server will give you any random no which is not correct
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 22, 2013 at 7:21 am
ChrisM@Work (7/22/2013)
SELECT op, SUM(CASE WHEN dupes > 1 THEN 1 ELSE 0 END)FROM (
SELECT op, imei, dupes = COUNT(*)
FROM #mastertab
GROUP BY op, imei
) d
GROUP BY op
thanks Chris....
got you query...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 22, 2013 at 7:13 am
ChrisM@Work (7/22/2013)
SELECT op, SUM(CASE WHEN dupes > 1 THEN 1 ELSE 0 END)FROM (
SELECT op, imei, dupes = COUNT(*)
FROM #mastertab
GROUP BY op, imei
) d
GROUP BY op
can you please explain...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 22, 2013 at 7:02 am
Hugo Kornelis (7/22/2013)
kapil_kk (7/22/2013)
In this example after putting clustered index we will data in ascending sorted order.... while before adding clustered index data was not coming in an order...
I am...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 22, 2013 at 6:27 am
Hugo Kornelis (7/22/2013)
kapil_kk (7/22/2013)
John Mitchell-245523 (7/22/2013)
kapil_kk (7/22/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 22, 2013 at 5:55 am
John Mitchell-245523 (7/22/2013)
kapil_kk (7/22/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 22, 2013 at 5:16 am
hakan.winther (7/22/2013)
kapil_kk (7/22/2013)
PRR.DB (7/22/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 22, 2013 at 4:35 am
mahi123 (7/22/2013)
Thanks for your reply, I was try for this , but error msg was showing for that. do you have any example quer...
what error message you got?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 22, 2013 at 1:28 am
PRR.DB (7/22/2013)
Is my...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 22, 2013 at 1:15 am
you can create two foreign key constraint refering table table1 and table2 in your new table table3...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 22, 2013 at 12:58 am
Thanks Pramod for the question.....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 22, 2013 at 12:19 am
Can you please post the table strucutre with some sample data.....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 21, 2013 at 10:25 pm
You can also refer this link posted by Gail to another forum:
http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 21, 2013 at 10:12 pm
Can you please some more information to us?
Like, what is your data n tables and what output you want from that.......
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 21, 2013 at 9:56 pm
the information that you have provided here is not that much and we cant able to give you proper solution...
please provide some more details...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 20, 2013 at 3:58 am
Viewing 15 posts - 331 through 345 (of 1,048 total)