Search Results

Search found 27723 results on 1109 pages for 'sql puzzle'.

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

Page 257/1109 | < Previous Page | 253 254 255 256 257 258 259 260 261 262 263 264  | Next Page >

  • node to traverse cannot be null (Hibernate SQL)

    - by tiswas
    I'm performing a SQL query through hibernate, which looks like: SELECT thi FROM track_history_items thi JOIN artists art ON thi.artist_id = art.id WHERE thi.type = "TrackBroadcast" GROUP BY art.name ORDER thi.createdAt DESC but I'm getting the message that 'Node to traverse cannot be null!'. Anyone know what could be causing this? --EDIT-- I'm pretty sure that this problem is being caused by the possibility of artist_id to be null. However, I can't prevent this, so can I just skip the rows track_history_item rows which have a null artist_id?

    Read the article

  • Question About SQL Query

    - by Ameer
    I am using the below statement to generate age of a person in Oracle SQL and my question is below. SELECT TO_NUMBER(TO_CHAR(CURRENT_DATE,'YYYY'))-TO_NUMBER(TO_CHAR(BIRTH_DATE,'YYYY')) FROM NAME WHERE NAME_ID =NAME_ID This statement is only correct upto so far that I need a statement which could count months and even days in order to get the age.

    Read the article

  • Explain this SQL query in plain English.

    - by Kevinniceguy
    Please explain, in plain English, what question this SQL query answers: SELECT SUM(price) FROM Room r, Hotel h WHERE r.hotelNo = h.hotelNo and hotelName = 'Paris Hilton' and roomNo NOT IN (SELECT roomNo FROM Booking b, Hotel h WHERE (dateFrom <= CURRENT_DATE AND dateTo >= CURRENT_DATE) AND b.hotelNo = h.hotelNo AND hotelName = 'Paris Hilton');

    Read the article

  • compiling a linq to sql query

    - by frenchie
    Hi, I have queries that are built like this: public static List<MyObjectModel> GetData (int MyParam) { using (DataModel MyModelDC = new DataModel()) { var MyQuery = from.... select MyObjectModel { ...} } return new List<MyObjectModel> (MyQuery) } } It seems that using compiled linq-to-sql queries are about as fast as stored procedures and so the goal is to convert these queries into compiled queries. What's the syntax for this? Thanks.

    Read the article

  • Store an image in a SQL Server CE database

    - by Vaccano
    Does any one know of an example on how to store an image in a SQL Server CE database? What data type should the column be? (I am guessing binary.) I use Linq-To-Datasets. Is it possible using that to put the image into the database and pull it out again later? Thanks for any advice.

    Read the article

  • How to handle when SSRS does not automatically update fields based on database query?

    - by badpanda
    So I am trying to change the number of fields in my dataset in SSRS and the refresh button is not picking up the added field from the SQL server. The query is definitely returning the correct data, as I have double checked in the server engine itself. Also, I have tried manually adding the field using the SSRS menu, but as soon as I execute it disappears. Any suggestions or similar experiences?

    Read the article

  • converting factored number to decimal in MS SQL

    - by LS
    I need to convert a number which gives decimals in factored format in to decimals, i.e. 11.16 is 11.5 in decimal. This is because 16 is in base of 32 and 11.16 should be read as 11+16/32 = 11.5 I get 11.16 as a string and I need to change it to 11.5 as numeric in MS SQL(2005) database. Any shorter way of doing this rather than splitting strings,converting to numerics,maths,convert to string, concatenate and then convert to numeric?

    Read the article

  • Sorting string column containing numbers in SQL?

    - by Ish
    Dear Folks, I am trying to sort string column (containing numbers). // SELECT `name` FROM `mytable` ORDER BY `name` ASC +----------+ +-- name --+ +----------+ +-- a 1 ---+ +-- a 12 --+ +-- a 2 ---+ +-- a 3 ---+ You see natural sorting algorithm of Mysql is placing a 12 after a 1 (which is ok for most apps), But I have unique needs, so I want result should be sorted like this. +----------+ +-- name --+ +----------+ +-- a 1 ---+ +-- a 2 ---+ +-- a 3 ---+ +-- a 12 --+ Is it possible with just SQL, or I have to manipulate result-set at application level? Thanks for reading...

    Read the article

  • Which is more flexible in regards to database changes, EF 4 or Linq to SQL

    - by JBeckton
    Reading about both Linq to SQL and Entity Framework I have developed the impression that EF is more suitable for apps that get data from multiple data sources. But as I am reading about MVC2 models I see an example where EF is more loosely coupled with your data model. If I have to add or remove some columns from a table then what is involved in updating my model or DAL with each of these implementations?

    Read the article

  • MS SQL to PostgreSql

    - by Dezigo
    I need to create a trigger in MS SQL. Trigger works: If I found new line where T = 'A'; than.. add this line to PostgreSQL table. Is it possible to create it,without software? (I know how to create trigger,but how to create connection between two servers..?

    Read the article

  • How to perform a select using a WHERE NOT EXISTS

    - by Peter Bridger
    I'm using LINQ2SQL and I want to compare two tables and select all rows that are missing from one tables (based upon one of the column values). In standard SQL I would write this as: SELECT FirstName, LastName, RefId, Email FROM Users_ActiveDirectory AS ADU WHERE NOT EXISTS ( SELECT U.RefId FROM Users AS U WHERE U.RefID = ADU.RefId ) However I'm not sure how to achieve the same result using LINQ2SQL?

    Read the article

  • Restrict update Column

    - by Kushan Hasithe Fernando
    Is it possible to restrict updating a column in SQL without using a trigger ? If so how ? (need the query) PS: I mean, I have a table CREATE TABLE MYBUDGET.tbl_Income ( [IncomeID] INT NOT NULL IDENTITY(1,1), [IncomeCatID] INT NOT NULL, [IncomeAmnt] MONEY NOT NULL, [IncomeCurrencyID] INT NOT NULL, [ExchangeRateID] INT NOT NULL, [IncomeAmnt_LKR] MONEY NOT NULL, [AddedOn] DATETIME NOT NULL, [Remark] VARCHAR(250), ) I need to allow users to update only [ExchangeRateID] and [IncomeAmnt_LKR] fields. All other fields can not be updated. only insert.

    Read the article

  • How to write SQL query as named_scope?

    - by keruilin
    How can I translate the following SQL query into a named_scope? select users.*, sum(total_quantity * total_price) as points_spent from orders join users on users.id = orders.user_id where pay_type = 'points' group by user_id order by points_spent desc Thanks!

    Read the article

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

< Previous Page | 253 254 255 256 257 258 259 260 261 262 263 264  | Next Page >