Search Results

Search found 27497 results on 1100 pages for 'sql joke'.

Page 308/1100 | < Previous Page | 304 305 306 307 308 309 310 311 312 313 314 315  | Next Page >

• LINQ to SQL: To Attach or Not To Attach

  - by bradhe

  So I'm have a really hard time figuring out when I should be attaching to an object and when I shouldn't be attaching to an object. First thing's first, here is a small diagram of my (very simplified) object model. Edit: Okay, apparently I'm not allowed to post images...here you go: http://i.imgur.com/2ROFI.png In my DAL I create a new…

  Read the article

• Linq-to-sql Compiled Query is returning result from different DataContext

  - by Vladimir Kojic

  Compiled query: public static Func<OperationalDataContext, short, Machine> QueryMachineById = CompiledQuery.Compile((OperationalDataContext db, short machineID) => db.Machines.Where(m => m.MachineID == machineID).SingleOrDefault()); It looks like compiled query is caching Machine object and returning…

  Read the article

• SSIS Data Flow Task SQL 2008

  - by Gerard

  Hi All, I am wondering if it is possible to: 1) Develop SSIS Package for Data Flow Task I am aware of how to do this on a local or network SQLServer, However is it possible to create a package that uploads to a "remote" sqlserver, ie one that is not on site or on the LAN. any guidance would be great Thanks

  Read the article

• How to change the primary key to be non-clustered?

  - by AngryHacker

  Part-time reluctant DBA here. I want to change an existing primary key index from clustered to non-clustered. And the syntax is escaping me. This is how it's scripted out right now. ALTER TABLE [dbo].[Config] WITH NOCHECK ADD CONSTRAINT [PK_Config] PRIMARY KEY CLUSTERED ( [ConfigID] ) ON [PRIMARY] I am…

  Read the article

• Query design in SQL - ORDER BY SUM() of field in rows which meet a certain condition

  - by Christian Mann

  OK, so I have two tables I'm working with - project and service, simplified thus: project ------- id PK name str service ------- project_id FK for project time_start int (timestamp) time_stop int (timestamp) One-to-Many relationship. Now, I want to return (preferably with one query) a list of an arbitrary number of projects,…

  Read the article

• Make SQL Select same row multiple times

  - by Emre

  I need to test my mail server. How can I make a Select statement that selects say ID=5469 a thousand times.

  Read the article

• Delete record in Linq to Sql

  - by Anders Svensson

  I have Linq2Sql classes User, Page, and UserPage (from a junction table), i.e. a many-to-many relationship. I'm using a gridview to show all Users, with a dropdownlist in each row to show the Pages visited by each user. Now I want to be able to delete records through the gridview, so I have added a delete button in the gridview…

  Read the article

• How would I do this in SQL?

  - by bergyman

  Let's say I have the following tables: PartyRelationship EffectiveDatedAttributes PartyRelationship contains a varchar column called class. EffectiveDatedAttributes contains a foreign key to PartyRelationship called ProductAuthorization. If I run this: select unique eda.productauthorization from …

  Read the article

