Forum Replies Created
Viewing 15 posts - 226 through 240 (of 253 total)
-
RE: Updating a table with only one occurence of row from another table
SELECTDISTINCT [Unique ID],SUM([Line Amount])FROM<tablename>GROUP BY[Unique ID] -
RE: Problem inserting a record where the string field contains an apostrophe in the value
If you use parameterized queries in asp.net you wouldnt have to do anything.
-
RE: Returning errors to Access from a stored procedure
Is the data that is going into the variables in the same format mm/dd/yyyy ?
-
RE: Returning errors to Access from a stored procedure
Does the stored proc run from Query Analyzer with hardcoded values for the parameters ?
-
RE: SELECT ALL FIELDS , best method ??
If all you want to do is get the count you might as well do aDECLARE @count INTSELECT@count = COUNT(*)FROM[vwDups]IF @count > 0... -
RE: Return identity inserted
Sorry I meant IDENT_CURRENT
-
RE: how to see "my forums"
May be you'all can use the Community Server forums that the ASP.NET site is using.
-
RE: Return identity inserted
Even SCOPE_IDENTITY when looked up in BOL has enough information about @@IDENTITY, IDENT_INDENT and SCOPE_IDENTITY() and which one of them is better.
-
RE: a trigger question
you can do :
Birthday = Sqldatetime.Null ' or even dbnull.value might work
And you would need to import the sqltypes namespace for this.
-
RE: difference between two resultsets
>>not in on 8 M records????????????????????????? I agree. I didnt look at the number of records being returned.. I was only thinking... -
RE: Changing color of comments in Query Analyzer
You are right..it applies to the entire Editor and not just for the selected part. I did play around with all the options and I doubt if you can do... -
RE: Up The Wall
red = string. as soon as you type a single quote anything typed after that becomes red until you close the single quote which marks the end of the string.
-
RE: difference between two resultsets
Perhaps something like this :Select e3a4.<PKCOlumn> --count(*)From dw_dsa.dbo.e3bdjr_a4bidm e3a4
Left Join dw_dsa.dbo.JobCostDimLookupTbl jcdl on e3a4.Job = jcdl.JOB
Left Join dw_sd.dbo.Job j on e3a4.Job = j.jobcode
Left Join dw_sd.dbo.CostCode cc on (e3a4.Job =...
-
RE: how to see "my forums"
Yes I saw that after posting here and playing around the site ( I am a little new around here as you can guess by my posts) but it doesnt... -
RE: difference between two resultsets
you can prbly use a LEFT OUTER JOIN or a RIGHT OUTER JOIN dpending on how you look at it..to get the nonmatching columns .. check out the Books On...
Viewing 15 posts - 226 through 240 (of 253 total)