Viewing 15 posts - 8,206 through 8,220 (of 15,381 total)
SQLRNNR (5/28/2013)
Steve Jones - SSC Editor (5/28/2013)
Brandie Tarvin (5/28/2013)
Cadavre (5/28/2013)
Why can't you just do an IPConfig?
Because until Greg gave me the keystrokes I needed, I couldn't get to a command...
May 28, 2013 at 9:43 am
keshava.murthy (5/28/2013)
If I use like above suggestion then I will not get the sum which is grouped by the month
Did you actually try it? It is grouped by MONTH(starttime). Not...
May 28, 2013 at 9:36 am
pooya1072 (5/28/2013)
i want to add a column to a table with conditions below :
1- it has a default value=0
2- this column can get null value
3- no constraint should be...
May 28, 2013 at 9:16 am
keshava.murthy (5/28/2013)
select right(convert(varchar, CCD.startDateTime , 106), 8) as startmonth,
sum(case when CCD.contactDisposition = 1 then 1 else 0 end) as TotalCalls1,
sum(case when...
May 28, 2013 at 9:14 am
TJT (5/28/2013)
I was hoping to use it in WHERE statement and this is just an example.DECLARE @MYTEST AS VARCHAR(3)
SET @MYTEST = '<>'
SELECT CARS.Year
FROM CARS
WHERE CARS.Year @MYTEST '2011'
No that...
May 28, 2013 at 9:12 am
TJT (5/28/2013)
Can you declare an operator?DECLARE @MYTEST AS VARCHAR(3)
SET @MYTEST = '<>'
Well you can declare a varchar that has those characters. Not sure what you are wanting to do...
May 28, 2013 at 8:59 am
Mark's excellent query looks like it should return the data you are looking for.
However if I could make a couple of suggestions. You are using the old style joins. You...
May 28, 2013 at 8:50 am
Lynn Pettis (5/28/2013)
Sean Lange (5/28/2013)
Lynn Pettis (5/28/2013)
Sean Lange (5/28/2013)
May 28, 2013 at 8:34 am
Lynn Pettis (5/28/2013)
Sean Lange (5/28/2013)
Yet another reason NOT to use select *. 😛 I have answered this exact same question at work twice in the last week.
I have to agree...
May 28, 2013 at 8:27 am
As Lynn said this appears to be MySql. You will have to confirm what datatypes you actually want but this should be close.
CREATE TABLE nwn_sessions
(
session_id varchar(32) NOT NULL default...
May 28, 2013 at 8:25 am
You can't use TableValued parameters across databases. It seems like it should be ok but the reality is the datatypes are NOT the same. You know they are declared the...
May 28, 2013 at 8:18 am
edw_munya (5/27/2013)
Credit Line Dates AvailableAmount Principal Interests Principal Interests
0015321-01 31/01/2003 220,000 40,000 30,000 - ...
May 28, 2013 at 7:48 am
Yet another reason NOT to use select *. 😛 I have answered this exact same question at work twice in the last week.
May 28, 2013 at 7:43 am
Mark Harley (5/28/2013)
May 28, 2013 at 7:40 am
balaji.ganga 68339 (5/28/2013)
There is a " string or binary data would be truncated error " raised while executing the stored procedure. The stored procedure get inserts the records...
May 28, 2013 at 7:36 am
Viewing 15 posts - 8,206 through 8,220 (of 15,381 total)