Viewing 15 posts - 766 through 780 (of 2,894 total)
GilaMonster (12/20/2012)
... My suggestion, start using it now, then there will be less code to change in 10, 15 or more years time when (if) the ; finally becomes mandatory.
Or...
December 20, 2012 at 8:01 am
...
And consider the following selects
select Col4 from Indexing2
inner join Indexing
on Indexing2.Col4 = Indexing.Col2
where Col4 between '200' and '250'
select Col4 from Indexing2
where exists (select * from Indexing where Indexing.Col2 =...
December 19, 2012 at 8:15 am
... you were just ahead of your time.
Yeah, I'm always! But "they" don't understand me.
That is common among us, great painters... :crying:
¦¦¦¦¦¦¦¦¦¦¦¦¦
...
December 18, 2012 at 8:42 am
To SELKO:
GSquared (12/18/2012)
So your point doesn't actually prove your point, if you get my point. 😀
On the other hand, code portability has certainly worked out well for you. You...
December 18, 2012 at 8:08 am
CELKO (12/17/2012)
IDENTITY has a very important place in RDBMS and especially in SQL Server. It's very often the best candidate for a surrogate PK.
You might want to actually read...
December 18, 2012 at 2:59 am
krishp (12/14/2012)
Given any random data string, is there a way to know the collation of the string? I guess more than one may apply and that is okay too....
December 17, 2012 at 10:08 am
OP requirements very obscure.
What should happen if there is another group of data with different FacilityId:
INSERT [dbo].[Mas_Shift] ([ShiftId], [FacilityId], [ShiftType], [Shift]) VALUES (7, 2, N'3', N'A')
INSERT [dbo].[Mas_Shift] ([ShiftId], [FacilityId],...
December 17, 2012 at 9:26 am
CELKO (12/14/2012)
December 17, 2012 at 9:19 am
CELKO (12/14/2012)
.. Total failure.. Besides which, I believe my earlier post
Yeah, it was awful! :crazy:
What I wanted to do was avoid the CASE expression solution and go for...
December 17, 2012 at 7:34 am
Jeff Moden (12/15/2012)
Eugene Elutin (12/11/2012)
....
SELECT AA.*
FROM @T AA,
@T_INPUT BB
WHERE...
December 16, 2012 at 8:37 am
What about weekends and public holidays? Should they restart your counter?
December 12, 2012 at 4:17 am
Exactly as I thought - it's really hard to overdo the real master of "outburst"... :hehe:
December 12, 2012 at 2:53 am
Phil Parkin (12/11/2012)
Eugene Elutin (12/11/2012)
Here I will play J.CELKO: ......
Steady on, don't overdo it :hehe:
I hope I didn't, as I have not complained about lack of PK and didn't state...
December 11, 2012 at 10:41 am
....
SELECT AA.*
FROM @T AA,
@T_INPUT BB
WHERE AA.NAME=BB.NAME
ORDER BY BB.ID
Here I...
December 11, 2012 at 10:29 am
olivia.forde (12/11/2012)
GilaMontser - so the way I have it is the most efficient - it takes hours to run so I was hoping it could be improved.
Could you please post...
December 11, 2012 at 9:31 am
Viewing 15 posts - 766 through 780 (of 2,894 total)