Viewing 15 posts - 1,666 through 1,680 (of 8,731 total)
skmoh2 (1/10/2017)
Table1
--------
PeggingSKU QTY RDD ComponentAvilable QtyAvlbl Dte Material Available Date
SO1 ...
January 10, 2017 at 6:59 am
Maybe something like this:
SELECT *,
DATEADD(HH, DATEDIFF(HH, '2017', TestDate), '2017') PartitionUsed,
DENSE_RANK() OVER(ORDER BY DATEADD(HH, DATEDIFF(HH, '2017', TestDate), '2017')) RN
FROM @Sample;
January 9, 2017 at 12:04 pm
2008 and 2008R2 are two different products. Each of them have different releases and version numbers. They're very similar, but are different enough not to have been considered a Service...
January 9, 2017 at 10:52 am
How about making this a persisted computed column using a UDF?
January 9, 2017 at 10:27 am
Ed Wagner (1/9/2017)
whereisSQL? (1/9/2017)
aPed001 (1/9/2017)
Manic Star (1/9/2017)
eccentricDBA (1/9/2017)
Ed Wagner (1/9/2017)
DamianC (1/9/2017)
Ed Wagner (1/9/2017)
Ray K (1/6/2017)
Manic Star (1/4/2017)
ZZartin (1/4/2017)
Terminator(I'll Be) back
front
Assault
rifle
Range
Home (on the Range)
Deer
Hunter
Hunted
Dinner
Served
January 9, 2017 at 9:55 am
drew.allen (1/9/2017)
CELKO (1/7/2017)
I see absolutely no benefit to having this as a check constraint rather than as a foreign key constraint.
The check constraint can be used by the optimizer immediately;...
January 9, 2017 at 9:53 am
ChrisM@Work (1/9/2017)
Or build a cross-tab into an APPLY block:
I usually avoid APPLY with correlated suubqueries because it tends to run the query row by row. Obviously, this is a general...
January 9, 2017 at 9:40 am
mishrakanchan86 (1/9/2017)
I have a view which looks something like below.
Select
* from T1 with(NoLock)
Inner Hash Join T2 With (NoLck) on T1.PID = T2.PID
Inner Hash Join...
January 9, 2017 at 8:47 am
Jeff Moden (1/9/2017)
Ed Wagner (1/9/2017)
I've already voted for it as well. As of now, it's 244 to 5.
You just have to wonder what was on the mind of the...
January 9, 2017 at 7:32 am
Why do you want to use one specific version? Both can connect to any version.
If possible, you should remove those SSMS versions and install SSMS 16.5 which is the latest...
January 6, 2017 at 12:56 pm
Something like this?
SELECT
pr.Title AS ProjectRoot , pr.ID AS ParentID,
wf.Title AS WorkFlow , wf.ID AS WorkflowID,
...
January 6, 2017 at 12:53 pm
Here's an option that you might want to consider. First, it removes unnecessary characters and changes the delimiters into something that shouldn't be part of your string. Then it uses...
January 6, 2017 at 8:14 am
anjaliagarwal5 (1/5/2017)
I am trying to create a local Instance. When I issue a command ssms.exe from the below directory. It always starts SQL server 2008 which is also installed...
January 5, 2017 at 1:14 pm
mikevessey (1/5/2017)
simply use the CREATE TYPE statement (to create a table type), then create your proc using the table type...
January 5, 2017 at 12:56 pm
Viewing 15 posts - 1,666 through 1,680 (of 8,731 total)