• SQL: Daily Average of Logins Per Hour

  - by jerrygarciuh

  This query is producing counts of logins per hour: SELECT DATEADD(hour, DATEDIFF(hour, 0, EVENT_DATETIME), 0), COUNT(*) FROM EVENTS_ALL_RPT_V1 WHERE EVENT_NAME = 'Login' AND EVENT_DATETIME >= CONVERT(DATETIME, '2010-03-17 00:00:00', 120) AND EVENT_DATETIME <= CONVERT(DATETIME, '2010-03-24…

  Read the article

• SSIS - Upgrade from 2005 to 2008 - How to set a project property when I don't have a project

  - by Greg

  I have about 160 SSIS packages that I'm trying to upgrade from 2005 to 2008. When I run SSISUpgrade.exe on them, I get the following error messages on many of the packages: Error 0xc0209303: ...: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider MICROSOFT.JET.OLEDB.4.0 is not…

  Read the article

• SQL Query to retrieve highest item up to a point in a group

  - by James

  The best way of describing this is I have a table of people with their names and ages. Assume that people with the same surname are from the same family. I need a query in oracle which will retrieve a list of the oldest person in each family, but not older than a certain age. Table: person name …

  Read the article

• LINQ to SQL - Tracking New / Dirty Objects

  - by Joseph Sturtevant

  Is there a way to determine if a LINQ object has not yet been inserted in the database (new) or has been changed since the last update (dirty)? I plan on binding my UI to LINQ objects (using WPF) and need it to behave differently depending whether or not the object is already in the database. …

  Read the article

• SQL Replace Into question

  - by Matt

  With Replace Into, if I have two fields. FirstName LastName. The table has John Smith in it, if I was to run REPLACE INTO tblNames (FirstName, LastName) VALUES (John, Jones) Would that replace Smith with Jones, or create a new name? What determines if its an Update or and Insert?

  Read the article

• C# LINQ to SQL Except Operator

  - by kb

  Hi i have a list of event Ids that i want to be excluded from my select statement, but no sure how to implement this: this is what stores my list of event Ids List<int> ExcludedEvents; and this is my select statement (from an XML feed) var allEvents = from eventsList in…

  Read the article

• SQL Logic Operator Precedence: And and Or

  - by nc

  Are the two statements below equivalent? SELECT [...] FROM [...] WHERE some_col in (1,2,3,4,5) AND some_other_expr and SELECT [...] FROM [...] WHERE some_col in (1,2,3) or some_col in (4,5) AND some_other_expr Is there some sort of truth table I could use to verify this? …

  Read the article

• Sum of XML duration elements in SQL2008

  - by Matt

  I have a XML column that holds information about my games. Here's a sample of the information looks like. <game xmlns="http://my.name.space" > <move> <player>PlayerA</player> <start movetype="Move">EE5</start> <end…

  Read the article

• sql sum data from multiple tables

  - by Iulian

  I have 2 tables AP and INV where both have the columns [PROJECT] and [Value]. I want a query to return something like this : PROJECT | SUM_AP | SUM_INV I came up with the code below but it's returning the wrong results ( sum is wrong ). SELECT SUM(AP.Value) AS…

  Read the article

• Distinct with Count and SQl Server 2005

  - by chopps

  Hey everyone, Trying to work on a query that will return the top 3 selling products with the three having a distinct artist. Im getting stuck on getting the unique artist. Simplified Table schema Product ProductID Product Name Artist Name OrderItem …

  Read the article

• How can I select values from different rows depending on the most recent entry date, all for the sam

  - by user321185

  Basically I have a table which is used to hold employee work wear details. It is formed of the columns: EmployeeID, CostCentre, AssociateLevel, IssueDate, TrouserSize, TrouserLength, TopSize & ShoeSize. An employee can be assigned a pair of trousers,…

  Read the article

• SQL Server 2008 Geography .STBuffer() distance measurement units

  - by Chris

  I'm working with a geographic point using lat/long and need to find other points in our database within a 5 mile radius of that point. However, I can't seem to find out what the "units" are for STBuffer, it doesn't seem to conform to feet, miles, meters,…

  Read the article

• Standards for Encrypting data in SOX/HIPAA in SQL Server 200x

  - by Greens

  I was wondering if there are any standards for encrypting sensitive data in Database which are compliant w/ SOX or HIPAA. Or does the Encrypt Function in SQLServer necessary?. or handle in Business logic. Any ideas or links we have.

  Read the article

• SQL: Gather right hand values from a join

  - by Max Williams

  Let's say a question has many tags, via a join table called taggings. I do a join thus: SELECT DISTINCT `questions`.id FROM `questions` LEFT OUTER JOIN `taggings` ON `taggings`.taggable_id = `questions`.id LEFT OUTER JOIN `tags` ON `tags`.id…

  Read the article

• choosing row (from group) with max value in a SQL Server Database

  - by sriehl

  I have a large database and am putting together a report of the data. I have aggregated and summed the data from many tables to get two tables that look like the following. id | code | value id | code | value 13 | AA | 0.5 13 | AC…

  Read the article

• Formula parsing / evaluation routine or library with generic DLookup functionality

  - by tbone

  I am writing a .Net application where I must support user-defined formulas that can perform basic mathematics, as well as accessing data from any arbitrary table in the database. I have the math part working, using JScript Eval(). What I haven't…

  Read the article

• How can you tell if a trigger is enabled in SQL Server 2000

  - by Mark Brady

  This shouldn't be hard to do. I'd expect Enterprise Manager to show a folder of trigger and a list and an icon... but I don't see it anywhere. My google results get me answers where I have to write code. Are you kidding me? The only way is by…

  Read the article

< Previous Page | 304 305 306 307 308 309 310 311 312 313 314 315  | Next Page >