Forum Replies Created
Viewing 15 posts - 1,351 through 1,365 (of 2,171 total)
-
RE: Time, Count(Hits)
CREATE TABLE #LoginTrack (RowID INT IDENTITY(1, 1) PRIMARY KEY, LoginDateTime DATETIME)
INSERT #LoginTrack
(
LoginDateTime
)
SELECT ...
-
RE: Stored Procedure and Parameters with Derived Tables
Never ever name your stored procedures with sp_ !!!
CREATE
PROCEDURE dbo.uspDateRangeCounts
(
@StartDate DATETIME,
@EndDate DATETIME
-
RE: master..xp_cmdshell errors
That's why you always need to PRINT the statement when using dynamic sql.
Then you will see what is wrong.
-
RE: JOINS based on two possible ids?
Then use this
SELECT t2.*
FROM @table1 AS t1
INNER
-
RE: Multiple aggregates using PIVOT
SELECT
[Part Number],
SUM(CASE WHEN Product = 'BOM1'
-
RE: JOINS based on two possible ids?
What if there are ID's with values of -1 or -2?
OP hasn't told us.
-
RE: JOINS based on two possible ids?
Keep it simple!
SELECT
t2.*
FROM @table1 AS t1
INNER
-
RE: T-SQL question
Show us the code, and we might help you rewrite it SET-based.
-
RE: Time, Count(Hits)
-- Prepare sample data
DECLARE
@LoginTrack TABLE (LoginDateTime DATETIME)
INSERT
@LoginTrack (
-
RE: Very confusing problem..Please help me friends!!
DECLARE
@MyTable TABLE ([Service] VARCHAR(30), PatientNo INT, StartDate...
-
RE: Converting a smallint to time
Keep it simple. Why use 114 (with milliseconds when source data is not?
SELECT CONVERT(VARCHAR, @Sec, 108)
-
RE: Help
Create table #temp (<many column definitions here>
insert #temp
exec DANCA].[dbo].[sel_genelsatisfiyat3] @urunid, @ekurun, @firmid, @fiyatkategorisi, @orderdate, @bfiyat3 OUTPUT , @pbrm3 OUTPUT
Or write stored procedure as...
-
RE: Creating view - Join on date
Have you tried writing BETWEEN instead of IS IN? And replacing the comma with "AND"?
left join forcastTable AS t2 on t1.date between t2.date - 7 AND t2.date
-
RE: Column Extraction
Really?
Post the "PRINTED" query here.
Viewing 15 posts - 1,351 through 1,365 (of 2,171 total)