Viewing 15 posts - 2,986 through 3,000 (of 3,738 total)
Is that all of the error information that you have?
I'm not too clear what what you have done and why.
Here is a thread where someone got a similar error. I...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 20, 2011 at 9:45 am
I keep asking you for a little information but you don't provide and you keep comming back with questions.
Are you pulling my leg?:w00t:
http://www.sqlservercentral.com/articles/Best+Practices/61537
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 20, 2011 at 8:46 am
vultar (5/20/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 20, 2011 at 8:37 am
All that is required is to create a Julian Date Function:
http://www.sqlservercentral.com/Forums/Topic438807-8-1.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 19, 2011 at 4:20 pm
Sounds like a permissions issue.
When "connecting to any of our SQL instances via name in SSMS" What credentials is she using?
Have you checked her login and user account for the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 19, 2011 at 4:17 pm
prashantcomp90 (5/10/2011)
Then what changes I have to perform on table to get this output.
You tell me, you know your business.
prashantcomp90 (5/10/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 19, 2011 at 3:58 pm
Welsh Corgi (5/19/2011)
prashantcomp90 (5/19/2011)
SELECT accnm,debitamt,creditamt FROM groupGROUP BY supergrp
ORDER BY MAX(ID) DESC
WHERE supergrp = 'Assets')fs WHERE supergrp = 'Liability'
How did you come up with that?
I guess you have it...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 19, 2011 at 3:50 pm
prashantcomp90 (5/19/2011)
SELECT accnm,debitamt,creditamt FROM groupGROUP BY supergrp
ORDER BY MAX(ID) DESC
WHERE supergrp = 'Assets')fs WHERE supergrp = 'Liability'
How did you come up with that?
I guess you have it all figured...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 19, 2011 at 3:34 pm
prashantcomp90 (5/19/2011)
This is what i want. the queary pass in given example like that i want how to pass gruupby.how to make groupby to supergrp
Yes but I need...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 19, 2011 at 3:16 pm
king_emperor_in (5/19/2011)
The instance on which i want to perform...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 19, 2011 at 2:55 pm
prashantcomp90 (5/19/2011)
select accnm,debitamt,creditamt from group where supergrp = 'Assets'select accnm,debitamt,creditamt from group where supergrp='Liability'
now it should display seperate two outputs for assets and Liability.
No I don't think that is what...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 19, 2011 at 2:53 pm
prashantcomp90 (5/19/2011)
table
create table group
(
id numeric(25),
accnm varchar(100),
grpnm varchar(100),
supergrp varchar(100),
debitamt numeric(20),
creditamt numeric(20)
)
insert into group(id,accnm,grpnm,supergrp,debitamt,creditamt)
select 1,'abc','cash','Assets',10,10
select 2,'pqr','bank','Assets',20,20
select 3,'xyz','ss','Liability',30,30
select 4,'qq','loan','Liability', 40,40
now, i want to group by supergrp column to sort...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 19, 2011 at 2:35 pm
king_emperor_in (5/19/2011)
does this mean that i have to type "sqlservr.exe -m" after i type in...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 19, 2011 at 2:18 pm
thbaig1 (5/19/2011)
Welsh Corgi (5/19/2011)
thbaig1 (5/19/2011)
@col_name= column name coming rom cursor
@ColValue= will store column value
select @ColValue=@col_name
from dbo.tblBlo
WHERE Customer_no = @CustomerNumber
...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 19, 2011 at 2:13 pm
prashantcomp90 (5/19/2011)
I tell u from beginning.
I have one table name as ledger
in that column names are :
id,accnm, grpnm,supergrp,debitamt,creditamt.
now when i save data in ledger...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 19, 2011 at 1:49 pm
Viewing 15 posts - 2,986 through 3,000 (of 3,738 total)