shindle 17293 (6/15/2015)

---

I have a WHERE clause in a DELETE statement and the x.[Timestamp] field is the PK:

DELETE x

...

You've found a solution? If so, please share it.

Would you be able to provide some DDL and sample data for this?

What data are you looking to use from the other 2 tables?

hah I try my best Dwain!

dwain.c (6/7/2015)

---

reader97 (6/5/2015)

---

Hi every one, I am new to SSC . I have a table that has NO.OF WORKING HOURS for 30 days. I am trying to convert all the...

luissantos (5/28/2015)

---

Hello comunity

I need to build TSQL query to return the Last unit Cost from my table of movement of goods SL (on CTE)

but the MAX(Datalc) must be Less or...

Small example

DECLARE @TestA TABLE

(

ID INT IDENTITY(1,1) NOT NULL,

Chuff CHAR(1) COLLATE SQL_Latin1_General_CP1_CI_AS

);

DECLARE @TestB TABLE

(

ID INT IDENTITY(1,1) NOT NULL,

Chuff CHAR(1) COLLATE SQL_Latin1_General_CP1_CS_AS

);

INSERT INTO @TestA (Chuff)

VALUES ('a'),('A'),('á'),('a'),('A'),('B'),('b'),('1'),('á');

INSERT INTO @TestB...

Collation will determine how data is sorted and compared, for example should case sensitivity be taken into account when comparing strings etc.

If in this case each column has a different...

daniel.globalstudio (5/28/2015)

---

I have a basic level of t-ql, but can not get me pull this query results. Sorry by my bad english

SELECT pcm.CategoryId, pcm.ProductId, c.mlCode, mlc.code

FROM [cpr_data_bak].[dbo].[Product_Category_Mapping] AS pcm

JOIN [cpr_data_bak].[dbo].[Category]...

That's a function I use to generate a numbers table

this is the function below, I imagine some here have one with a few extra performance tweaks

CREATE FUNCTION [dbo].[GetNums]

(

@low AS BIGINT,

@high...

emadkhanqai (5/28/2015)

---

This is the solution :

DECLARE @startDate date , @endDate date;

SET @startDate = ( SELECT proj_start_date FROM [BSD].[dbo].[d_project_p] WHERE proj_id = 1)

SET @endDate = ( SELECT proj_end_date FROM...

I can explain the code sample if you're unsure how it works.

The sample uses a tally or numbers table to help generate the date ranges from the date variables provided...

If the data you want is always separated by the and in this way, just add the spaces either side, which will eliminate any strings containing the letters and.

SELECTSQ1.SomeStuff

FROM

(

VALUES('Andrea'),

('Anderson'),

('England'),

('A and...

Just so I'm clear you wish the dates to display as Monday - Sunday, but if the fromDate is not a monday, you wish to start on that day and...

Would you be able to provide any sample DDL for the tables you are trying to update?

You guys are quick today!