Viewing 15 posts - 4,201 through 4,215 (of 15,381 total)
CherrySqlserver (7/7/2014)
I need to update a column with AutoNumber which is depending on some other column.
the output sud be like following..
Obj1Obj2
0001ijk-000
0001ijk-000
0001ijk-000
0001ijk-000
0001ijk-000
0002ijk-001
0002ijk-001
0002ijk-001
0002ijk-001
i want to Update The column Obj2 based on the...
July 7, 2014 at 8:15 am
ramyours2003 (7/5/2014)
how to install active\active cluster in sql2008?
Have you tried google? Typing in your EXACT question returns a ton of results to articles that explain this.
July 7, 2014 at 7:44 am
ramyours2003 (7/5/2014)
after installing sql on cluster what are the different approaches to validate to check whether the clustering is working fine or not?
Given that you posted another question...
July 7, 2014 at 7:42 am
michielbijnen (7/5/2014)
I used the image shortcut with an absolute URL to my local system using syntax...
July 7, 2014 at 7:19 am
Something like this.
select m.parcel, isnull(SUM(v.Value), 0)
from @m m
left join @v v on m.parcel = v.parcel
group by m.parcel
having ISNULL(sum(v.Value), 0) = 0
order by m.parcel
July 3, 2014 at 12:32 pm
Lynn Pettis (7/3/2014)
Eugene Elutin (7/3/2014)
Yes, you could write the code so that it creates a single dynamic sql based code set that would import the data from the tables all...
July 3, 2014 at 12:12 pm
atultiwari.eng06 (7/3/2014)
select empid from consumer where empid in (2323,1236,5623)I want result would be of same order as i put in IN operator.see output
Output
empid
2323
1236
5623
Is this possible???
Not without having another column...
July 3, 2014 at 12:09 pm
cas001s (7/3/2014)
We are using a application which is used by multiple users simultaneously.Using this application,different users are going to get the information from same database...
July 3, 2014 at 11:56 am
hughesj23 (7/3/2014)
July 3, 2014 at 10:56 am
A little late to the party since Eugene already posted a workable solution. But since I came up with another way of doing this I figured I would post it....
July 3, 2014 at 10:40 am
Did you look in the error logs? It will usually have some more detailed information about what the problem is.
July 3, 2014 at 7:48 am
It might not show up in long running queries either. This is a result of a query that ran longer than the timeout that was established in the connection. The...
July 3, 2014 at 7:17 am
James Hammond (7/2/2014)
July 3, 2014 at 7:10 am
sifar786 (7/2/2014)
Also, wanted to ask you, does SQL Server handle more than 255 columns? If so, what is the limit?
July 3, 2014 at 7:02 am
ksrikanth77 (7/2/2014)
Could anyone help me on getting the below Cursor query convert to a Recursive CTE or with a while loop as I do not want to use a...
July 2, 2014 at 3:44 pm
Viewing 15 posts - 4,201 through 4,215 (of 15,381 total)