bledu

Forum Replies Created

Viewing 15 posts - 106 through 120 (of 654 total)

RE: Quartiles

Ninja,
got that one right. KISS
Everything you can imagine is real.

August 13, 2007 at 10:05 am

#726514
RE: Quartiles

1.
SELECT venue,fdate
FROM TABLE1
WHERE duration =
(
SELECT MAX
Everything you can imagine is real.

August 13, 2007 at 9:45 am

#726503
RE: Quartiles

we need more info.
but out of curiosity why do you want to do it in sql, and not a frontend program?
nonetheless bring it...
Everything you can imagine is real.

August 13, 2007 at 9:38 am

#726499
RE: @@Rowcount in view???

i can't understand its use either from that perspective.
Everything you can imagine is real.

August 13, 2007 at 9:29 am

#726495
RE: what are the steps of migration from sql 2000 to 2005

>i want all my crystal report 8.5 reports into reporting services
you will have to redevelop your reports
Everything you can imagine is real.

August 13, 2007 at 5:30 am

#726394
RE: Insert 8 million records from text file to a table

use the import/export wizard
Everything you can imagine is real.

August 13, 2007 at 5:28 am

#726393
RE: VBScript Object Required error

did you properly define it your include file. put an OPTION EXPLICIT statement at the top of your asp pages so that it forces you to declare variables
Everything you can imagine is real.

August 10, 2007 at 10:00 am

#726092
RE: Case statement help

Charlie, how many [idMacroSegment] do you use. is it only 1 and 2?
if so i am thinking that the [idMacroSegment] testing becomes redundant...
Everything you can imagine is real.

August 10, 2007 at 9:26 am

#726071
RE: Case statement help

charlie if possible can you please try Vladan's solution and see how it performs against the other solution by Sergiy. and of coz give us the results
Everything you can imagine is real.

August 10, 2007 at 9:20 am

#726069
RE: Case statement help

thank goodness it was a thought
Everything you can imagine is real.

August 10, 2007 at 8:24 am

#726044
RE: VBScript Object Required error

my two senses:
<% %> is use in an asp page so is executed at runtime, whereas <script> can be used as well in html pages.
can you post your page code,...
Everything you can imagine is real.

August 10, 2007 at 8:13 am

#726036
RE: XML to SQL Server Database Table

you can pass the xml to a stored procedure with ntext datatype and then use openxml to load the data into your table. look in BOL for usage of OPENXML
or...
Everything you can imagine is real.

August 10, 2007 at 2:26 am

#725920
RE: Case statement help

i think you can use the OR statement.i.e.
when
2509 or 2513 then 'Con Std'
when
2500
Everything you can imagine is real.

August 10, 2007 at 2:09 am

#725915
RE: VBScript Object Required error

<%@Language="VBScript"%>

<%
Sub btnSave_OnClick
    dim a bunch of variables
    sql = "the sql statement"
    Conn.Execute(sql)
End Sub
%>
<html>
<head>
Everything you can imagine is real.

August 9, 2007 at 3:51 pm

#725860
RE: Do you have experience that your manager jealous of your skills?

if a company is not a technology company then chances are they are not really intrested in the excellent developer but more in the manager who knows the company culture....
Everything you can imagine is real.

August 9, 2007 at 10:03 am

#725791

Viewing 15 posts - 106 through 120 (of 654 total)