Topics
Started by
Posts
Last post
hello guys how can i convert my dates in my table right now as DDMMYY to the default date format MM…
4 replies
The Situation I work for a company that farms, harvests and processes Greenshell Mussels. The 'Muss…
25 replies
AOA I have some integer values like 131000 220000 230000 500000 . . How to convert these integers t…
8 replies
I'm trying to set a default value for a parameter i have defined in a stored procedure. What i have…
3 replies
Hi, I have a project where I need to convert an XML field to relational data and map the value to a…
4 replies
I have a query that is giving an error, and I understand why it is giving an error, but and I want …
11 replies
HI I'm trying to run a scrit that will output csv file can you please help set ANSI_NULLS ON set QU…
5 replies
I am trying to write a query that will show name, and CCNUM, however within the table I am working …
7 replies
We have many tables in our database that have both a clustered index and non-clustered index on the…
2 replies
I have this table: CREATE TABLE [mcmain].[eqmas]( [eq_nmr] [char](10) NOT NULL, [eq_parent] [cha…
4 replies
HI All, With this basic example is there a hard and fast better route for writing pivots: [Code] --…
3 replies
How to find difference in 2 minutes in two tables... pls provide query...If i use datediff query it…
2 replies
Hi How to load .txt file using OPENROWSET? SELECT * INTO LOAD_TABLE FROM OPENROWSET('MSDASQL', …
5 replies
Hi Folks, Is it possible to break the execution of subsequent batches if some goes wrong in any one…
1 replies
Hi, I've created an SP that selects data based on 2 variables that are passed to it. One is a user…
12 replies
Viewing 15 topics - 9,031 through 9,045 (of 12,234 total)
You must be logged in to create new topics.