Hello Arnie, Im new student to joined to this group. I like to learn more about relational database. Did i ask any rude or unwanted questions to this group....
2231
Habibulla M. Shaik
Habibullam@...
Jun 19, 2006 10:48 am
Hello all, Iam new to this group. I want to learn SQL SERVER 2005.can any one provide the information of book available , materials and links. Thanks in...
2232
John Warner
john@...
Jun 19, 2006 11:09 am
http://www.microsoft.com/sql/editions/express/default.mspx That gets you SQL Server 2005 Express edition (MSDE 2005) ...
2233
Arnie Rowland
arnie1568
Jun 19, 2006 3:11 pm
Thanks for the clarification. You'll have to admit that when you sent me the data file, and it had the name of Sam Kamalesan, it started seeming very odd. Is...
2234
Arnie Rowland
arnie1568
Jun 19, 2006 3:54 pm
Hi, The schema and data you sent seems to be incomplete. Your original query included columns SuppKey and Discount. Those columns are not in the datafile or...
2235
John Warner
john@...
Jun 19, 2006 4:47 pm
You're a better man then me Arnie, after so many tries at getting them to help me help them I give up. John Warner...
2236
Charles Carroll
charlesmarkc...
Jun 20, 2006 5:25 am
As creator and moderator I prefer we work ond SQLQueries Questions and Answers. Your mail was neither a query question, nor a query answer. I recommend if you...
2237
Arnie Rowland
arnie1568
Jun 20, 2006 6:00 am
Enough said. I shall refrain from any further engagement with Jane Angelina, Jane Elizibeth, jane_blue_angel, or Sam Kamalesan's questions or problems in order...
2238
syravirgo
Jun 20, 2006 12:47 pm
Hello all i have a status field in table attendance in SQL Server status ... Present Present Absent Absent Present Leave Leave Present I want to count number...
2239
John Warner
john@...
Jun 20, 2006 1:02 pm
Need more info, how do I know the first Present is for you and the second present is for Jane? Or do you just want total Present, total Absent etc? John Warner...
2240
my.yudis
drury_yl
Jun 20, 2006 1:04 pm
select xx.status as present, yy.status as absent, zz.status as leave from ( select 'a' as dummy, count(status) as status from temp where status = 'Present' )...
2241
Arnie Rowland
arnie1568
Jun 20, 2006 2:15 pm
You could try something like this: SELECT Employee --Name or ID , sum( CASE Status WHEN 'Present' THEN 1 ELSE 0 END ) AS 'Present' , sum( CASE Status WHEN...
2242
Mayowa Omosebi
magbu2000
Jun 20, 2006 3:33 pm
you can try this: select employee_name, status,count(status) from your _table group by employee_name,status --employee_name could be any field that uniquely...
2243
rherrmann05@...
bh0526
Jun 20, 2006 4:50 pm
Hi all, I am having a problem with my datetime parameter I am passing to my SQL statement. Here is the SQL code: CREATE PROCEDURE...
2244
Arnie Rowland
arnie1568
Jun 20, 2006 6:07 pm
Use the same concept that you used to pass the @Category variable into the @SQL statement. (For both @StartDate and @EndDate.) In your code, you concatenated...
2245
Michael Weiss
mweiss@...
Jun 20, 2006 7:34 pm
Hi Bob, You need to treat your date params just like you do the category param like: CREATE PROCEDURE [dbo].[sp_GetSelectedProducts1] @Category1 varchar(50), ...
2246
Arnie Rowland
arnie1568
Jun 20, 2006 8:26 pm
Michael, You forgot that it is necessary to triple up on the single quotes on both sides of the date variables. As you corrected the @SQL String below, it will...
2247
rherrmann05@...
bh0526
Jun 20, 2006 8:41 pm
Michael / Arnie: Thanks for your responses. It works now! Bob ... From: "Michael Weiss" <mweiss@...> Hi Bob, You need to treat your date params...
2248
Ax
kantsoul
Jun 26, 2006 12:32 pm
Hi all, I make a search using sql select query and I send pararmeters to it : SELECT CID, CategoryName FROM Categories WHERE CategoryName =...
2249
Jeffrey Schoolcraft
m005838
Jun 26, 2006 1:24 pm
if you set @CategoryName to null then you could do something like this: SELECT [CID] ,[CategoryName] FROM [dbo].[Categories] WHERE [CategoryName] =...
2250
rherrmann05@...
bh0526
Jun 28, 2006 4:54 pm
Hi all, I have the following SQL code in my stored procedure. I have simplified it for readability: SELECT LaborCost, WhseCost, Hours, Qty, LaborCost * Hours...
2251
Arnie Rowland
arnie1568
Jun 28, 2006 5:04 pm
The most efficient way, since all the data is in the same table, is to repeat the formulas -as you expected. You could use a table variable, #Temp table,...
2252
rherrmann05@...
bh0526
Jun 28, 2006 5:59 pm
Ok, great! This is the easiest option for me. I never knew that SQL would know it already calculated this new field. Thanks, Bob ... From: "Arnie Rowland"...
2253
John Warner
john@...
Jun 28, 2006 6:07 pm
You basically will need to do it all in one calculation without the intervening aliases if you are after 'speed/performance'. (LaborCost * Hours) + (WhseCost *...
2254
rherrmann05@...
bh0526
Jun 28, 2006 8:04 pm
John, Yes, this is exactly what I am trying to get the users to agree to. Right now they want to see the detail AND the totals. I greatly simplified these...
2255
John Warner
john@...
Jun 28, 2006 9:11 pm
If you have to have the intermediate values, I'm not sure but that I would create a multiple select arrange and compute the values desired. If this is...
2256
Arnie Rowland
arnie1568
Jun 29, 2006 12:03 am
If this operation is to work against "about 5 million rows of data", I think that any Temp table solution will most likely incur substantial I/O as it writes...
2257
Its me
kantsoul
Jun 29, 2006 3:50 am
Hi all, My table containes DateExpire column. I want the rows that reache the expiration date (in DateExpire) be deleted automatically. Can L let SQL Server do...
2258
Arnie Rowland
arnie1568
Jun 29, 2006 5:56 am
Yes, you can create a SQL job that runs every night (or whatever time interval you desire) and executes a DELETE query. - Arnie Rowland "I am a great believer...
2260
Chandra
yochan_3000
Jul 4, 2006 12:43 pm
Hello all I have a problem with this issue: I have tables with field like this : Name | Job | Start Date | Duration ( days ) A FIN...
