not what I asked for , my friend sorry. Let me clarify.

I wanted to see the actual TSQL statement you are using.

show me something like this:

SELECT dbo.shift(somecolumn) as AValue, *...

if the temp table is declared in the parent procedure, the temp table exists for any processes or child procedure all as well.

each instance of the parent proc would create...

can you show the query that is using the shift function now? basically we are talking about joining that query to the shifts table directly, instead of using the function.

the default directory can be different on every machine.

take a look at the filepaths from this view:

select * from master.sys.sysaltfiles

TSQL does not have any ability to raise a prompt. technically,...

you'll really want to read the article; the master key is a prerequisite; once you have that, my snippet examples will work.

i *think* this will work no matter what?:

select...

remember a TOP without order by doesn't make sense...

to do the top 20 of the top 90%, it's just nested selects....

select TOP 20 * FROM

(

SELECT TOP 90 PERCENT * ...

these were my previous avatars:

favorite comic inspired 7 plus years ago

my dawg debbie was my avatar for years..

for the star wars period Gail mentioned.

reading on uglyoverload, time for a n...

deepak.a (2/16/2011)

---

hi Gail show and HowardW thanks for your reply.

I am looking something like encrypt and decrypt is there any other way in sql server we can acheive ?

Thanks and...

i fiddled briefly with the trial version of Idera's Virtual Database, which some how magically opens a Full Backup as if it were real, without grabbing disk space, and even...

your email example is another good one; if you need to send an individual email based on each row in a given select, there's no other alternative than a loop...

supposed you have a stored procedure (sp_helptext for example), and you want to call it for every procedure/function or view in the database;

you'd need to either use a cursor,...

ouch that one is not so easy;

The FileSystemObject is still exists in vb.NET/c#, but there are "better" ways to do it...it's knowing which objects are around, and what they do,...

no problem...the format for a backup , or the mdf, is standard between the same versions...2005;

the service that answers requests to access the database may be 32 bit, 64 bit...

i think this is the functional equivalent:

Private Function DoStuff() As Boolean

Dim s As String

...

I Think Mr Celkos post was for a db other than SQL...this is the equivalent:

CREATE TABLE People

(person_id INTEGER NOT NULL PRIMARY KEY,

person_name VARCHAR(35) NOT NULL,

sex_code INTEGER NOT NULL

CHECK(sex_code IN (1,...