Viewing 15 posts - 2,926 through 2,940 (of 10,144 total)
pwalter83 (9/12/2014)
ChrisM@Work (9/12/2014)
September 12, 2014 at 5:03 am
If the existing function has been in use for some time then you should assume that it is tried and tested and wherever it’s in use, any changes to it...
September 12, 2014 at 3:40 am
USE TEMPDB
/*
CREATE TABLE MG_COUNTRY([COUNTRY_CD] [varchar](2) NOT NULL,[COUNTRY_DSC] [varchar](35) NOT NULL)
INSERT INTO MG_COUNTRY VALUES ('GB','United Kingdom')
CREATE TABLE [dbo].[MG_BANK_CALENDAR](
[COUNTRY_CD] [varchar](2) NOT NULL,
[BUSINESS_DT] [datetime] NOT NULL,
[BUSINESS_TYPE_FLG] [char](1) NOT NULL,
[DELETED_FLG] [char](1) NULL,
CONSTRAINT [PK_MG_BANK_CALENDAR] PRIMARY...
September 12, 2014 at 2:28 am
pwalter83 (9/11/2014)
the lag should be 1 (rounded off)
and that too in decimal format
ignoring the half an hour afterwards
it just takes the date part into consideration and not the time
I hope...
September 11, 2014 at 9:41 am
pwalter83 (9/11/2014)
ChrisM@Work (9/11/2014)
"Number of holidays for country between dates", the name of the function, gives the game away. Are there any holidays which don't last a full day? If...
September 11, 2014 at 8:34 am
Hi Paul
"Number of holidays for country between dates", the name of the function, gives the game away. Are there any holidays which don't last a full day? If there are,...
September 11, 2014 at 7:13 am
Referring to your original post in this thread:
tony28 (8/25/2014)
I have one small table about 150rows and second bigger about 50000rows
Three tables are referenced in your query:
Table [TB_WORK_ORDERDTL_CPM01] 10,856,500 rows
Table [TB_CODE_PRTFORM]...
September 11, 2014 at 5:45 am
tony28 (9/10/2014)
Hello guys, I disscused with one DB specialist and I found solution for my problem...because with data in statistics was very good results,
...
tony28 (9/10/2014)
September 11, 2014 at 1:24 am
Sean Lange (9/10/2014)
ChrisM@Work (9/10/2014)
Heh Fingers on Fire, Sean!Nah. I cheated and used poorsql.com. 😉
"Put your mangled SQL in the box below" - then jump up and down on it.
September 10, 2014 at 9:37 am
Thanks. Here's that query reformatted for readability, to show how ghastly it is. In addition to points raised by Sean and others, the table loan_balances is read five times where...
September 10, 2014 at 9:20 am
-- If you change your correlated NOT IN subquery to a standard NOT EXISTS subquery like this:
SELECT *
FROM Full_Address_Map fam
WHERE NOT EXISTS (
SELECT 1
FROM tbl_street s
INNER JOIN tbl_place...
September 10, 2014 at 7:59 am
artisticcheese (9/9/2014)
September 10, 2014 at 1:59 am
Priya004 (9/10/2014)
Hey..i got the reason after posting the query..Im clear nowAnyways Thanks a lot!
Can you post your chosen solution please?
September 10, 2014 at 1:39 am
-- You can't specify a table name as a variable in a statement in TSQL. Your best bet is dynamic SQL: http://www.sommarskog.se/dynamic_sql.html
EXEC('DELETE FROM ' + @Table_Name)
-- or
DECLARE @sql NVARCHAR(MAX) =...
September 9, 2014 at 3:33 am
Viewing 15 posts - 2,926 through 2,940 (of 10,144 total)