That would only happen if PostCode is missing a space. You could add conditionality such that all of PostCode is retrieved should a space not be found as follows select SUBSTRING(PostCode, 1 , case when CHARINDEX(‘ ‘, PostCode ) = 0 then LEN(PostCode) else CHARINDEX(‘ ‘, PostCode) -1 end)
Here are 2 different ways, both are assuming the week starts on monday If you want weeks to be whole, so they belong to the month in which they start: So saturday 2012-09-01 and sunday 2012-09-02 is week 4 and monday 2012-09-03 is week 1 use this: DECLARE @date date=”2012-09-01″ SELECT (day(datediff(d,0,@date)/7*7)-1)/7+1 If your weeks … Read more
I think this is what we like to do very much. –Step 1: (create a new user) create LOGIN hello WITH PASSWORD=’foo’, CHECK_POLICY = OFF; — Step 2:(deny view to any database) USE master; GO DENY VIEW ANY DATABASE TO hello; — step 3 (then authorized the user for that specific database , you have … Read more
i’ve created the solution. SQL Server Compact Edition is comprised of 7 dlls: sqlceme40.dll The undocumented, native, flat API library (The .net System.Data.SqlServerCe.dll assembly is a wrapper around this dll) sqlceca40.dll A COM dll that implements Engine, Replication, Error and a few other COM objects sqlceoledb40.dll A COM dll that implements an OLEdb provider for … Read more
This is by far the best post for exporting to excel from SQL: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926 To quote from user madhivanan, Apart from using DTS and Export wizard, we can also use this query to export data from SQL Server2000 to Excel Create an Excel file named testing having the headers same as that of table columns … Read more
Your Call works if it were a Table Valued Function. Since its a scalar function, you need to call it like: SELECT dbo.fn_HomePageSlider(9, 3025) AS MyResult
Assuming the FirstName is all of the characters up to the first space: SELECT SUBSTRING(username, 1, CHARINDEX(‘ ‘, username) – 1) AS FirstName, SUBSTRING(username, CHARINDEX(‘ ‘, username) + 1, LEN(username)) AS LastName FROM whereever
OK, got it working. Turns out that an NTFS volume where the DB files were located got heavily fragmented. Stopped SQL Server, defragmented the whole thing and all it was fine ever since.
This did the trick for me. http://thecodeattic.wordpress.com/category/ssrs/. Go down to step 35 to see the error you are getting. Paraphrasing: Once you’re able to log in to YourServer/Reports as an administrator, click Home in the top-right corner, then Folder Settings and New Role Assignment. Enter your user name and check a box for each role … Read more
The usual way to store password, is to use a hash function on the password, but to salt it beforehand. It is important to “salt” the password, to defend oneself against rainbow table attacks. So your table should look something like that ._______._________________.______________. |user_id|hash |salt | |——-|—————–|————–| |12 |adsgasdg@g4wea…|13%!#tQ!#3t…| | |… |… | When checking … Read more