|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Query Help required Urgent Posted by Jami at 2/17/2007 9:53:07 PM
Hi
i have following two tables and sample data
create Table Main_Tab (E_no int,EName varchar(30),FName
Varchar(30),Ph_no varchar(10))
go
insert into Main_Tab values (1,'Salim','Malik','121112121')
insert into Main_Tab values (2,'Zahid','Rauf','32223233')
insert into Main_Tab values (3...more >>
My Trick How To Use Getdate() In Function Posted by Taha at 2/17/2007 9:50:13 PM Hi All
This is My Trick To How To use Getdate() In User Defined Function In Sql
2000
DECLARE @Getdate smalldatetime
DECLARE @objectFSO int
DECLARE @objectFile int
DECLARE @hr int
DECLARE @FileLocation VarChar(255)
set @FileLocation = 'c:\1.txt'
declare @DateModified smalldatetime
EXEC @...more >>
Scripting GRANT permission to role Posted by brett at 2/17/2007 8:17:07 PM I'd like to GRANT execute permission across a schema to a role. What
does that syntax look like? It seems you can only grant permission to
an object, not a schema, and a user but not a role. Right now, I'm
right clicking a sproc, manually adding roles and granting them
execute permissions.
...more >>
select top (select count(*)/4 from tbl1) * from tbl1 - how to do t Posted by Rich at 2/17/2007 8:06:05 PM Greetings,
I need to select a quarter of the rows from a table. I tried this syntax
with no luck
select top (select count(*)/4 from temp1b) * from temp1b
my alternative is to do this:
Declare @i int
Select @i = Count(*)/4 From tbl1
Select top @i * from tbl1
What is the correct sy...more >>
A tricky query. Posted by Rick at 2/17/2007 4:30:11 PM Hi all...
I would like to know how it is possible to make my problem below all in ONE
query or stored procedure.
I select some rows from a table where the resultset is one column with some
values. Lets say 1, 4 and 7:
row val
1 1
2 4
3 7
Then I would like these results t...more >>
should be easy trigger won't run need help PLEASE Posted by Cynthia at 2/17/2007 2:45:08 PM I am trying to change a text field t omatch another text field based on a 1
to 0 checked field the text I am retrieving is in commondata table the check
box and text I am filling in is in solodata table these tables are linked by
a components table. below is the code.
Also where can I read u...more >>
REPLACE and smaller replacement - trailing spaces Posted by jobs at 2/17/2007 2:32:31 PM I have a string I want to replace. I noticed if the replacing string
is smaller it leaves behind trailing spaces. This would not be a
problem, except sometimes there are legitimate spaces surround the
string I want to replace that I do not want to remove.
set @parmout = replace(@parmin,@wordwr...more >>
Decrypt/Encrypt stored procedure using SQLDMO Posted by Wes Stebbins at 2/17/2007 12:45:32 PM I'm writing an application to allow our customers to download custom stored
procedures to their sites. Using SQLDMO, s there any way I can
programmatically decrypt a stored procedure (to get the text of the stored
procedure) and then encrypt it again after it is download to a user's site?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Howto delete dups from query Posted by Kodiak at 2/17/2007 11:09:54 AM I have this data in a temp table with 3 columns and I cannot figure
out how to get rid of the duplicate rows. I have tried using queries
with Group By clause but I still get the same result below every
time. If any one can please help be with this problem I would
appreciate it!
-83.94 1020...more >>
How do I back up a table Posted by Al at 2/17/2007 10:47:03 AM I am new to SQL server 2005. I wrote a sp that would delete a record from a
table. I would like to make a copy of the table within the same database and
call it tbl_bkup before I run my stored procedure. what is the best way to do
that?
thanks
Al...more >>
please help with distinct query ... Posted by pxpilot at 2/17/2007 10:41:04 AM Hi Guys,
I need some help with this query ASAP! I am a DB newby and this
doesn't sound too hard but I can't figure it out.
The example data below is in an MS SQL table that is designed to serve
as a transaction log.
I want to query this table to return the last record (Max(date) ?) for
each ob...more >>
Stripping out string patern from variable - like regex? Posted by jobs at 2/17/2007 7:03:35 AM say I have
set @myvar = 'xxxxxxxyyyyy*something*dkdkdkdkdkd.txt'
any way for me to strip out "something" in T-SQL?
Thanks for any help or information.
...more >>
SSRS 2000 and Vista Posted by Mike P at 2/17/2007 5:35:25 AM I am trying to open a SQL Server Reporting Services project on Vista
that was created in VS 2003, but I get the error :
'The application for project projname.rptproj is not installed. Make
sure the application for the project type is installed'
Anybody have any ideas what this means and how...more >>
SQL Server Management Posted by scooby at 2/17/2007 2:19:20 AM Hi all
Has anyone used the free management tool SQL Server Management Studio?
Is it any good? I've been told it's very slow?
Any thoughts?
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |