Nita Reddy (1/17/2007)

Hi Luke,

I am getting this similar stituation, How can I get the DTS I want to run. I want to change DTS pacakage in SQL agent with the...

or

select cust, sum(case prod when 'P' then 1 else 0 end) as 'No. of Product (P)' , sum(case prod when 'Q' then 1 else 0 end) as 'No. of Product...

hi,

do you have data in that table? if so, existing data should support the conversion to int

try to do this change in Management Studio (right click on the table, 'modify'),...

my understanding was that subsequent runs of statement #1 and statement #2 would return the same result (over time)- which does, if the table is not cleared and the insert...

forgot to say that records that meet those criteria should not be retrieved.

but i guess Jeff' s idea is faster

why don't you do it in sql?

and some limits, like

(ESASKSIZE is null and ESBIDSIZE is null)

or

(ESASKSIZE '' and ESBIDSIZE = '')

might work

true, thank you 🙂

i guess i've read the 'default' part and skipped the rest

shouldn't it be a 'none of the above' option? 😛

if i did not miss something in the qod.... i think that in sql2005 the default listening port is 1434

should i...

see convert function:

select convert(varchar(30),getdate(), 106) does almost what you want

there are different formats, maybe you find one that suits you

or... if you really want the full month name use datename:

SELECT...

i guess you can write something like

ADD CONSTRAINT chkRowCount CHECK (col1 IN(0,1,2,3,4,5) and col2 IN(0,1,2,3,4,5) and ... and col8 IN(0,1,2,3,4,5));

i do not think it's a matter of sql server version. ideally you/we should be able to answer without running the command.

but if you still want to run it,...

try

select substring(@email, 1, charindex('@', @email)-1)

Dragos

hi

maybe you could use a semaphore extended with a datetime value which you use to age the semaphore (if it shows the sp is running for x time and...

Andras is right

to fix, you could either compare the LastUpdate using between or convert it to 'only date'

select count(*) from TvsRecords where LastUpdate between

convert(datetime, convert(varchar(10),getdate()-1,101), 101)

and convert(datetime,convert(varchar(10),getdate(),101), 101)...

yes you can

check BOL...