AW: How u convert this cfquery to TSQL for MS SQL stored procedure

-statement yet. BTW: Anyone care to see how Ben Forta did in Switzerland. Just goto www.railo.ch/gallery -Ursprüngliche Nachricht- Von: Pardeep Singh [mailto:[EMAIL PROTECTED] Gesendet: Montag, 21. Februar 2005 20:32 An: CF-Talk Betreff: How u convert this cfquery to TSQL for MS SQL stored

Re: How u convert this cfquery to TSQL for MS SQL stored procedure

Pardeepthe query is already in T-SQLI think what you are asking is how to handle dynamic variables in T-SQL (currently this is done via CF). That said...my conditional logic in TSQL is shall we say...not up to snuff ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Comm

RE: How u convert this cfquery to TSQL for MS SQL stored procedure

Okay I will give it a try, By the way my name is Eric, who is Ed? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, February 21, 2005 3:03 PM To: CF-Talk Subject: Re: How u convert this cfquery to TSQL for MS SQL stored procedure Hi Ed, Thanks for the

Re: How u convert this cfquery to TSQL for MS SQL stored procedure

Hi Ed, Thanks for the feedback. I can do this easily in Cold Fusion, what I'm trying to do is offload the work to MS SQL 2000 via TSQL in a stored procedure. The search form has a lot of entry fields, we're doing a zipcode radius search too, so it just makes more sense to have the DB d

RE: How u convert this cfquery to TSQL for MS SQL stored procedure

lk Subject: How u convert this cfquery to TSQL for MS SQL stored procedure Does anyone know how to convert this cfquery to TSQL so it can be executed through a stored procedure instead in MS SQL 2000? The first condition just sees if a var exists and makes sure its not null, the second one doe

How u convert this cfquery to TSQL for MS SQL stored procedure

Does anyone know how to convert this cfquery to TSQL so it can be executed through a stored procedure instead in MS SQL 2000? The first condition just sees if a var exists and makes sure its not null, the second one does the same thing but feeds the query a list: select * from profiles where

RE: TSQL problem

> I know its coldfusion group but I wonder if someone can help me > with this query. What the alternative of Evaluate() in TSQL? >   > SELECT > 09/01/2004 + 'CAST(..)' AS myDateTime >   > FROM myTest You can use sp_executesql, EXECUTE, or EXEC, de

RE: TSQL problem

; -Original Message- > From: Shahzad.Butt [mailto:[EMAIL PROTECTED] > Sent: Friday, January 09, 2004 12:04 PM > To: CF-Talk > Subject: RE: TSQL problem > > > Following is the query > > SELECT > > DateAdd(Day, CAST(LEFT(CAST(PanelLocalDT AS Decimal(10,5)), >

RE: TSQL problem

Following is the query SELECT DateAdd(Day, CAST(LEFT(CAST(PanelLocalDT AS Decimal(10,5)), CHARINDEX('.', CAST(PanelLocalDT AS Decimal(10,5)))-1) AS INT), '1899-12-30')     + ' '         + 'CAST(((CaST(RIGHT(CONVERT(decimal(10,4),PanelLocalDT), LEN(CONVERT(decimal(10,4),PanelLocalDT)) - ch

RE: TSQL problem

Why not use DateAdd()? What's in the . - that could make a big difference > -Original Message- > From: Shahzad.Butt [mailto:[EMAIL PROTECTED] > Sent: Friday, January 09, 2004 11:45 AM > To: CF-Talk > Subject: TSQL problem > > > I know its coldfusion grou

TSQL problem

I know its coldfusion group but I wonder if someone can help me with this query. What the alternative of Evaluate() in TSQL? SELECT 09/01/2004 + 'CAST(..)' AS myDateTime FROM myTest [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: TSQL Script to replicate a db?

Tuesday, March 18, 2003 8:47 AM > To: CF-Talk > Subject: TSQL Script to replicate a db? > > > Hi All, > > I have a SQL2K db in a shared hosting environment at CFDynamics.com. > Each time I need to duplicate the db (intranet db) for my > clients I just use >

RE: TSQL Script to replicate a db?

Very cool, thanks. ~Jason -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 10:12 AM To: CF-Talk Subject: RE: TSQL Script to replicate a db? You could use the Scripting wizard in the Enterprise manager. To do this Select the

RE: TSQL Script to replicate a db?

: TSQL Script to replicate a db? Hi All, I have a SQL2K db in a shared hosting environment at CFDynamics.com. Each time I need to duplicate the db (intranet db) for my clients I just use the export tool and export it to another client's db. The problem is that each time I do this I have to go

RE: TSQL Script to replicate a db?

ssage- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] Sent: 18 March 2003 14:47 To: CF-Talk Subject: TSQL Script to replicate a db? Hi All, I have a SQL2K db in a shared hosting environment at CFDynamics.com. Each time I need to duplicate the db (intranet db) for my clients I just use the export

TSQL Script to replicate a db?

Hi All, I have a SQL2K db in a shared hosting environment at CFDynamics.com. Each time I need to duplicate the db (intranet db) for my clients I just use the export tool and export it to another client's db. The problem is that each time I do this I have to go back and set up the autonumber field

Re: TSQL Equivalent to Replace

Uhhh, replace? - Original Message - From: Duane Boudreau <[EMAIL PROTECTED]> Date: Thursday, January 9, 2003 11:40 am Subject: TSQL Equivalent to Replace > Is there a TSQL function equivalent to the CF replace function? > >

RE: TSQL Equivalent to Replace

Oops found it. Replace (doh!) Duane -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 1:40 PM To: CF-Talk Subject: TSQL Equivalent to Replace Is there a TSQL function equivalent to the CF replace function? Thanks, Duane

TSQL Equivalent to Replace

Is there a TSQL function equivalent to the CF replace function? Thanks, Duane ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe

Re: TSQL

om: "S. Isaac Dealey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 03, 2002 10:45 AM Subject: Re: TSQL > I'm not aware of a simple native way to do this, though you can use dateadd > math... > > select convert(varchar,ho

RE: TSQL

cool - never seen that syntax before. -mk -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:55 AM To: CF-Talk Subject: Re: TSQL Quoting Mario Martinez <[EMAIL PROTECTED]>: > > My problem is Transact-SQL related. I wan

Re: TSQL

Quoting Mario Martinez <[EMAIL PROTECTED]>: > > My problem is Transact-SQL related. I want to convert a numeric value > (it 's the amount of seconds a user has spend in one of my sites) to > this format hh:mm:ss .Is there any function in SQL transact that I > could use ??. Why not use plain old

RE: TSQL

':' + RIGHT(CAST(myNumField, Char(6)),2) AS myTimeString FROM mytable If you are using SQL 2000 you can create a UDF scalar function and use it in-line. -mk -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:30 AM T

Re: TSQL

I'm not aware of a simple native way to do this, though you can use dateadd math... select convert(varchar,hour(dateadd(s,#seconds#,#createodbcdate(now())#))) + ':' + convert(varchar,minute(dateadd(s,#seconds#,#createodbcdate(now())#))) + ':' + convert(varchar,second(dateadd(s,#seconds#,#createod

TSQL

Hi folks: This question could be innapropiate but this list has always been great . Besides I'm a newbie. My problem is Transact-SQL related. I want to convert a numeric value (it 's the amount of seconds a user has spend in one of my sites) to this format hh:mm:ss .Is there any function in SQL tr

RE: MS-SQL Server 2K, TSQL and CF Admin

> I'm trying to setup a MS-SQL Server 2K datasource in the CF > administrator, version 4.5. I have no experience doing this. > I want to use the OLEDB since I've heard it's faster. But I > don't know what to enter in the Provider DSN and Provider > fields. Can anybody help me? In my opinion,

MS-SQL Server 2K, TSQL and CF Admin

Hi everyone, I'm trying to setup a MS-SQL Server 2K datasource in the CF administrator, version 4.5. I have no experience doing this. I want to use the OLEDB since I've heard it's faster. But I don't know what to enter in the Provider DSN and Provider fields. Can anybody help me?