query format date

Transact-SQL

Index ‹ SQL Server

- Previous
  - 1
    - order by cluase cause wrong results to be returned. In what way do you think the results are wrong Do you mean that the Themename values are not ordered correctly If so, then remember that when you have a column which has duplicate entries, there is nothing to tell sql server to output them in any particular order. You are just ordering your records based upon the value of that column ony. If you want duplicate entries to be ordered by intLocationCount, you'll need to specify that in your order clause too. Eg ORDER BY ThemeName, intLocationCount DESC HTH! Tag: query format date
  - 2
    - Error 87 while installing SQL Server 2005 This issue is solved. It was all about the way I burned the DVD. Tag: query format date
  - 3
    - Catching Events Albertoim wrote: Hi, I'm trying to catch an error and trigger a control flow to handle it. I introduce a control flow to catch "OnError" event, but , despite muy package has some errors it doesnt work... Thanks How do you know it doesn't work Tag: query format date
  - 4
    - Vista SQL 2005 SP2 client to Windows XP SQL 2005 (non-sp2) workstation. Add SQL Server Management Studio to the expection list of the windows firewall on the client you're trying to connect with and that solves it. Tag: query format date
  - 5
    - Trigger(its very urgent) Give a look to the TRIGGER topic in books online; there is a goodly amount of information available there that should get you off to a good start. If you do not have a copy of books online, you can download a copy from here: http://www.microsoft.com/downloads/details.aspx FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en Tag: query format date
  - 6
    - Cant find data source hi, have you installed SQLServerCE31-EN.msi into your development computer SDK install the msi file but not execute it. further info in http://www.microsoft.com/downloads/details.aspx familyid=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en regards,, Tag: query format date
  - 7
    - Unable to Edit or Create SSIS packages or Maintenance Plans Cumulative Update 2 for SP2 addresses some maintenance plan issues. http://support.microsoft.com/kb/936305/LN/ Tag: query format date
  - 8
    - Select expression Type Probably you are using integer arithmetic and it is rounding to 0. try cast ((1.0 * FC2 . FCtIS / FC3 . TOTALIS ) as decimal ( 4 , 2 )) as Value Tag: query format date
  - 9
    - The dreaded subreport could not be shown error Make sure that the parameters you are passing are being cast correctly. If they are integers use CINT(). Everything in SRS is treated as a string initially. Hope this might help. We have several reports that use subreports and we found this to be the main problem whenever we get this error message. Tag: query format date
  - 10
    - Looking for a component Matthew, I've fixed your image tags so that they display here, but unfortunately, your URL is being "cleansed" of the word, a$s. In the future, just use the tags, [i mg]URL[/i mg] (space is intentional) Tag: query format date
  - 11
    - Can we use Excel file (source) for Bulk Insert Task I do not believe so - the Bulk Insert task uses the same API as BCP, so the limitations are the same. You can, however, use it as the source for the data flow task, which is much more flexible and offers similarly excellent performance. Tag: query format date
  - 12
    - Identity Primary Field in Merge Replication I wouldn;t advice you use only this for your primary key. Check out this post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1423523&SiteID=1 Tag: query format date
  - 13
    - An internal error occurred. [ ID = 3639 ] on delete query This error does not look like a SQL CE error. Are you using SQL CE or SQL Server Also, could you show us the statement and describe your environment, then others may be able to help you. Tag: query format date
  - 14
    - JULY CTP (WORKSTATION COMPONENTS FAIL INSTALL) Hmmm, something is still dirty on teh machine and it thinks the sql 2005 tools or the earlier 2008 tools are there, hence the "upgrade" messages. If this is a test machine and you can take some risk, and you've really uninstalled everything, make sure HKLM/Software/Microsoft/Microsoft SQL Server isn't in the registry, make sure c:\program files\microsoft sql server isn't there on the hard drive, and of course before that make sure add/remove programs shows no sql server components. Tag: query format date
  - 15
    - Great New Resource for Books Online Information Hi, looks like a great job you have done. CU tosc InsideSQL.de Tag: query format date
  - 16
    - VERY slow stored procedure performance on datetime parameter Hi, If you use two date parameters which forms a date range, and if the first call of the SP is run with a small date range then the SP is compiled to use an execution plan which is suitable for those parameters. And after the compilation, if you give parameters that form a huge date range, that may be slow to get the results with the compiled execution plan. You may create the SP with recompile hint for such situations. But this causes the SP to be recompiled everytime it is called. Do you think this may be a reason CREATE PROC spname { parameter list } WITH RECOMPILE AS ..... Eralper http://www.kodyaz.com Tag: query format date
