Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2004-12-19 : 12:40:25
|
| Probably stupid but:I have a select coming back from a stored proc. Looks like this. SELECT a.projectidchar .. .. ,c.ufname + ' ' + c.ulname as projectowner --17 ,dbo.fx_convert_2timezone (projectcreateddate,@defaulttimezone, @defaultusedaylightsavings) as projectcreateddate ,dbo.fx_convert_2timezone (projectupdateddate,@defaulttimezone, @defaultusedaylightsavings) as projectupdateddate ,dbo.fx_convert_2timezone (projectbidinbydate,@defaulttimezone, @defaultusedaylightsavings) as projectbidinbydate --20 ,dbo.fx_convert_2timezone (projectgolivedate,@defaulttimezone, @defaultusedaylightsavings) as projectgolivedate FROM dbo.tblproject a INNER JOIN dbo.tbluser c ON (a.projectowner = c.uidint) LEFT JOIN dbo.tbltimezonedata d ON (d.timezoneid = a.projecttimezoneid) WHERE...if I run the proc in query analyzer I get the results fine. When I execute from a classic ASP page the data from the UDFs doesn't come back. I have tried:dbo.fx_convert_2timezone (projectcreateddate,@defaulttimezone, @defaultusedaylightsavings) as projectcreateddate'projectcreateddate' = dbo.fx_convert_2timezone (projectcreateddate,@defaulttimezone, @defaultusedaylightsavings)'projectcreateddate' = (SELECT dbo.fx_convert_2timezone (projectcreateddate,@defaulttimezone, @defaultusedaylightsavings))nothing seems to work.Any ideas.Then UDF does a conversion from timezone to timezone and returns a date. The dates are not NULL.slow down to move faster... |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-19 : 13:05:56
|
| Use the profiler to see what the client is executing then execute that in query analyser.Put the query into a stored proc and call that from the page then you can logg the call and put in trace code to see what it is doing.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
|
|
select with a UDF