Forum Replies Created
Viewing 15 posts - 3,841 through 3,855 (of 5,356 total)
-
RE: re: Creating a pivot query through SQL
Hi Brendon,
quote:
I've got a classical situtation where the records from my query needs to be pivotedeg.
record1
record2
record3
record4
...
to become
record1 record2 record3 record4....
I have...
-
RE: SqlServerCentral.com... The Book?
Hi Andy,
quote:
Frank - I'd say an honest 4-6 weeks. Incredbile that in 2003 anything can take that long, but I sent several... -
RE: Update Excel from SQL server
Hi Fab_Innocenti,
hello! I have a sheet excel and I have to update particular cells of the sheet with the result of a sql query. I have found some example but...
-
RE: An intriguing SQL question
Hi pop022,
for performance reasons I would suggest NOT to name your sprocs sp_*.
AFAIK SQL Server will always look first into master for sp_*
Just my $0.02
Frank
-
RE: Script To Drop All Indexes And Keys In a Database
Hi Gil,
well like Gary I have not script to recreate them, but here is what I use to drop
select
'drop index ' + o.name + '.'... -
RE: SqlServerCentral.com... The Book?
Hi SQLBill,
quote:
Every time I read something (not just here) I wish I had the ability to correct typos or at least 'point... -
RE: big bonus for answering on-the-day
quote:
Falling On The Floor Laughing (FOTFL or FOFL)Acronymmmmmmmssssssssss Agh!
-
RE: retreive data
to piggy-back on the previous two posts
Given your example would your procedure return
8
9
6
11
7
23
Lower and upper included, excluded, partially in (excluded)
???
Lots and lots of question.
You should really provide more information...
-
RE: Excluding administrators from database
Hi beath,
quote:
We've got one of these "HR versus IT" meetings brewing where HR are demanding that ALL IT personnel be excluded from... -
RE: RANDOM positive integer number
Hi AC,
quote:
Is there anyone knows how to create a function which returns a random positive integer number within user defined range? ... -
RE: big bonus for answering on-the-day
Hi David,
quote:
FOTFLI hail thee...............
What does FOTFL stand for?
Btw, not to get...
-
RE: Using File Groups
quote:
I am not sure if it can be done using EMI think I am missing something obvious.
Can u...
-
RE: Using File Groups
quote:
or is there any simpler method?EM?
No, serious, look at BOL for...
-
RE: Using File Groups
quote:
Can I achieve some performance benefits by moving certain related tables on differentFilegroups.
if these filegroups...
-
RE: Importing .JPG into a blob
quote:
Liked this solution - have also gotten Bulk Insert to work. What I was really looking for was a stored procedure that...
Viewing 15 posts - 3,841 through 3,855 (of 5,356 total)