Viewing 15 posts - 421 through 435 (of 2,894 total)
GilaMonster (5/16/2013)
RedBirdOBX (5/16/2013)
Thoughts?The developers were smoking something.
... smoking something from Amsterdam and drinking strong clear thing from Eastern lands of Europe...
:hehe:
May 16, 2013 at 8:45 am
su88rao (5/16/2013)
P1nvarchar(255)Checked
S1nvarchar(255)Checked
B1nvarchar(255)Checked
H1 -b1intChecked
H1 -s1intChecked
S2 -b1intChecked
S2 -s1intChecked
J1 -b1intChecked
J1 -s1intChecked
and this is for table 2 i,e t2
P1nvarchar(50)Checked
S1nvarchar(50)Checked
B1nvarchar(50)Checked
Funnvarchar(50)Checked
Valint Checked
Locnvarchar(50)Checked
and i...
May 16, 2013 at 6:13 am
Yes, you can. In another column:
SELECT CASE
WHEN CARS.Model LIKE '%Ford%'...
May 16, 2013 at 5:55 am
philip.davy (5/16/2013)
selectList_,
Description,
count(month(TimeClicked)) as MonthTimeClicked
from clicktracking_ with (nolock)
inner join members_ on clicktracking_.MemberID_ = Members_.MemberID_
inner join lyrLookupCompletionStatus on lyrCompletedRecips.CompletionStatusID = lyrLookupCompletionStatus.CompletionStatusID
group by
List_,
Description
Query you posted refers to the table with name...
May 16, 2013 at 5:47 am
Have you read the article http://www.sqlservercentral.com/articles/Best+Practices/61537/?
Post DDL of your tables, sample data insert script and expected results based on these data. Nothing more.
May 16, 2013 at 5:44 am
su88rao (5/16/2013)
anna tande.... give me d query.. i dnt want nethng else frm u
I don't think that will get you too far here...
May 16, 2013 at 5:23 am
You don't need to post the same question into three different threads.
i have 2 tables
one call it as dbo.t1 and another dbo.t2
t1:
P1 S1 B1 H1 S2 J1
______________________________
b1 s1 b1...
May 16, 2013 at 5:21 am
There is no need to duplicate post.
All replies better to go to original one:
http://www.sqlservercentral.com/Forums/Topic1453408-391-1.aspx
May 16, 2013 at 5:17 am
There is no need to duplicate post.
All replies better to go to original one:
http://www.sqlservercentral.com/Forums/Topic1453408-391-1.aspx
May 16, 2013 at 5:16 am
philip.davy (5/16/2013)
HiWhen runing queries I keep geting the above error.
Does anyone know how to resolve this pls?
thanks
Can you post the code you are running?
Somewhere in this code you are...
May 16, 2013 at 4:42 am
Hi and welcome to the forum.
Unfortunately it's too unclear requirements and details.
Could you please read "forum etiquette" article in this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
If you provide details as per above I'm...
May 16, 2013 at 4:39 am
TJT (5/15/2013)
DECLARE @test-2 AS VARCHAR(90)
SET @test-2 = '2003 OR Cars.year = 2004 OR Cars.year = 2004'
SELECT Cars.year
FROM...
May 15, 2013 at 8:37 am
Something tells me that CROSS APPLY (with index seek on FK_StationId (I guess it's indexed in real life)) will be quite faster than using second windowed function which would cause...
May 15, 2013 at 6:40 am
First of all, it will be more helpful if you would supply your sample data in a runable/executable way, something like this:
...
May 15, 2013 at 6:29 am
Viewing 15 posts - 421 through 435 (of 2,894 total)