Lynn Pettis

Forum Replies Created

Viewing 15 posts - 12,721 through 12,735 (of 26,486 total)

RE: Load Text File into Table - Seperated by Commas

More details. Not sure what you are actually looking for when processing of the file is completed.

April 18, 2012 at 10:07 am

#1475450
RE: Performing a piecemeal restore of a DB with Filestream data?

jasona.work (4/18/2012)
Leo.Miller (4/17/2012)
jasona.work (4/17/2012)
I realize we could take Differential backups throughout the week (Tue-Fri,) which would capture only the updated / changed / added Filestream information, but there are office...

April 18, 2012 at 9:52 am

#1475436
RE: Password protect Backup files

opc.three, george sibbald
Okay. We understand your disagreement on this subject, and if you two would like to continue this disagreement, please take it off-line.

April 18, 2012 at 9:50 am

#1475433
RE: Are the posted questions getting worse?

The Dixie Flatline (4/18/2012)
Lynn,
My wife is a special education teacher with a lot of training and experience in behavior modification. She has taught me the power...

April 18, 2012 at 9:46 am

#1475430
RE: Is it possible to SUM(@variable)?

commonman00 (4/18/2012)
Thanks guys for your pointers.
Managed to setup dynamic SQLs with tips from http://www.sommarskog.se/dynamic_sql.html.
Also managed to get rid of the cursor with tips from http://www.sql-server-performance.com/2004/operations-no-cursors/
Forum etiquette would have you...

April 18, 2012 at 9:20 am

#1475410
RE: Reference Table or VARCHAR column?

SQLKnowItAll (4/18/2012)
I am trying to get a developer to change a column in a table that is like so:
CREATE TABLE tableA(
column1 VARCHAR(64) NOT NULL PRIMARY KEY...

April 18, 2012 at 9:12 am

#1475402
RE: Backup error on format of ticks

JKSQL (4/18/2012)
I tried to have SQLCMD respect a variable in a .SQL file but it does not seem to allow that. So I decided to go another way. ...

April 18, 2012 at 9:08 am

#1475398
RE: if------then ----else in select statement

hbtkp (4/18/2012)
inline table valued function can call sp?thats my question
No.

April 18, 2012 at 9:05 am

#1475397
RE: Are the posted questions getting worse?

The Dixie Flatline (4/18/2012)
GilaMonster (4/17/2012)
The "Mr I don't have a clue" thread is starting to resemble a pile-on. Maybe better to just ignore him or at most one post from...

April 18, 2012 at 8:48 am

#1475388
RE: if------then ----else in select statement

hbtkp (4/18/2012)
thanks drew,is there any other way.
i cannot use udf , as i cannot call sp inside it.
i need to get result of cursor in select statement.
where can i put...

April 18, 2012 at 8:46 am

#1475385
RE: creating DDL having datetime field

polkadot (4/18/2012)
Thanks both.
I did that and the insert part executed, but the results in the table were unexpected.
Insert
insert into Case_Review
values
(220, 1, 'Proposed', '2012-04-17 12:17'),
(220, 2, 'Proposed', '2012-04-17 14:05'),
(220, 3, 'Proposed',...

April 18, 2012 at 8:41 am

#1475375
RE: if------then ----else in select statement

Please post the entire stored procedure. Can't really help with only partial code.

April 17, 2012 at 8:39 pm

#1475131
RE: Are the posted questions getting worse?

capn.hector (4/17/2012)
or maby this
http://www.youtube.com/watch?v=OVtinv5LSnE
LMAO, Now that fits that thread!

April 17, 2012 at 7:15 pm

#1475119
RE: Question about dbcc shrinkfile

I don't know, I defragged files on our SAN's. There were times it was the only way to reclaim sufficient contiguous disk space for other databases.

April 17, 2012 at 7:13 pm

#1475117
RE: Are the posted questions getting worse?

capn.hector (4/17/2012)
Lynn Pettis (4/17/2012)
Okay, now we really need that Porky the Pig picture with him say move along, nothing to see here. The OP is "closing the thread". ...

April 17, 2012 at 7:10 pm

#1475115

Viewing 15 posts - 12,721 through 12,735 (of 26,486 total)