Viewing 15 posts - 4,216 through 4,230 (of 8,731 total)
All the options work if done properly, you might get better help if you share the errors you get or the problems you face.
September 11, 2015 at 9:31 am
This can help you find unicode characters that you might not want. It will return the string and the characters, you just need to change the test table to your...
September 11, 2015 at 9:25 am
You might have characters that are not NCHAR(65533).
You need to identify the characters that don't belong to your dataset.
CREATE TABLE #CharsTest(
nstring nvarchar(100));
INSERT INTO #CharsTest
VALUES
...
September 11, 2015 at 9:20 am
xynergy (9/11/2015)
Dude, I just went from 4 minutes to a few seconds on that task!Its pure awesomeness... Thanks both for your help... I'll carry on working on my frontend...
Cheers! :hehe:
A...
September 11, 2015 at 8:59 am
You can use BULK INSERT to import from a csv or (any flat file).
You can also use OPENROWSET to query the Excel file as a table and insert the rows...
September 11, 2015 at 8:55 am
Emil B (9/11/2015)
and was trying to find out what is the default behavior but it only says that:
If FORWARD_ONLY is specified without the STATIC, KEYSET, or...
September 11, 2015 at 8:36 am
Or at Jeff's series on cross tabs and pivots: Part 1[/url] & Part 2[/url].
Personally, I try it to keep it simple by using the concatenation method explained in here: http://www.sqlservercentral.com/articles/comma+separated+list/71700/
And...
September 11, 2015 at 8:28 am
Thank you for the reference on the article, but this problem doesn't seem to need a loop. A single update can do the job.
CREATE TABLE Table1(
EntryID...
September 11, 2015 at 8:10 am
I would use the Import/Export wizard that will create an SSIS package that you can save for future executions or dismiss after running it once.
It allows you to use queries...
September 11, 2015 at 7:45 am
That's easy, just add a where clause.
September 10, 2015 at 4:09 pm
Something like this?
--UPDATE t SET ID_NumofAttach = x.ID_NumofAttach
select *
from #temp t
CROSS APPLY (
SELECT SUM( CAST( i.ID_AttachLvl AS int)) ID_NumofAttach
FROM #temp i
...
September 10, 2015 at 2:13 pm
Your query will only return rows where the region starts by null, which is different from a NULL value.
To compare NULL values, you need to use IS NULL or IS...
September 10, 2015 at 2:05 pm
STATIC cursors create a copy of the data to keep it the way it was at the creation of the cursor. If not used, the cursor will continue to read...
September 10, 2015 at 11:49 am
Here are 2 (untested) options:
WITH CTE AS(
SELECT
V.VEND_ID
,...
September 10, 2015 at 11:39 am
Viewing 15 posts - 4,216 through 4,230 (of 8,731 total)