I Give Up On This One...

Jul 20, 2005

I have tried and tried to get this to work and I'm doing something dumb.
I'm going to include sample data and my format file. Can someone help
me figure out my dumb mistake on a bulk insert using a format file?
Don't worry about data types, I'll handle that later. Thanks a lot!!!

CSV File:

ID,NAME,SPEC_ORIGINAL,SPEC,CATEGORY,ADDRESS1,CITY, STATE,ZIP,PHONE,COMPET
ITOR,PLAN,HARVESTDATE,EIDs,EIDCount,sourceIds,minS core,maxScore,hasContr
act,matchFilter,matchFilterBGR,matchFilterCAS,matc hFilterMTV,forceMatch,
forceMatchUserId,paymentPlatforms,matchStatusColor ,recordId,dupId,Networ
kComparedTo
1,name1,Family Practice General Practice,FP,PCP,address1,Deerfield
Beach,FL,33442,phone1,C1,PPO,5/15/2004,1000067851,2,BADG_0874992,9,14.4,
Y,Y,Y,Y,Y,0,,3,G,1, ,netcomp1
2,name2,Family Practice General
Practice,FP,PCP,address2,Margate,FL,33063,phone2,C 2,PPO,5/15/2004,100006
7851,2,BADG_0874992,9,10,Y,Y,Y,Y,Y,0,,3,G,2, ,netcomp2
3,name3,General Practice,GP,PCP,address3,Deerfield
Beach,FL,33442,phone3,C3,PPO,5/15/2004,1000067851,2,BADG_0874992(14.4
Y)|BADG_1901859,9,14.4,Y,Y,Y,Y,Y,0,,3,G,3, ,netcomp3
4,name4,Reproductive
Endocrinology,OBEN,OB,address4,Davie,FL,33328,phon e4,C4,PPO,5/15/2004,10
00083687,1,CAS_650410436,10.3,10.3,Y,N,N,N,N,0,,0, Y,4, ,netcomp4


Format File:
8.0
31
1 SQLCHAR 0 1 "
" 0 quote Latin1_General_CI_AS
2 SQLCHAR 0 3000 "," 1 Provider_Raw_ID Latin1_General_CI_AS
3 SQLCHAR 0 3000 "," 0 none_name Latin1_General_CI_AS
4 SQLCHAR 0 3000 "," 0 none_Spec_orig Latin1_General_CI_AS
5 SQLCHAR 0 3000 "," 3 SpecialtyCode Latin1_General_CI_AS
6 SQLCHAR 0 3000 "," 2 Category Latin1_General_CI_AS
7 SQLCHAR 0 3000 "," 0 none_Address Latin1_General_CI_AS
8 SQLCHAR 0 3000 "," 0 none_City Latin1_General_CI_AS
9 SQLCHAR 0 3000 "," 0 none_State Latin1_General_CI_AS
10 SQLCHAR 0 3000 "," 0 none_Zip Latin1_General_CI_AS
11 SQLCHAR 0 3000 "," 0 none_Phone Latin1_General_CI_AS
12 SQLCHAR 0 3000 "," 0 none_Competitor Latin1_General_CI_AS
13 SQLCHAR 0 3000 "," 0 none_Plan Latin1_General_CI_AS
14 SQLCHAR 0 3000 "," 0 none_HarvestDate Latin1_General_CI_AS
15 SQLCHAR 0 3000 "," 0 none_EIDs Latin1_General_CI_AS
16 SQLCHAR 0 3000 "," 5 EIDCount Latin1_General_CI_AS
17 SQLCHAR 0 3000 "," 0 SourceIds Latin1_General_CI_AS
18 SQLCHAR 0 3000 "," 6 minScore Latin1_General_CI_AS
19 SQLCHAR 0 3000 "," 7 maxScore Latin1_General_CI_AS
20 SQLCHAR 0 3000 "," 8 hasContract Latin1_General_CI_AS
21 SQLCHAR 0 3000 "," 9 matchFilter Latin1_General_CI_AS
22 SQLCHAR 0 3000 "," 10 matchFilterBGR Latin1_General_CI_AS
23 SQLCHAR 0 3000 "," 11 matchFilterCAS Latin1_General_CI_AS
24 SQLCHAR 0 3000 "," 12 matchFilterMTV Latin1_General_CI_AS
25 SQLCHAR 0 3000 "," 13 forceMatch Latin1_General_CI_AS
26 SQLCHAR 0 3000 "," 14 forceMatchUserId Latin1_General_CI_AS
27 SQLCHAR 0 3000 "," 15 paymentPlatforms Latin1_General_CI_AS
28 SQLCHAR 0 3000 "," 16 matchStatusColor Latin1_General_CI_AS
29 SQLCHAR 0 3000 "," 17 recordId Latin1_General_CI_AS
30 SQLCHAR 0 3000 "," 18 dupId Latin1_General_CI_AS
31 SQLCHAR 0 3000 "," 4 NetworkComparedTo Latin1_General_CI_AS

