http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=179860

do u mean you have to back-up our 79 tables structure, every month? do you want the table structure, or just the tables names in one text file seperated by...

--SET NOCOUNT ON

--THIS PROCESS TOOK 1m47s--2m:05s(varies if you switch on traces)

--MACHINE:LAPTOP

--OS:WINDOWS XP INTEL(R) PENTIUM 4

--CPU 1.60 GHZ 897 MHZ,

--256 MB Of RAM(typically lower ram since i using other devices)

--DROP...

take your pick

SELECT     a.name, '' as role

FROM         dbo.sysusers a INNER JOIN

                      dbo.sysmembers b ON a.uid <> b.memberuid

WHERE     (a.name NOT LIKE 'sa%') AND (a.name...

c:\program files\microsoft sql server\mssql\upgrade\scptxfr.exe /s <servername> /P <password> /d northwind /f northwind.sql

thanks remi, did not need to use the case statement. this is a pretty cool tip & trick in the bag

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true

hi...

still produced A? missing something....

sql query analyzer version 8.00.194

set nocount on

create table #temp

(product_id int not null,

 prod_desc char(1) null)

insert into #temp

select 1, 'A'

insert into #temp

select 1, 'B'

insert into #temp

select 1, 'C'

insert into #temp

select 2, 'D'

insert into #temp

select 2,...

DECLARE @unicodestr nvarchar(100)

SET @unicodestr = 'mystring '

--while EXISTS(Select 1 where @unicodestr like  '% ')

--begin

 --SELECT @unicodestr = LEFT(@unicodestr, Len(@unicodestr) - 1)

-- if Len(@unicodestr)  = 0

--  break

--end

SELECT 'Pre' + RTRIM(@unicodestr) + 'Suff'...

hi cris

>>May be so, I was just wondering if one can do this ??

yup,

but technically when considering work to be done

>>should focus on presenting the data in the format you...

post your query...and lets see how its structured, is the validating on a row bases prior to inserting or something?

c:\program files\microsoft sql server\mssql\upgrade\scptxfr.exe /s <servername> /P <password> /d northwind /f northwind.sql

thanks cris, i had to look-up the word SARGable if it really existed

The term "sargable" (which is in effect a made-up word) comes...

have you tried

select CONVERT(DATETIME,DCCntHst.SentDate,102), CONVERT(DATETIME, '2003-10-24 00:00:00', 102), *

where....

(CONVERT(DATETIME,DCCntHst.SentDate,102) = CONVERT(DATETIME, '2003-10-24 00:00:00', 102))

have u tried UDT?