you'll want to use a combination of tw REVERSE commands,SUBSTRING and a CHARINDEX to get at what you want;

this kind of breaks it down into understandable pieces(i hope)

with myExampleCTE as

(SELECT...

gotcha...your agency already had pkzip/pkunzip; I has assumed (you know the rule on THAT) that you bought that product as new.

SQL Server version 7.0 doesn't support CREATE FUNCTION,

user-defined functions were introduced in MSSQL 2000. In 7.0, you still

have to use stored procedures.

you are really close...your problem is that you can't just refer to a column of data..it has to come from a select statement.

so you are testing if the serial number...

Brandie I'm really surprised you have not gone with 7zip, after all the trouble you've been having, and the recommendations from other posters.

I used to use commandline pkzip when it...

actually, what happens is the alter table statement fails:

here's a simple example:

create table Example(exid int identity(1,1) not null primary key,

exampletext varchar(30) )

GO

create view vw_example

with schemabinding as

select exid,exampletext from dbo.Example

alter...

the problem is unless you have your own SMS service, you can't do SMs messages to cell phones;

while every carrier has a supprt email that allows an email to be...

it's fairly straightforward;

the OBJECT:: does not allow a variable name i think. as a result, you just have to use dynamic sql to do the same job.

declare @sql varchar(max)

declare @partition...

inm ot a network guy, but maybe you can configure the server so only certain machines/ip ranges can access the ports for the sql server?

i think you can do that,...

i think the easiest way is going to be scripting the tables out, and doing two passes of find and replace to the script.

you can turn off almost all the...

i always hope they'll enhance it a bit so we can use it for more than 4 parts; IP6 stuff is starting to be more common, and other uses as...

i don't have screenshots for 2008R2, but the method is the same;

go to add/remove programs, and rerun the msi by clicking change...once you are in there, an additional step has...

there is a built in function PARSENAME that can help do this, but it only will help if your data has three periods in it.

the function is usually used for...

each drop table statement has to be execute seperately, no wildcards, but you can generate all the necessary statements from the metadata:

then you can copy/paste the commands and run them...

George I've got a TallyCalendar table and the code which updated/added a column to determine if the date in the table was DaylightSavings time or not...is that the same as...