Here's a script for the table!

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Provider_Results]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[Provider_Results]
GO

CREATE TABLE [dbo].[Provider_Results] (
[Provider_Raw_ID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Category] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SpecialtyCode] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[NetworkComparedTo] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[EIDCount] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[minScore] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[maxScore] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[hasContract] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilter] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilterBGR] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilterCAS] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[matchFilterMTV] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[forceMatch] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[forceMatchUserId] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[paymentPlatforms] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[matchStatusColor] [varchar] (3000) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[recordId] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[dupId] [varchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

Thanks again. I am dying on this one. With everything included
hopefully someone (smarter than me) can figure it out.

Thanks,

Andrew



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

View 2 Replies


ADVERTISEMENT

Nu Ger Jag Upp (I Give Up)

Feb 5, 2008



Jag har installerat sql server 2008 (I have installed sql server)

I cannot find enterprise manager - I think that the sql server is useless unless there is a manager.

View 1 Replies View Related

Sql - If Not Found, Give Name

Mar 13, 2007

Been trying to get this one but need a little input.
SELECT a.Id,g.LabName......
FROM someTbl a,table g
WHERE a.id = @idAND (b.calLab = g.ID OR g.LabName = ???)
With the above, if b.calLab = 0 then there is no entry in table g.(I didn't develop the table or would have included NONE)
So, how to tell g.LabName to come back as 'None' if b.calLab = 0?
Thanks,
Zath

View 2 Replies View Related

Give All Results Even When Not Available

Oct 15, 2007

Hello I have a problem with a query..
What I want:
I have a query that selects from different tables:

Code:

SELECT * FROM table1 as t1 ,table2 as t2 WHERE t1.t2_Id = t2.Id


But now I want all results from table1 even if it's not linked with table2, if that's the case i want to add something like:

Code:

CASE
WHEN 'notlinked' THEN 1
ELSE 0
END HighLight


that way I can show the rows that have to be manually linked
hope you understand my problem...

thanks!

View 1 Replies View Related

Someone Can Give A Litgh?

May 17, 2004

Hi Everybody,

In a table there´s a field for store real values,
so...in the database, using the SQL Server Enterprise Manager
and execute query as 'select * from' and it return the value
'15,35' just like stored before, why using Delphi via an ADO conection
in my result set there is a '15,3500003814697' value if in the record time
the inputed value was '15,35'?
What I have doing wrong?

View 1 Replies View Related

Would You Like To Give Me Some Advice

May 28, 2004

hi,everyone
i use sybase before,and i want to learn ms sqlsr2000,can anybodu give me some advice,or give me some matrial
thx in advance

View 5 Replies View Related

Please Give Me Answer

May 20, 2008

batch processing means

View 3 Replies View Related

Getting Day If We Give Date

Jan 3, 2007

hi,
i want to get day if we give date.ie if i give 03-01-2006 it has to give day as wednesday.so what ever date if i give it has to give the day of the date.can any one please give me query for this

View 2 Replies View Related

Can Anyone Give Me A Query For This ?

Jul 20, 2005

These are my table structures . Could you please suggest me analternative:tblArticles: ArticleID,Title,Summary,ContextSubTypeID,PostDatetblArticlePages: ArticlePageID,ArticleID,PageNum,ContenttblAuthors:AuthorID, NametblArticleAuthors:ArticleID,AuthorIDtblContextSubtype:ContextSubTypeID,NameI need to get Author,PostDate,Title,tblContextSubType.Name,PageN um,Content,- these have to grouped accordingly by the respective fields. Contentneed not be grouped by.

View 2 Replies View Related

Re:Please Give Me Ur Suggestion

Nov 13, 2007

Hi
I am new to Sql Server

I have to select all fields from a table based on min(date) . i have duplicate accountnumbers in the query i need to eliminate that based on min(dateTime).
when i am writing a query

Select a,b,c,min(d) from table , it is not working?
Below is the example


A B C D
222 1 11 2007-02-12 14:09:16.000
222 1 8 2007-11-06 13:57:18.480



Any suggestions would be very helpful

View 3 Replies View Related

Give Sql Query For This Illustrations

Mar 28, 2008

Hai friends
 i have table student with 2 fields s_id,s_name
s_id      s_name1            raja2           ramu3           vinoth4            muthu5            arun
i have another table test with s_id who wrote test...
s_id    25
now i have to display like below....give me sql query
s_id   s_name2        ramu5        arun
Thanks in Advance...pl Help me......  

View 2 Replies View Related

Give Me Sql Query For One Illustrations

Mar 28, 2008

Hai friends i have table
s_team
id           name       game
 1           raja         cricket
2            ravi          football
3            muthu     cricket
4           pravin      cricket
5          hurry       football
 I have to diplay the above table in the following ...pl give me sql query
game          totalplayers
cricket            3
football           2
 

View 2 Replies View Related

Any Solution For This??Please Give Some Suggestions

Dec 11, 2001

I have started working with MS SQL Server 2000 recently. I have a scenario in which I require to know within the given period of time ( say 5 mins) , which all tables from a particular database got modified. I do not want to write a trigger for each and every table for all the 13 databases , my application deals with. I have even tried the following query:
declare @curdate datetime
select @curdate=getdate()
select name, refdate from sysobjects
where xtype = 'U' and refdate =@curdate

But nope it does not help me, since refdate is something else. Can anybody tell me how can you figure out from sysobjects when was a particular object last accessed , even this would serve my purpose.

I have trying to get this done via profiler. My applications api's connect to the database under some credentials which i do not know since I do not have access to source code ( i am doing black box testing). So I can't even put a trace on one particular user account. What I am doing currently is trapping all store procedure events..., but then its too much of work...

Hence I wanted to know , is there any way out for the situation where given a database name and a time span we can find out the tables modified/accessed within that time span from that database ???

View 3 Replies View Related

Xp_logingrant.......Can Anyone Give Me This Script

May 27, 1999

CAn you please give me a copy of this script...
THANK YOU...

View 1 Replies View Related

To Give A Table Lock

Oct 14, 2005

How can i give a table wise exclusive lock in MSSQL Server ?

I got the description but, How can I apply this ?
The sql :
LOCK TABLE <tablename> IN EXCLUSIVE MODE
is not working.

Is there any query/method to do this ?
Please help ...

thanks


About Exclusive locks
--------------------
Exclusive (X) locks are used for data modification operations, such as UPDATE, INSERT, or DELETE.

Other transactions cannot read or modify data locked with an Exclusive (X) lock. If a Shared (S) exists, other transactions cannot acquire an Exclusive (X) lock.
--------------------

View 2 Replies View Related

Bcp Command To Give Colums

Jan 8, 2004

Can someonte tell me that if i
bcp bda..mytable out c:discounts.xls -c -p , how can I put the first row as my column names since I get only data

View 2 Replies View Related

How To Give More Space For My SQL Database

Jan 11, 2007

(Please Rush)

Hi all,

I am using SQL SERVER 2000 now, and my SERVER is still have about 27 GB but in my database is saying only 3.4 MB left, I was trying to shrink my database but it is still did not give me more space.

Do you know any way could help me to extend more spaces for my database?

I also included the picture so could help you more

Thank you very much

vdang (vdang2003@sbcglobal.net)

View 4 Replies View Related

Where...Can It Give You The Most Recent Entries?

Jun 12, 2007

SELECT post.C_ID, post.Comment, post.Title, post.Date, authors.U_Name
FROM authors INNER JOIN
post ON authors.A_ID = post.A_ID
ORDER BY C_ID DESC

That's the query I'm using, and I was hoping there is a way to use the WHERE clause to have only the 5 highest #'s from my primary key, which is A_ID IDENTITY(1,1).

What would be the best way for me to do this? I also have date as a datetime, but then I could be getting more or less than 5 results in my query.

Thanks

View 3 Replies View Related

Wht Does This Give Divide By 0 Error?

May 24, 2007

I am using iif which works just fine in Access to prevent divide by zero errors but this:



=iif(Fields!oh_ret.Value<>0,(Fields!oh_ret.Value-Fields!oh_cost.Value)/Fields!oh_ret.Value,"")



Fails



As Does:





=iif(Fields!oh_ret.Value=0,"",(Fields!oh_ret.Value-Fields!oh_cost.Value)/Fields!oh_ret.Value)



Why? How do I get around this?

View 4 Replies View Related

Plz Help Me How To Give Reportname In Reportexecutionservice

May 14, 2007

Hi



Im trying to load a report using

Reportexecutionservice



like this

Reportexecutionservice.ExecutionInfo exinfo=res.LoadReport(reportname, null);



rptname consists of report which is present @ my server.How to give reportname inorder to load a report .im using reportingservice2005

plz do help me.



error im getting Unable to indentify the report.Plz tell what is path i should given in order to acces th report..

View 5 Replies View Related

Anyone Give Solution(stored Procedure)?

Feb 28, 2008

 Table:Questionforum_id   quest_id          question                               description         quest_raised_by    raised_date             alert_me     approval  no_of_hits16             1    What is diff between asp and asp.net?    <Binary data>    JOHNYJP        2/27/2008 5:32:38 PM      True        True       NULL4               1     test question?                                     <Binary data>    SAMUEL        2/25/2008 12:25:05 PM      False        True       317             1    diff between asp.net1.0 and 2.0?            <Binary data>    MICHEL        2/27/2008 6:07:56 PM         False        True        315             2    What is diff vb6&vb.net?                        <Binary data>    MICHEL        2/27/2008 6:32:52 PM         True        True          514             1    what are features available?                   <Binary data>    RAGAVAN        2/26/2008 12:11:06 PM    True        True          915             1    VB6 tutorial..                                       <Binary data>    RAGAVAN        2/26/2008 12:12:29 PM       True        True        NULL14             2    Tell about access?                               <Binary data>    RAGAVAN        2/26/2008 12:14:09 PM       False       True         514             3    how to create grath in excel?                <Binary data>    SAMUEL        2/26/2008 12:23:31 PM        True        True          714             4    test1                                                  <Binary data>    MICHEL        2/27/2008 6:34:08 PM           True        True          24               2    new quest?                                        <Binary data>    SAMUEL        2/27/2008 6:38:20 PM          True        True           18               1    test quest for html?                            <Binary data>    GANESH        2/27/2008 6:41:07 PM          True        True         NULL4               3    test html tag2                                   <Binary data>    GANESH        2/27/2008 6:44:24 PM           False        True           NULL8               2    hello its for test?                              <Binary data>    MICHEL        2/27/2008 6:46:13 PM              False        True          NULL21             1    What is the new feature ?                  <Binary data>    SAMUEL        2/28/2008 9:30:43 AM            False        True         NULL22             1    What is the new feature ?                 <Binary data>    SAMUEL        2/28/2008 9:32:14 AM             True        True       NULL23             1    Is orcas released?                            <Binary data>    SAMUEL        2/28/2008 9:33:18 AM            True        True           NULL16             2    Test page for html code!!!!!!!....           <Binary data>    SAMUEL        2/28/2008 9:36:50 AM           True        True           417             2    explain with details?                         <Binary data>    SAMUEL        2/28/2008 4:46:08 PM             True        True         NULLTable:Replyforum_id   quest_id          ans_id     answer          reply_by        reply_on                    alert_me14        3                           12    <Binary data>    MICHEL    2/28/2008 3:57:46 PM    True4         1                               8    <Binary data>    GANESH    2/27/2008 4:46:52 PM    NULL15        2                            13    <Binary data>    SAMUEL    2/28/2008 4:20:36 PM    False4         2                             14    <Binary data>    SAMUEL    2/28/2008 4:46:39 PM    False14        3                            15    <Binary data>    GANESH    2/28/2008 4:49:12 PM    True14        2                           16    <Binary data>    GANESH    2/28/2008 4:50:01 PM    False16        2                           17    <Binary data>    GANESH    2/28/2008 4:51:02 PM    True17        1                            9    <Binary data>    MICHEL    2/27/2008 6:08:32 PM    NULL17        1                           10    <Binary data>    SAMUEL    2/27/2008 6:25:40 PM    NULL16        2                             11    <Binary data>    SAMUEL    2/28/2008 9:40:41 AM    NULLThis is my table structure.when i pass value only to 'quest_raised_by' field in question table.but I want following result,suppose i pass quest_raised_by='SAMUEL'forum_id   quest_id   quest_raised_by  ans_id   no_of_reply      answer          reply_by        reply_on                    alert_me      4                    1       SAMUEL                 8            1          <Binary data>    GANESH        2/27/2008 4:46:52 PM    NULL14                   3      SAMUEL                 15           2        <Binary data>    GANESH        2/28/2008 4:49:12 PM    True4                     2    SAMUEL                 14            1        <Binary data>    SAMUEL        2/28/2008 4:46:39 PM    False21                   1    SAMUEL                  -              0            -    -        -            -22                   1    SAMUEL                 -                0            -    -        -            -23                  1    SAMUEL                  -                0            -    -        -            -16                  2    SAMUEL                   17            2        <Binary data>    GANESH        2/28/2008 4:51:02 PM    True17                  2    SAMUEL                  -                0            -    -        -            -Any one give storedprocedure as soon as posible.Thanks,Durai            

View 4 Replies View Related

Give Solution Using Stored Procedure?

Feb 29, 2008

username      work_date               no_of_working_hours(nvarchar)a                02/17/2008                  0:50 a                02/18/2008                  0:50 a                02/23/2008                  0:20b                02/18/2008                  0:30 b                02/23/2008                  0:30 b                02/24/2008                  0:30 suppose i pass work_date from 02/18/2008 to 02/23/2008.i want following result username     total_no_of_working_hours(nvarchar)a                      1:10b                      1:00 How to write stored procedure?Thanks,Durai   

View 7 Replies View Related

Why Doesnt BETWEEN Give Me My Desired Result?

Dec 9, 2005

I am trying to select records based upon last name
WHERE     (Last_Name BETWEEN 'A%' AND 'C%')
When I run this I get only last names starting with A and B--no C. ?!?
This is confusing to me....I ran it with lastname >= 'A%' and lastname <='C%'and it returned only names starting with B. Why does SQL ignore the "="
I hope this isnt obvious :/
 
 

View 6 Replies View Related

Can You Give Me A Free Version Of &#34;Log Explorer&#34;

Aug 20, 2001

Can you give me a free version of "Log Explorer"

View 2 Replies View Related

How Give Right To Backup All Databases To NT Account

Jan 8, 2002

Hello , everybody

Is possible to set up server role to NT user in order to backup ONLY
any databases on server (nothing alse )

Now I am specifying this user as backup operator to each database

This NT account is domain account used to run Backup.exe software

Thank you

View 1 Replies View Related

CASE Does Not Give Correct Result

Aug 31, 2007

How do I automatically assign a new cardcode-number? (according to the following formula: highest existing number + 1)

Scenario:
-There are two types of business partners: Customers and Suppliers.
-Customers have the value 'C' in the colomn CardType.
-Suppliers have the value 'S' in the colomn CardType.
-Customers have the following syntax 'C123456' in the colomn CardCode.
-Suppliers have the following syntax 'S123456' in the colomn CardCode.
-Existing CardCode-values in the DB for the Customers: C000001 - C100599.
-Existing CardCode-values in the DB for the Suppliers: S000001 - S200199.

The idea is that when a user creates a new business partner, the CardCode should be automatically filled when a new assigned number (highest existing number + 1), according to the value that is selected in CardType (either the letter 'C' or 'S').


What's been done so far:
SELECT top 1
(CASE
WHEN CardType='C' THEN (SELECT top 1 'C' + '' + cast((substring(T0.CardCode, 2, 7) + 1) as varchar) as [nummer]
FROM OCRD T0
WHERE T0. CardCode like 'C%' AND T0. CardType='C'
order BY T0.CardCode desc FOR BROWSE)
WHEN CardType='S' THEN (SELECT top 1 'S' + '' + cast((substring(T0.CardCode, 2, 7) + 1) as varchar) as [nummer]
FROM OCRD T0
WHERE T0. CardCode like 'S%' AND T0. CardType='S'
order BY T0.CardCode desc FOR BROWSE)
END)
FROM OCRD T0


The current result:
The result that it gives is 'C100600'.
The problem however is that it always gives this result and does not take into account what has been selected in CardType.

When I add the following: "order BY T0.CardCode desc FOR BROWSE" it gives the result 'S200200'.

So, what does work is that it takes the highest existing value and adds 1. But what doesn't work is the taking account what value is selected in CardType.

Does anyone know how I can make this work?

View 4 Replies View Related

Someone Can Give A Litgh? - Field Type

May 17, 2004

Hi Everybody,

In a table there´s a field for store real values,
so...in the database, using the SQL Server Enterprise Manager
and execute query as 'select * from' and it return the value
'15,35' just like stored before, why using Delphi via an ADO conection
in my result set there is a '15,3500003814697' value if in the record time
the inputed value was '15,35'?
What I have doing wrong?
Thanks for attention

Leonardo Almeida

View 2 Replies View Related

T-SQL (SS2K8) :: Give Point And Set The Score

Aug 12, 2014

I've table and data as following,

CREATE TABLE [dbo].[x_SCORE](
[idx] [int] IDENTITY(-2147483648,1) NOT NULL,
[CVID] [int] NOT NULL,
[myGender] [char](1) NULL,
[whatGender] [char](1) NULL,
[point_Gender] [tinyint] NULL,

[Code] ....

So, my table and data must be as following,

This is the calculation for CVID=1449

1- myGender=M
2- whatGender=M
3- point_Gender=4
4- So, score_Gender=4

5- myBMI=23.53
6- min_BMI=20.22
7- max_BMI=30.00
8- point_BMI=3
9- myBMI is between 20.22 and 30.00
10- So, score_BMI=3

This is the calculation for CVID=1925

1- myGender=F
2- whatGender=M
3- point_Gender=4
4- So, score_Gender=0

5- myBMI=35.43
6- min_BMI=20.22
7- max_BMI=30.00
8- point_BMI=3
9- myBMI IS NOT between 20.22 and 30.00
10- So, score_BMI=0

After calculation, my data should be as following :

The variant for each row IS SAME. See as following :

View 1 Replies View Related

Give Results Even If Two Tables Used Don't Match

Aug 12, 2014

I have a table of customer information (ci), but I have to link to another table in order to get the street address (sa).

If I exclude the street address I get 33 results. If I make the link to street address I will only get 30 results.

What I found is that if the ci table field for country is blank and I try linking to sa table then that result will not be shown.

Is there a way to get all 33 results while linking the two tables?

View 4 Replies View Related

How To Give The Grant On Store Procedures

Dec 19, 2007

hello i am new to sql server 2000.

i am one of the user of database and in that user i created store procedures.

now i want to create another user and give that user to permission of excute all my proceudres and i also give him privillages such a way that user can also modify my procedures...

so can u assist me on that...

thanks in advance...

View 5 Replies View Related

How To Give Permissinon To Folders In SSRS

Mar 26, 2008

Hi,


I have one query in sql server reporting services securities.

In ssrs i have folders like(Custom reports, testreports,...). these folders are having reports. In this i want to give permissions to folders means if i gave permission to user1 to access the custom reports folder then he is able to access to that folder only and he is not able to access to any other foldes. How to give permissions to folders.

Pls any one help me on this.



Thanks
Ravuri

View 3 Replies View Related

How To Write A Logic ( Give To Same Suggation )

May 20, 2008

View 1 Replies View Related

How To Give Priority Processing To Certain Logins

Dec 3, 2007



Not sure if this is the forum to post this question to - if there's a more appropriate forum please let me know.

I have a SQL Server 2005 box which gets accessed in two ways - an application with it's own login and sprocs which get accessed through reporting services with its own login. What I've found is that the application will get timeouts on its queries when people are running reports which use time intensive sprocs (> 1 minute to run).

Is there a way to give a particular login a higher priority so that it won't timeout when other logins access these sprocs?

Thanks!
Craig

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved