Forum Replies Created
Viewing 15 posts - 931 through 945 (of 1,183 total)
-
RE: Help in Pivot Query
P, What you want isn't actually a Pivot. Pivot will rotate the values from rows to columns but only if you have a predefined set of KNOWN values in the...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Help with query
That's what the OR part accomplishes.
All students not at M regardless of their career_level.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Help with query
SELECT site,campus_id, pin
FROM dbo.tblStudents
WHERE
-- get all students at site M that are not undergrads
(site = 'M' and...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Loop Query
*laughs* Well Jeff, I prefer to have my code ran and done quickly so I can go drink another...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Newbie: NOT EXIST or NOT IN?
Move your search criteria into a "table" left join from it to your tbl_orders as below ...
SELECT cols.col_number, col_status
FROM
(SELECT '123' AS col_number
UNION
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Loop Query
I haven't tested this, but it should work and NO Cursor! Except for the TOP 8 part. If you do in fact need the top 8 reply and someone or...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Identifying the same table (after a rename ) in different databases.
This may or may not help, have you looked into SQL Compare and SQL Data Compare.
http://www.red-gate.com/products/SQL_Compare/index.htm
http://www.red-gate.com/products/SQL_Data_Compare/index.htm
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Using select where in with variable
Look here ...
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=835
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Reporting services problem
Lisa,
That is exactly what I am seeing and can't find a solution. The weird thing is that the message can go to four different people, and three of them can...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: SQL server CE Connection
Have you tried without the ".\\" ?
Just using ...
SqlCeConnection con = new SqlCeConnection("Data Source =TestDB.sdf; Password =testdb;");
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Data Driven Subscriptions Updated
Yes and NO! There are all sorts of unique identifiers in the RS database and I really don't think you can just copy them over.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Data Driven Subscriptions Updated
David,
Are you saying that you have subscriptions set up in RS 2000 Enterprise using MS's interface, and you are attempting to re-create them in RS 2005 Standard without the interface...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Data Driven Subscriptions Updated
David,
I am unclear on what you are asking. What columns are returned from [Reports Ledger]
And the procedure should work the same in 2005 as it does in 2000.
Jason
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Count Distinct
What do you get when you run ...
SELECT TOP 100
dbo.[Web-Registration-Golf].Delegation AS Facility
,dbo.certifs.Owner
FROM
dbo.[Web-Registration-Golf]
LEFT JOIN dbo.certifs
ON...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Count Distinct
After looking closer, are you sure that counting on the StateID is appropriate? Wouldn't you use certifs.Misc or .Kind
just a thought...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg
Viewing 15 posts - 931 through 945 (of 1,183 total)