Viewing 15 posts - 8,731 through 8,745 (of 13,876 total)
atul.jadhav (1/27/2015)
Dear Phil Parkinyes, that's why I created table and have separate Year and Month column in my excel/sql table
please give way
I told you the way. I'm not going to...
January 27, 2015 at 3:53 am
atul.jadhav (1/27/2015)
It seems that your ideal flow would be something like:
1) Process Excel file. For each row:
2) Does row exist in...
January 27, 2015 at 3:12 am
Is there a unique key in the source Excel data?
It seems that your ideal flow would be something like:
1) Process Excel file. For each row:
2) Does row exist in target...
January 27, 2015 at 12:11 am
sm_iransoftware (1/26/2015)
Which search? (select from dmv's or select from taht table)
I have no idea what you mean. Did you check the link?
January 26, 2015 at 5:58 am
sm_iransoftware (1/26/2015)
Then what is the best way to get Unused indexes?
January 26, 2015 at 5:46 am
k.allen.emt (1/25/2015)
Phil,that looks like it would work for data you give to the statement itself.
I'm looking to go through close to 6 million records in leadsdb.leads
not manually do it
There was...
January 25, 2015 at 7:28 am
Try the following:
with data
as (
select PhoneNo = '727-555-1234'
...
January 25, 2015 at 5:40 am
mister.magoo (1/24/2015)
Just click on the "Columns" node in Object Explorer, then press F7 to open the details view...
January 25, 2015 at 5:30 am
ScottPletcher (1/23/2015)
Phil Parkin (1/23/2015)
Steve Jones - SSC Editor (1/23/2015)
ProductId would...
January 23, 2015 at 9:23 am
Steve Jones - SSC Editor (1/23/2015)
ProductId would look funny to...
January 23, 2015 at 8:48 am
ScottPletcher (1/23/2015)
I don't get why just "ID" is fully capitalized. Why not "addr"?Why is it:
ProductID
but:
ProductAddr
rather than:
ProductADDR
Why selectively capitalize just one abbreviation? Why the inconsistency?
Exactly. I think it must...
January 23, 2015 at 8:45 am
ZZartin (1/23/2015)
On another note on the most jarring experience I had with naming conventions was using an open source ecommerce...
January 23, 2015 at 8:37 am
I cannot see how you could use PIVOT to generate the same results as your SELECT ... UNION example.
Would you be so good as to post the solution please?
January 23, 2015 at 8:13 am
Jeff Moden (1/23/2015)
Doesn't Intellisense do what you want here? Or are you looking for the datatype and constraints, etc, as well?
This is not about cutting code – SQL Prompt...
January 23, 2015 at 7:39 am
ScottPletcher (1/22/2015)
--But, ProductId seems right to me if you're going to camel case.
--
Camel case would be productId. ProductId is Pascal case 🙂
January 23, 2015 at 12:54 am
Viewing 15 posts - 8,731 through 8,745 (of 13,876 total)