Viewing 15 posts - 7,081 through 7,095 (of 15,381 total)
I use FF myself and have no issues. I suspect it related to your cookies. Maybe you need to clear your cookies as that is what SSC uses to keep...
August 21, 2013 at 8:01 am
I don't think you can do that in Access. If you are using an autonumber why does it matter if there is a gap anyway? This is perfectly normal because...
August 21, 2013 at 7:58 am
imran.adam (8/21/2013)
It basically gives each record a unique numbersee this http://technet.microsoft.com/en-us/library/ms186734.aspx
That is the correct link but your description is incorrect.
Using PARTITION in the context of ROW_NUMBER divides the rows...
August 21, 2013 at 7:49 am
SABARISH JAGANATHAN (8/21/2013)
hi,kindly could you able tell me the answer's for those question's
Try reading all the comments. Most of them have no correct answer.
August 21, 2013 at 7:42 am
Your question is very unclear. We would like to help but you have to first provide enough details for us to be able to help. The best thing you can...
August 21, 2013 at 7:36 am
Thank you for posting ddl and sample in an easy to use format. You can use STUFF for this.
select col1,
STUFF((select ',' + col2
from t t2
where t2.col1 = t1.col1 and t2.col3...
August 20, 2013 at 12:03 pm
sharonsql2013 (8/20/2013)
For Quick reference of queries
Really not clear what you mean. Do you mean some way to easily view the code? There is a folder in SSMS named Views. Just...
August 20, 2013 at 11:58 am
In order to help we will need a few things:
1. Sample DDL in the form of CREATE TABLE statements
2. Sample data in the form of INSERT INTO statements
3. Expected results...
August 20, 2013 at 9:54 am
GilaMonster (8/20/2013)
Sean Lange (8/20/2013)
GilaMonster (8/20/2013)
A CTE however, despite its name, is not a table and hence can not have anything inserted into it.
Acutally you can insert into a cte, just...
August 20, 2013 at 9:29 am
GilaMonster (8/20/2013)
A CTE however, despite its name, is not a table and hence can not have anything inserted into it.
Acutally you can insert into a cte, just like you can...
August 20, 2013 at 9:22 am
Nope you don't need a loop for this at all. You will need a tally table. If you can post ddl and some sample data I will be happy to...
August 20, 2013 at 7:48 am
praveen_vejandla (8/20/2013)
August 20, 2013 at 7:36 am
Since the pseudocode doesn't work I assume that means you need or at least want some additional help? You have been around here long enough to know that the next...
August 19, 2013 at 2:33 pm
Do you want the multiple values shoved into a single column? You can use STUFF to do that. If you could post up some ddl and sample data as create...
August 19, 2013 at 2:31 pm
ncurran217 (8/19/2013)
Figured it out.
Glad you figured it out. Remember that when you post it isn't like we want to see all the columns to be annoying. We don't need the...
August 19, 2013 at 2:10 pm
Viewing 15 posts - 7,081 through 7,095 (of 15,381 total)