Forum Replies Created
Viewing 15 posts - 1,036 through 1,050 (of 5,356 total)
-
RE: Summarize Rows to Field
See if this helps: http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Aye Yi Yi
Thanks for explaining. Sounds cooler than "I can't believe this is happening to me (or us in this case".
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Aye Yi Yi
Bear with me, but what does "Aye, Yi Yi" mean?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: New record column value should be defaulted to the previous value
No shortcut here. And that's good so. Here are some thought on this from SQL Server MVP Kenneth Wilhelmsson:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=158711
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Programming in sql
For the records, here are some more examples of this parsing trick:
http://vyaskn.tripod.com/fun_with_numbers_in_t-sql_queries.htm
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Help me blag a new job!!!
I doubt whether you will find much help around here. SQL Server pros aren't going to be willing to help people "blag" a job in their profession because it kinda belittles...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: New record column value should be defaulted to the previous value
ALTER TABLE YourTableNAME
ALTER COLUMN SerialNo int identity (1,1) not null
Go
Interesting script. Do you think it will work?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Low Bandwidth
Not directly what you asked for, but maybe these tools will help you somehow
http://www.microsoft.com/technet/archive/itsolutions/intranet/downloads/webstres.mspx
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Default CONVERT(INT, GETDATE()) gives 0 (zero) problem
Glad I could help.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Default CONVERT(INT, GETDATE()) gives 0 (zero) problem
...oops, forgot to mention. It works also in EM. You only need to refresh the view.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Default CONVERT(INT, GETDATE()) gives 0 (zero) problem
Are you trying this from within EM???
This works fine for me with QA:
CREATE TABLE [dbo].[Table1] (
[c1] [int] NOT NULL ,
[c2] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Table1]...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Default CONVERT(INT, GETDATE()) gives 0 (zero) problem
First, let me say, that the INT value of today is *not* 38390! Since we are now past 12:00:00 some methods round up which isn't correct. So, the correct value is...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Table Name as Parameter
Welcome here!
You asked a FAQ which is best explained here:
http://www.sommarskog.se/dynamic_sql.html
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Getting the rank (ORDER BY position) of a record in a table
Hm, in this case I'll second Remi.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Numeric multiplication scale problem
See if this helps:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=155613
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 1,036 through 1,050 (of 5,356 total)