Viewing 15 posts - 1,561 through 1,575 (of 2,452 total)
bit late......
SELECT DATEPART(mm, OrderDate) AS MonthNum, AVG(orderCount) AS AvgOrderCount
FROM OrderTest
GROUP BY DATEPART(mm, OrderDate), DATEADD(mm, DATEDIFF(mm, 0, OrderDate), 0)
ORDER BY DATEADD(mm, DATEDIFF(mm, 0, OrderDate),...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 14, 2013 at 3:31 pm
http://www.toadworld.com/platforms/sql-server/w/wiki/10392.editing-an-sql-server-table-in-excel.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 14, 2013 at 9:59 am
OnlyOneRJ (10/12/2013)
can anyone help me with scripts one by one for below need 🙁
1) Script to Identify what...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 12, 2013 at 7:49 am
??....why the "shouting"?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 12, 2013 at 7:37 am
Welsh Corgi (10/11/2013)
So consider this post closed.
btw, it is slow for EVERYONE except the developer that created...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 11, 2013 at 3:05 pm
LutzM (10/9/2013)
Why did you open another thread?What about the answers already provided here?
that post was to split into columns.....now it seems into rows.....
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 9, 2013 at 11:54 am
I could be mistaken but it does look like there's a chance for SQL Injection in the dynamic use of the @Pivot variable, though. Correct me if I'm...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 8, 2013 at 4:09 pm
briancampbellmcad (10/8/2013)
I'm trying to find all the records that are 1 week before today and 3 weeks after today including today.
try here
http://www.sqlservercentral.com/Forums/Topic1418640-392-1.aspx
🙂
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 8, 2013 at 2:01 pm
Sean Lange (10/8/2013)
briancampbellmcad (10/8/2013)
into my embeddded query...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 8, 2013 at 1:30 pm
are you MYSQL by any chance.?..this is Microsoft SQL forum
maybe someone else will chime in....
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 8, 2013 at 11:56 am
SELECT
id1,
id2,
STUFF(
(
SELECT ',' + prodID
FROM t p2
WHERE p1.id1 = p2.id1
AND p1.id2 = p2.id2
ORDER BY p2.prodID
FOR XML PATH('')),1,1,' ') ProdIds
FROM t p1...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 8, 2013 at 11:52 am
does this help?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 8, 2013 at 11:39 am
Hello
please see some code (still work in progress) below
the idea is to strip a csv column into separate columns:
the number of columns is indeterminate as is the length of the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 6, 2013 at 1:15 pm
born2achieve (10/1/2013)
thanks for your time on this and i have tried whatever you have shown couple of days before, the problem is time consuming and how to fasten the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 1, 2013 at 2:20 pm
you appear to want to match "corn" with "cornil"...is this correct?
some set up data to play with,,,,,
CREATE TABLE [dbo].[Table1] (
[id] [bigint] NULL,
[product_name] [nvarchar](1000) NULL,
[quantity] [int] NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[Table2]...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 1, 2013 at 12:05 pm
Viewing 15 posts - 1,561 through 1,575 (of 2,452 total)