I'm trying to SELECT all records where the Amount is a whole dollar. I need to exclude all records where the Amount field contains cents. Using Dinakar's suggestion:SELECT * FROM Sales WHERE CAST(Amount AS int) = Amountappears to give me what I need. I just need to verify that this is the correct syntax to […]
2005-05-26
2005-05-25
2005-05-25
Using the DATEPART function will not allow the optimizer to use the index on the reortsentdate column so your statement will force a table scan.For more info on how to work with sql server dates you might want to look at these articles: http://www.sql-server-performance.com/fk_datetime.asp http://www.karaszi.com/SQLServer/info_datetime.asp
2005-05-25
ok, here it is: Its not perfect, but it works.This is part of my code, so let me explain. The important stuff is highlighted. You have to get a hold of your Task object from the particular package object that contains the TransferObjectTasks. One bad part that I can't figure out is how many objects there […]
2005-05-24
OK. Makes perfect sense. Thanks for the 411. I'll take this under advisement and look into scripting more of my tasks whenever possible. LanMan
2005-05-24
And many things in file-based systems, like definite record numbers, simply do not exist in SQL server (and for good reason - it's a set of data. If you want it ordered, use an order by).Also... many of the systems like Fox/Access use cursors a great deal - server side cursors are usually the substitute […]
2005-05-24
Or you could keep your static SQL but rather than make use of your charindex statement, which cannot use any indices, you can use a UDF that returns a table. For example, this UDF will take a comma separated list of integers as a string and returns a table (I think I got this from […]
2005-05-24
Hi Amit, Given the following details could you please quickly put together a trigger to send the last added name. I plan to use xp_sendmail but still trying to configure the MAPI.UserID int 4 UserName nvarcahar 50 Password char 10 EMailAddress nvarchar 50Table name = Users SQL Database = EUTScheduleThanks in advance.
2005-05-22
Thank you Bimal I will give it a try
2005-05-18
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers