Viewing 15 posts - 1,021 through 1,035 (of 2,452 total)
this article may give you some pointers
http://www.sqlservercentral.com/articles/T-SQL/88244/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 23, 2015 at 9:25 am
try this
SELECT LID
FROM TEST_TABLE_Dupe_Pay
GROUP BY LID
HAVING DATEDIFF(d, MIN(DraftDt) , MAX(DraftDt)) <=3
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 23, 2015 at 8:19 am
SQLPain (10/20/2015)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 23, 2015 at 8:00 am
sreeya (10/20/2015)
The same Customer may purchase multiple times on the same day plus we have about 100 millions of active users. As I said facts table is pretty big with...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 20, 2015 at 8:42 am
Good resource can be found here by Jeff Moden
http://www.sqlservercentral.com/articles/Test+Data/88964/
DECLARE @NumberOfRows INT,
@StartDate DATETIME,
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 20, 2015 at 4:00 am
to start with....does this work?
WITH CTE
AS (SELECT
*
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 19, 2015 at 9:01 am
malcolm.garbett (10/18/2015)
Hope I'm posting in the correct area.
I have a table with constantly changing data - stock.
I want to start monitoring the value of stock at the end of each...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 18, 2015 at 11:40 am
elham_azizi_62 (10/16/2015)
hello all.please help me about my query.
based on the latest sample data....what results are you expecting?
please provide details
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 17, 2015 at 4:13 am
havent you asked this type of question before?
http://www.sqlservercentral.com/Forums/FindPost1719078.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 12, 2015 at 4:41 am
LeeFAR (10/7/2015)
I have a table of sales. The table has fields for...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 7, 2015 at 2:39 pm
maybe....
CREATE TABLE #sampledata(
StrId INTEGER NOT NULL PRIMARY KEY
,PersId INTEGER NOT NULL
,percentId...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 6, 2015 at 12:36 pm
elham_azizi_62 (10/6/2015)
thanks so much for your reply.
??... does it work for you ...??
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 6, 2015 at 6:26 am
elham_azizi_62 (10/5/2015)
dear J Livingston.I mean dynamic generating columns.in fact if my column is null,column isn't shown.
....not entirely sure that I understand your requirements....but try this
CREATE TABLE #sampledata(
PersonID int NOT...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 6, 2015 at 2:50 am
Welsh Corgi (10/5/2015)
I have 1 Table has been refreshed since the 29th of October.I checked other tables and they are being refreshed.
How can I identify and correct the problem?
Thanks.
excuse me,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 5, 2015 at 3:03 pm
ChrisM@Work (10/5/2015)
TomThomson (10/3/2015)
ChrisM@Work (10/1/2015)
David Burrows (10/1/2015)
Many many moons ago when I frequented London pubs it was either RamRod and Special or 80/- Heavy
Gosh David you must be an old git...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 5, 2015 at 10:37 am
Viewing 15 posts - 1,021 through 1,035 (of 2,452 total)