- Next
  - 1
    - How do i start playing with sql server??? You need to download and install the SQL Server Management Studio Express. SSMSE can be found here . A tutorial is available here . And the Books Online (the definitive learning and reference source) is available here . Referring to Books Online, refer to Topic: Walkthroughs [SQL Server...] Tag: query format date
  - 2
    - Foreach Loop - Value back to 0 Is the foreach loop evaluating the same variable, or are you using the variable for something else Script tasks can assign values to variables. Tag: query format date
  - 3
    - How to set douplicate id in sql server 2005? Don't select the typeID column in your OLE DB destination. Tag: query format date
  - 4
    - Programmatically aborting a package Are you trying to capture an error and then halt If so, there's always the FireError event that can be thrown. Tag: query format date
  - 5
    - SQL 2005 Management Studio Query Designer suggestions / questions No1. They are different cases. I treat it as context aware. No2. Stongly agree. it's common accepted shortcut. It should be consistent. Lots of shortcut in VS2005 are inconsistent in different versions. It's really frustrating. No8. I think the idear behind this design it just to save users' time. In most cases it actually does. And also you can easily change the connection to anyone you want. BTW: I'm curious about how could you find out so many secret shortcuts like ctrl+1, ctrl+2 ... Can it be found at the corner of some dialog or menu Thanks, Zuomin Tag: query format date
  - 6
    - Error on Date Data During Insert Are you sure the flat file source is mapped correctly, with correct lengths, and with a date/time format correct for DB_DBTIMESTAMP There should be other errors right next to the one you posted... Can you grab those as well Phil Tag: query format date
  - 7
    - Auto Filter in 2005 Reporting Services Hi, Reporting Services does not have the possibilities to do this. I think that according what you listed above you need to use a cube in case of reporting services. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog Tag: query format date
  - 8
    - ForEachLoop task not behaving as expected Do you have the tasks hooked together by precedence constraints (The green arrows ) Tag: query format date
  - 9
    - The variable "System::LocaleID" is already on the read list. What version of SQL Server 2005 RTM SP1 SP2 Tag: query format date
  - 10
    - Import and Export Data Wizard missing in SQL Server 2005 Express Edition Hi, BCP is documented in Books Online. SQL Express is a free product and not all features are included. In this version they removed the Import/Export wizard for a number of reasons. We're looking at alternative soluitons for a future version of SQL Express. Mike Wachal SQL Express team Tag: query format date
  - 11
    - Query problems - Group By and Latest date This should do the trick: SELECT [SerialNumber] ,Param1 ,MAX([TimeStamp]) FROM [Build Efficiency System].[dbo].[SSIS_SCANNERDATA_TBL] WHERE Test = 'T120' GROUP BY SerialNumber, Param1 ORDER BY SerialNumber You only need to take the max of your timestamp field (and remove it from the group by). The group by all fields is a bit extreme in the previous query (you could use the distinct keyword instead if you had apparent duplicate rows (i.e. replaced the part 3 times in a day). Tag: query format date
  - 12
    - Reporting Service Cache SSRS always performs user session caching for each parameter combination. If a subsequent request is sent before the session expires and includes the session identifier, the report will be displayed from the cached instance. The end user can click the Refresh Report toolbar button (not the browser Refresh button) to generate the report anew. Tag: query format date
  - 13
    - Newbie Parameter Problem I believe you have to declare the variable first and then use it the query.. DECLARE @CompanyName nvarchar(25) --Initilize the declared variable SELECT DISTINCT @CompanyName = AccountFamily FROM CallDataRecords -- use it SELECT Salutation, InboundTimeMS, OutboundTimeMS, ModifiedOn, IsRightParty, AccountFamily FROM CallDataRecords WHERE AccountFamily = @CompanyName AND ModifiedOn BETWEEN @StartDate AND @EndDate Hope this helps..... Tag: query format date
  - 14
    - Backup Database No....you are using NOINIT so you are appending backups to the device. You would use RETAINDAYS to throw up an error message if you try to do an INIT and you do a NOSKIP meaning that it will check to see if you have any backups that aren't yet expired. If there are backups not yet expired, you get an error. That's about all RETAINDAYS does - it won't maintain your history for you - it just keeps you from overwriting. -Sue Tag: query format date
  - 15
    - RESTORE DATABASE If the database is being newly created from a backup file proceed as shown below, RESTORE DATABASE dbname FROM DISK ='Path of your backup file' If the databasealready existing and you are going to overwrite it then proceed as shown below, RESTORE DATABASE dbname FROM DISK = 'path of backup file' WITH MOVE 'logical filename' TO 'path.mdf', MOVE 'logical filename' TO 'path.ldf' by default it will be in recovery only unless you explicitly specify it as norecovery hope this helps Tag: query format date
  - 16
    - problem with recursive cte query You can generate hierarchical XML using this CREATE FUNCTION dbo.SubTree(@TabId int) RETURNS XML WITH RETURNS NULL ON NULL INPUT BEGIN RETURN (SELECT ParentTabId as "@ParentTabId", TabId as "@TabId", Title as "@Title", Link as "@Link", tabindex as "@tabindex", dbo.SubTree(TabId) FROM Tabs WHERE ParentTabId=@TabId ORDER BY TabId FOR XML PATH('Tabs'),TYPE) END GO SELECT ParentTabId as "@ParentTabId", TabId as "@TabId", Title as "@Title", Link as "@Link", tabindex as "@tabindex", dbo.SubTree(TabId) FROM Tabs WHERE parenttabid = 1 ORDER BY TabId FOR XML PATH('Tabs') , ROOT('MyRoot'), TYPE Tag: query format date

daniel ku

Hi
I wrote query to get date from database SQL 2000 server. Sometime I get different date format not MMDDYYYY but number as Julian calendar Do you know what wrong with this How can I wrote SQL so that all date will be MMDDYYYY

Thanks

Daniel

Top

Re: query format date

hunchback

Try:

select replace(convert(varchar(10), [date_col], 101), '/', '') as [mmddyyyy]

from your_table

AMB

Top