Recent content by zinkjo

Anyone know how to grant user access to a sequence object in a physical model? Basically want the exported DDL to include GRANT USAGE ON SEQUENCE tablename TO username I know how to do it for tables and views. Any help would be appreciated. thanks.

The only problem with that is that it does a character comparison. so if the constant has '7-21-2004' instead of '07-21-2004' the row will not return.

what is the best way to compare a constant such as '07-21-2004' to a datetime column I want something like the following select * from tableA where myDateCol = '07-21-2004' if myDateCol has a value of '07-21-2004 10:15:00' the row should be selected. I want the query to ignore the time portion.

I can't read the last 2 posts. Was there an update to the suggested query ?

not 100% sure what you mean by that...could you post a sample....thanks

I have a need to join a table to itself. I need to determine if for a given deal number the swap deal number does not exist on the table. Here is my query thus far, but it is really dogging. Is there a better approach ?? select a.counter_ccy, a.value_date...

I tried that and it gets me past the syntax error, but I don't get the desired results. The where clause filters out all results. I always want the rows returned from the seasonPlayer table even if there is no match on the gamePlayerStats table.

I have 2 Tables: SeasonPlayer and GamePlayerStats. I want to retrieve all of the info from SeasonPlayer and if their is matching info on GamePlayerStats(for a particular game) retrieve that also. I think this is the correct query, but I keep getting "Join Expression Not Supported&quot...