I need to dedupe a string made from concatenated fields before I send the string off to be split.
The leftmost word needs to be kept of the dupes.
'XF XF 250 ATV-2 TERRAHAWK' and this 'XF 250 …
Could you please have a short look on the below code, simply I would like to create a temp table with name #tRecAccountsPivot based on that pivot:
But something is …
SQL> INSERT INTO EMP6(EMPNO,ENAME,SAL) VALUES(1234,'MIHIR',3000);
INSERT INTO EMP(EMPNO,ENAME,SAL) VALUES(1234,'MIHIR',3000)
ERROR at line 1:
ORA-01400: cannot insert NULL into …
is resulting in the itemsOrdered being multiplied by the number of items and the itemsShipped being multiplied by something as well.
I'm not sure what more info you guru's …
Hi, Hope someone can help (using SQL server 2005)...
I have 2 queries that both work perfectly, but I would like to incorporate the second query in to the first so it returns 1 row..
what I …
I have this query, but it needs to work as a view in SQL Server:
IIf(IsNull([packaging]),"","|") & [packaging] &
I have the string 'A1 MK1 (8X) SPORTBACK TDI S LINE'
'A1' is the first word
'MK1' is the second word
'(8X)' is the third word
'SPORTBACK' is the fourth word
'TDI' is the fifth word
'S' is the…
I want to generate below list :
TMCUSTOMER ("0015 ", " ", "CASH ", "CASH ", "Jl.Samratulangi …
I am trying to create a view in SQL 2014 and grouping it but whenever I create it as follows I get the timeout expired error. When I just create the view without the grouping it runs just fine and the…
Dear all brother and sister, i am working on VB.Net application with SQL Server, now i have table adapter and i copy my query to run on SQL Server it execute well, but when i click next in …
A existing SQL statement that converts DateTime to a different format has been working for a long time, but is now give me a "Query timeout expired" error only seconds after the query is executed.
I have a contact company table. In the table I have two columns.
Company = This is the actual company name.
Alpha = This is a field that strips the word "The" from the company name and sets all …
I have the entire contents of a table, with headers, in a CSV file.
How do I import it into a file?
I have a SQL query that sums totals based on the current year and dumps those totals in to monthly buckets. For the sake of this question I only have Jan listed in the query however my output is from …
I use the following type of connection string to connect to a SQL database from VB.net. Is it possible to alter the connection string so that the connection is read only?
I have this query
CompareFlag = 'Y'
WHERE (batch_id IS …
Hi. I'm trying to set up an odbc connection from client machine (windows 7) to Sql Server (2008 r2 express) using Windows Authentication. The only driver available is sql server with no native …
I am looking for books/resource to learn SSIS and I prefer learning SSIS of SQL server 2014/2016, please suggest:
in my list, I have:
Hi, I have this query (using SQL server 2005)...
sum(h.val) AS sales
FROM sysdaa.scheme.stockm s
left join sysdaa.scheme.opsahistm h
on s.product = …
Hello experts. I am not an access expert so I'm hoping to get some help here. I have an ms access form on the front end connected to a sql database. The form has several tabs. On the payroll tab there…
Was wondering if anyone can help me out here...
I 'inherited' a spreadsheet to fix...apparently in Excel, a row 'appears' to be missing some data.
If you look at the highlighted area, …
Can anybody correct me with the below query where the query is going wrong ?
For the below Query i need to add where clause and get based on client names. When i execute the query i am able …
I have the following data:
Value ReadingTime EntityID ServicePointChannelID
0.273 2017-05-17 00:15:00.000 76058805 1
0.272 2017-05-17 00:30:00.000 76058805 1
0.274 2017-05-17 00:45:00.000 76058805…
I wanted to alter the size of a column but sql server wont let me.
the error is
i tried like this:(CODE)
For example i have got the data in a table like below
So if i query (CODE)
is it possible that i rank the search according to the search criteria so that everything which …