Viewing 15 posts - 241 through 255 (of 2,893 total)
Devide by 24.0
July 31, 2013 at 3:28 am
(*) Those who have worked with SQL Server for a long time, know that once there was something called "global variables", and indeed they had leading @@. But they were...
July 31, 2013 at 3:26 am
Yep, there are some alternatives. First what comes into my mind it's a CONTEXT_INFO:
July 30, 2013 at 11:34 am
Broccoli (7/30/2013)
July 30, 2013 at 11:22 am
Erland Sommarskog (7/30/2013)
T.Ashish (2013-07-29)
A view without any Index, but bound with schema.Does it gives any performance difference.
For a view, no. But for a scalar user-defined function WITH SCHEMABINDING can be...
July 30, 2013 at 2:51 am
GilaMonster (1/14/2010)
Nice set of addresses. What are we supposed to do with them?
Pay a visit to some of them. I specificaly like these two:
4935 DROUBAY DR, Las Vegas, NV 89122...
July 29, 2013 at 8:35 am
No, you will not be able to call another function inside of RAISERROR, but you can use variables in very nice way:
DECLARE @strDT VARCHAR(30) = convert(varchar(30),getdate(),126);
RAISERROR ('Now that''s what I...
July 29, 2013 at 8:30 am
Jeff Moden (7/29/2013)
Eugene Elutin (7/29/2013)
Solomon Rutzky (7/27/2013)
23847234872893475983479583749583749573945739 is all digits, is a valid number, but is NOT convertible to any SQL Server number types as it is larger than 38...
July 29, 2013 at 8:18 am
Based on provided details I can suggets you to look into ROW_NUMBER() windowed function. It will allow you to write the query you want.
If you need more detailed help,...
July 29, 2013 at 8:10 am
I would highly recommend to employ a Calendar Table for this sort of "calculations".
July 29, 2013 at 6:22 am
Solomon Rutzky (7/27/2013)
- 23847234872893475983479583749583749573945739 is all digits, is a valid number, but is NOT convertible to any SQL Server number types as it is larger than 38 digits
...
You can convert it...
July 29, 2013 at 6:20 am
Yeah I have the same error on the:
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)
Mar 29 2009 10:11:52
Copyright (c) 1988-2008 Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.1...
July 29, 2013 at 5:00 am
... Note that OUTER APPLY or CROSS APPLY seems to make no difference.
same goes for JOIN, check the third column values 🙂
WITH Tally (n) AS (
SELECT...
July 26, 2013 at 3:33 am
vignesh.ms (7/25/2013)
yes your query is very simple ..but i cant understand ..
Please explain what is cross apply ..
how dose it work in this query?
Search for "APPLY" in this BoL article:
http://msdn.microsoft.com/en-us/library/ms177634(v=sql.105).aspx
it...
July 25, 2013 at 10:47 am
vignesh.ms (7/25/2013)
yeah its working ...any other simple method ???
I thought it was quite simple... 😉
Cursor anyone?
July 25, 2013 at 10:26 am
Viewing 15 posts - 241 through 255 (of 2,893 total)